Hi @Rokuro Asai ,
Thanks for posting in the community. For your problem you can run flows on a schedule.
1) Go to Power Automate->My flows->New flow->Scheduled cloud flow
2) In Recurrence step, you can set Interval , Frequency(In my test is 1 minute, you can set 1 week) and Start time.
3)Next step is to get items from list. Select the list you want to export items to.
4)Select the content you want to output, fill in the "value" in From, and then map the column names in list with the column names you want to. output to excel.
- Create CSV table.
6)Create file, select the address you choose to save the excel (In my test is TestCase site/Library Sample/Document Sample/Export Excel/), fill in the file name (.csv file suffix), and choose "Output" for the file content.
Also, since I exported the excel file under the same file, the file name has to be kept different, so I added the time when the file was generated in the file name.
- Save flow, then flow will go to export items on time. I tested it on my side and it works well.
To learn more, please see Reference:
Run flows on a schedule in Power Automate - Power Automate | Microsoft Learn
How to export SharePoint List items to excel using Power Automate and send email [Step-by-step tutorial] - SPGuides
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".