Scheduled cloud flow

[nicklim]

Hi all,

I have a scheduled cloud flow that runs everyday.

It then connects to the SharePoint site to extract the Departure date column values

Apply to each - Set the condition to check if the "departure date" column in SP list is equal to the current date and time. 

First condition- formatDateTime(utcNow(),'dd/MM/yyyy HH:mm')

Second condition -  equals(formatDateTime(utcNow(),'dd/MM/yyyy HH:mm'),triggerBody()?['Departure date'])

SharePoint List Departure date column

I did a test run by manually changing the "Departure date" column in SP to match the current time, and or some reason, it only triggers the "If no" statement even when the date and time matches the current one?

I am totally lost, can someone please advise what am I missing here?

Nick

[ManishSolanki]

Hi @nicklim 

Please modify both the conditions:

First Condition: Don't put any expression, just take the 'Departure time' column value from the SharePoint

list.

Second Condition: modify the expression to

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

Below is the screenshot for your reference:

Please remember to give a 👍 and accept my solution as it will help others in the future, if it resolves your problem.

Thanks

[nicklim]

@ManishSolanki 

I tried your suggestion but the Expression result is still returning as false.

Expression result:

SharePoint list Depature date column:

[nicklim]

@ManishSolanki 

On a side note, I've also tried the below expression in the second condition column without any luck.

formatDateTime(convertFromUtc(utcNow(),'AUS Eastern Standard Time'),'yyyy-MM-dd')

[ManishSolanki · Accepted solution]

Hi @nicklim 

I just observed that 'Departure date' field has got time also. In that case, wrap the 'Departure date' field with formatDateTime formula in first condition:

formatDateTime(item()?['Departuredate'],'yyyy-MM-dd')

Here, I have taken internal name of 'Departure date' field as 'Departuredate'. Pls modify the 'Departure date' field name in the expression with the name exit in your SharePoint site.

I hope it will resolve the issue.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

[nicklim]

@ManishSolanki 

Thank you so much, that worked.