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

gaith ghalayini 1 Reputation point
2022-05-06T11:43:42.457+00:00

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.

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,221 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,621 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,573 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Matteo Zamori 86 Reputation points
    2022-05-06T12:56:16.983+00:00

    Hi @gaith ghalayini ,

    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

    0 comments
  2. Emily Du-MSFT 41,786 Reputation points Microsoft Vendor
    2022-05-09T07:50:50.587+00:00

    @gaith ghalayini

    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.