Updating an Item in a SharePoint List based on if today's date is in column

[PipManifold]

Hi there,

I’m trying to use a SharePoint list to build a public view timetable so students can see when someone is available to help them (Tutor).

I want to automate some functionality and I have built a Flow where if the tutor is running late or can’t make there shift they can submit a form and it will mark this on the timetable.

I’m now trying to write a Flow which runs at the end of the day and removes this by checking the date in the ‘Availability note date’ column and if it is today’s date clears the value.

I can’t get my Flow to detect/match the date in the Availability note column.  I’m note sure if this has something with my SharePoint region setup (English - Australian) or if it’s trying to match on hidden time information, etc.

I think I have my expression wrong in my condition however I’m not sure how to fix it.

I’ve tried

utcNow('dd/MM/yyyy')    and      formatDateTime(utcNow(),'dd/MM/yyyy')

Any suggestions would be greatly appreciated.

Here is what I got so far:

[CollabTechie · Accepted solution]

Hi @PipManifold , try the below solution

Expression for variable 

formatDateTime(utcNow(),'yyyy-MM-dd')

Get items filter query (Change DueDate to whatever your date column field name is and be aware of any spaces)

DueDate eq '@{variables('vToday')}'

Hope this helps!
--------------------------------------------------------------------------------------------

If you found my comment helpful, please give a thumbs up. If this resolved your issue, please mark as solution so that others in the community can find the answer. Thanks

[CollabTechie]

Hi @PipManifold , try this approach

Variable expression

formatDateTime(utcNow(),'yyyy-MM-dd')

Get items filter query

Change DueDate to the name of your column and pass in your variable that you initialized up top.

Hope this helps!

-------------------------------------------------------------------------------------------

If you found my comment helpful, please give a thumbs up or accept as a solution so that others in the community can find an answer more easily. Thanks 

[PipManifold]

Thanks so much!

Finally found the last hurdle.  my SharePoint list column has to be in text format!