Apologies if I am posting in the wrong forum, but I am currently trying to set up a power automate that I don't know if it's possible.
We recieve monthly reports to a sharepoint folder, I want to know if I can set up an automatic update to a file in another folder, that once a new report/file is added to this folder this Excel will automatically refresh with the content of the previous folder (so that this file includes all the monthly reports).
You can build a flow that triggers when a new file is added to the designated SharePoint folder containing the reports. Use the "Get file content" action to retrieve the new file's data. Then, update the target Excel file located in another SharePoint folder by appending the new data to it. Ensure that the Excel file is formatted as a table for easy data insertion. Test the flow to confirm it correctly updates the Excel file with the new report data. Make sure both the source and target SharePoint folders have the necessary permissions for the flow to operate.
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 (
