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)"
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?YesNo
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.
2
Share
Report
All responses (
Answers (
