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 / Excel: List rows prese...
Power Automate - Building Flows
Unanswered

Excel: List rows present in table and issues with "for a selected file" trigger

(0) ShareShare
ReportReport
Posted on by FbK1000 2

I am trying to read rows from an excel table (the table exists!) and populate a sharepoint list. I get this to work if i specify the actual file in the List rows present in a table - it reads the column headers, BUT when i use the dynamic file selected in the trigger, it fails to read the column headers.

 

I found a work around that is to set up the create item action with an actual file and then return it to a dynamic file. However, i find this to be not robust enough.

 

Any tips on this issue? cheers

 

I have the same question (0)
  • ManishSolanki Profile Picture
    ManishSolanki 15,089 Super User 2025 Season 2 on at
    Re: Excel: List rows present in table and issues with "for a selected file" trigger

    Hi @FbK1000 

     

    You need to add "Get file properties" action to get the file identifier and use this file identifier in "List rows present in a table" action to get the records.

     

    Here is an example:

    ManishSolanki_2-1718970181568.png

    Add "Get file properties" before "List rows present in a table" action. Pass the ID from the trigger.

    ManishSolanki_0-1718970105399.png

    Pass the file identifier to the 'File' parameter from the output of previous action:

     

    ManishSolanki_1-1718970158413.png

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

     

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 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

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