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

(1) Share

Report

Posted on by AC-31101005-0

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!

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 51,803 Super User 2025 Season 2 on at

Like (1)

Report

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.

Was this reply helpful? Yes No