Share
Report
2Hi Power Automate Community,
I have a flow that reads through an Excel sheet with the "List Rows Present in a Table" connector. In this flow, I also have it set to parse through a SharePoint point folder using the "Get File (properties only)" connector.
Basically, I am having this flow check each file name in the SharePoint folder, compare that name to each value in the columns provided in the Excel sheet, and if there is a match, it will use "Update a Row" to fill out the date of when that file was created.
My solution right now is using two "Apply to Each" loops (one for List Rows Present in a Table, and one for Get File (properties only)), and while it theoretically does work, it is taking too much time to run. There are over 400 files in the SharePoint folder and over 900 rows in the Excel sheet, so by my estimate I'm guessing it is running 36,000 instances of checks.
I was hoping that there was a way to use something like a Hash Map or Dictionary to perhaps store my Excel row names as key:value pairs, and then use that to check against the file names given through the SharePoint connector Get File (properties only).
Also, although I technically only need this Flow to run one time, I feel like having knowledge of a more efficient solution would help down the road if I had to mass-update this spreadsheet again.
Any help would be appreciated, thank you!
All responses (
Answers (
