cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ricardinh0
Frequent Visitor

Create a task based on a date in a calculated column

Hey Guys,

 

I am trying to create a task based on a date in a 'Next Deadline' Column.

As this is a repetitive monthly run needing to be completed by the x day of the month - it is a calculated column.

 

Odata filter doesn't like the calculated column from Sharepoint.

Therefore I need to retrieve the list of dates and compare them to today.

 

I've tried many different combinations of apply to each but I just haven't come across the solution.


Any help appreciated.

 

Rich

1 ACCEPTED SOLUTION

Accepted Solutions
Ricardinh0
Frequent Visitor

I've Solved this now.

 

Little did I realise (/notice) that as we are currently at utc -1 hour and the sharepoint time was 00:00 taking away that hour meant the day before was being returned hence why none of my tests worked.

 

addHours was the fix

View solution in original post

1 REPLY 1
Ricardinh0
Frequent Visitor

I've Solved this now.

 

Little did I realise (/notice) that as we are currently at utc -1 hour and the sharepoint time was 00:00 taking away that hour meant the day before was being returned hence why none of my tests worked.

 

addHours was the fix

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,805)