web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Get files (properties ...
Power Automate - Building Flows
Unanswered

Get files (properties only) is missing a column

(0) ShareShare
ReportReport
Posted on by 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:

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!

I have the same question (0)
  • Expiscornovus Profile Picture
    Expiscornovus 32,859 Most Valuable Professional 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?

     

  • 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.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 650 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 341 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans