I am not sure if this question has been previously answered so asking it here.
I have a SharePoint Team Site created to share an excel file which has some information used for lookup on my PowerApps Form. How can I update the contents of this file on a regular basis through automation. What are some methods that can help me achieve this.
My first preference will be to replace excel sheet with a SharePoint list which is far easier to maintain.
If that is not an option, trigger the flow manually, on a schedule, or when a file is uploaded. Retrieve updated data from a source like SQL, another Excel file, or an API. Use actions such as "List rows present in a table" to read data and "Update a row" to modify specific rows, or create a table if needed. Finally, save the updated file back to SharePoint by replacing the existing file using "Create file" or "Update file" actions.
This will create a newer version of the file every time.
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.