Properties not yet Loaded for a Files modifiedBy

[priests123]

Category

• Bug

Describe the bug

When trying to query properties (Id, UserPrincipalName, AadObjectId) of the ModifiedBy of a File, it fails with the following error message:

Property [X] was not yet loaded - X being the name of a property

It is intermittent too. Sometimes it has the property value and other times it doesn't.

Steps to reproduce

Below is the code I'm using:

 var item = await list.Items.GetByIdAsync(itemId, i => i.Id,
    i => i.File,
    i => i.Versions,
    i => i.FileSystemObjectType);

 var file = await item.File.GetAsync(
    f => f.TimeLastModified,
    f => f.Name,
    f => f.CheckOutType,
    f => f.ModifiedBy.QueryProperties(u => u.Id, u => u.AadObjectId, u => u.Mail, u => u.UserPrincipalName));

var modifiedById = file.ModifiedBy.Id // <-- Fails on this line

Expected behavior

After getting the file, the properties on ModifiedBy should be available

Environment details (development & target environment)

• SDK version: 1.12.0
• SDK used in: Azure hosted Web Job
• Framework: .NET v8

[jansenbe]

@priests123 : I'm not able to reproduce this, in my testing I see the fields being populated. When your test fails, do you see a call similar to this _api/Web/lists(guid'35e90389-aead-4fad-8aa6-bf30ea65d198')/items(4)/file?$select=CheckOutType%2cName%2cTimeLastModified%2cUniqueId%2cModifiedBy%2fId%2cModifiedBy%2fAadObjectId%2cModifiedBy%2fEmail%2cModifiedBy%2fUserPrincipalName&$expand=ModifiedBy ?

[jansenbe]

@priests123 : I'm closing this issue per no feedback. If the issue still is there for you then please check above comment and re-open