Hello therush,
You could set one daily schedule flow to create one csv file per day named with today's date time and get all CDS entity data into the sharepoint new file content. I made following template for reference.
@Johnnyg Thanks for the help but I am stuck at the last part trying to write the data to my table.
It is throwing back an error on the last action: A value must be provided for item.
Helpful resources
Join us for Microsoft Power Platform Conference
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Register for a Free Workshop
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Help make Flow Design easier
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!
