question

gaithghalayini-9872 avatar image
0 Votes"
gaithghalayini-9872 asked EmilyDu-MSFT commented

How can I reset my sharepoint list to default automatically at the end of the working day

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.

office-sharepoint-onlineoffice-sharepoint-server-developmentoffice-sharepoint-server-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MatteoZamori-0183 avatar image
0 Votes"
MatteoZamori-0183 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

EmilyDu-MSFT avatar image
0 Votes"
EmilyDu-MSFT answered EmilyDu-MSFT commented

@gaithghalayini-9872

1.You could create a scheduled cloud flow as following pictures show to reset the Yes/No column at the end of each day.

200118-image.png

200135-1.png

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.



image.png (56.0 KiB)
1.png (38.8 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@gaithghalayini-9872

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.

0 Votes 0 ·

@gaithghalayini-9872

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.

0 Votes 0 ·