Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Get files (properties only) is missing a column

Posted on by

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:

Idan_4-1707894365119.png

 

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

First item

Idan_3-1707894323913.png

 

All others look the same as the below:

Idan_2-1707894238965.png

 

 

Not sure what is happening, appreciate any help!

  • Idan Profile Picture
    Idan on at
    Re: Get files (properties only) is missing a column

    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.

  • Expiscornovus Profile Picture
    Expiscornovus 30,664 on at
    Re: Get files (properties only) is missing a column

    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?

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard