Scheduled cloud flow

(0) Share

Report

Posted on by nicklim

391

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

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki

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

Expression result:

SharePoint list Depature date column:

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@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')

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
nicklim 391 on at

Like (0)

Report
Copy link

Link copied!

@ManishSolanki

Thank you so much, that worked.

Was this reply helpful? Yes No