Hello,
I have made a SharePoint list with yes/no columns and I want the list to reset at the end of each day and store the data from the previous day on powerbi.
I'm not sure if this is possible but I would appreciate any help I can get.
How can I reset my sharepoint list to default automatically at the end of the working day
Hi @gaithghalayini-9872 ,
If you are using SharePoint Online version (which I believe) the reset of the list column can be achieved either using Power Automate or custom PowerShell script.
For Power Automate you can schedule the trigger to update your column with the requested value (yes or no) at a specific day time.
Power Automate includes as well a connector for PowerBI with a set of pre-build actions
1.You could create a scheduled cloud flow as following pictures show to reset the Yes/No column at the end of each day.
2.Power BI is currently not supported in the Q&A forum. Please start a new discussion via the Power BI Community so that you can get dedicated support on this issue. Thank you for your understanding.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
I’m checking how the things are going on about this issue. Whether the answer helps you?
If there is any problem with this issue, feel free to let me know.
I am looking forward to your feedback if there is any update.
Please remember to update this thread if you have any progress.
Thank you for your understanding.
14 people are following this question.
