Get files (properties only) is missing a column

[Idan]

HI,

I have a flow that starts by getting all the file properties from a certain library.

There is a column in that library that hosts a string (email address), its real column name is "TestingJson".

For some reason, it only returns the data of the first item but not for any other ones (even though there is data in that column for other items).

Here is the get files action:

Here is the output (both photos from same output):

First item

All others look the same as the below:

Not sure what is happening, appreciate any help!

[Expiscornovus]

Hi @Idan,

I see this flow runs on a schedule. Is it possible that at the time of this flow instance was running the field for ID was empty and somebody updated the item after the flow run?

Can you share/check the version history of item with ID 3 when it was updated and what was updated? 

Can you also share a bit more details about your library? Are you using any kind of check-in, approval or other type of settings?

[Idan]

Thanks for the reply. This is actually still in a private library I am building for use in a few weeks, no check in or any other approval settings. I have not changed or updated the field in the last 5 days.

With regard to item ID 3, I just posted it as an example, there are 46 other ID's in that library but only the first item, ID 1, has the field of 'TestingJson', all other ID's just skip that line all together. That column contains an email address for use down the flow.

I really am not sure what would cause this. The column in sharepoint is of a "single line of text" type, and in the formatting is a special Json code the pulls the email address from the owner column (person field):

{"$schema":"https://developer.microsoft.com/json-schemas/sp/v2/column- formatting.schema.json","elmType":"div","txtContent":"[$Owner.email]","customRowAction":{"action":"setValue","actionInput":{"TestingJson":"Owner.email"}}}

Thanks again.