My SharePoint Moments

Create a flow that runs only once a week using Power Automate Under the recurrence we can set up the frequency of our flow, in the below flow will demonstrate how we can create a flow that runs only once a week at a specific day and time. We can customize the recurrence based on our BAU requirements.  Follow below Steps - 1. Sign in to MS Flows/Power Automate. 2. Click on "My Flows" - New Flow and choose "Scheduled Cloud Flow".    3. In the Recurrence set up the properties as below it will trigger the only once a week at the scheduled time.     

Get Choice field values in SharePoint using REST api To get values of a choice type column in SharePoint list refer the below method which will give you the all choice type column's values. Just write your list and column name in the below method and you will get your response in the console. function getChoices(){ $.ajax({         url: _spPageContextInfo.webAbsoluteUrl +"_api/web/lists/GetByTitle('List Name')/fields?$filter=EntityPropertyName eq 'Choice Field Name'",         type: "GET",         headers: {             "accept": "application/json;odata=verbose",         },         success: function (data) {             console.log(data.d.results[0].Choices.results);         },         error: function (error) {             alert(JSON.stringify(error));         }     }); }

Sending email reminders based on column value in SharePoint List using Power Automate The above stated flow will trigger a reminder notification based on column value in SharePoint List. We would be using a Scheduled Cloud Flow for the same. Please refer below steps. Follow below Steps - 1. Sign in to MS Flows/Power Automate. 2. Click on "My Flows" - New Flow and choose "Scheduled Cloud Flow". 3. Create a Scheduled flow will repeat itself based on the frequency you will specify and send emails. 4. Get Items from the SharePoint List based on the column value. 5. Loop through each item and trigger send email. I believe above stated steps will help you to implement them in your BAU requirements.