Skip to main content

Notifications

Power Automate - Building Flows
Answered

Trigger flow when excel file is added to a folder - input content to list

(1) ShareShare
ReportReport
Posted on by 2
I want to populate my MS list with data from excel files. The columns of the tables will match those of the MS list. I have created a manual flow for a specific excel doc, which inputs the data correctly. However, for subsequent files, I don't want to recreate the flow every time for each separate file. 
 
I want the flow to trigger when an excel file is added to a specific folder on SP, then to extract the data automatically and input into the list. 
 
Is this possible and how can I achieve it? I see there are triggers on Power Automate for "when a file is created or modified" but they either state "(properties only)" or "(deprecated)"
 
Thanks!
  • Verified answer
    FLMike Profile Picture
    FLMike 31,580 on at
    Trigger flow when excel file is added to a folder - input content to list
    Hi,
     
    You use the Properties Only one, then us the ID of the file it found to get to the File data itself. There is no longer one that returns the data itself as many people don't need the content loaded into memory, they want to access it, like you do, as an excel file etc, not a blob in memory for which wont look like excel.
     
    So use the properties only one, then use the Url/Name of the file (which are properties) to open the new excel file to do what you want.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard