Update Yes/No field if Date is today

[MGH-CWiller]

I am trying to create an automated SLA field

I have a "Date Requested" Field and an "Outside of SLA" field.

Date Requested is formatted as a Date, Outside of SLA is formatted as a Yes/NO / True/False field.

I am trying to automatically update the "Outside of SLA" field if the "Date Requested" is later than "Today"

I understand it will have something to do with the IsToday() field but im not sure if the logic i am trying to apply will work within PowerApps/Sharepoint.

Is this at all possible? I feel like i am treating this too much like Excel but am pretty new to this. Apologies

Thanks for any advice

[mdevaney · Accepted solution]

@MGH-CWiller 

If I understand correctly once per day you want to update an Outside of SLA field in Sharepoint based on the Date Requested.  In my opinion Microsoft Flow would be the right tool to accomplish this task because it allows you to create scheduled workflows.  In comparison, PowerApps is application development tool.

Here's a summary of what you should do in Flow.  I can't provide much more help than this so if you have further questions please post in the Flow Community.  

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/FlowCommunity

General Flow Idea:

1.  Create a scheduled flow the runs at 12:00 AM each day

2.  Get all of the Items in your Sharepoint List

3.  Apply to each list item

4.  Check if the Date Requested is Less Than Today's Date

5.  If Yes Update the Outside of SLA field,  If No do nothing

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

[MGH-CWiller]

This is perfect, thank you