If statement in select

(0) Share

Report

Posted on by ccqn

205

Hi all,

Trying to use an if statement to check if an item has reached its due date in a select step but running into some problems as the below formula is invalid.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Andrew_J 1,962 Moderator on at

Like (0)

Report
Copy link

Link copied!

@ccqn

I do think an IF can be added there. It needs to be calcuated before that stage but without seeing the whole of the flow and understanding where the due date is coming from I cannot advise further.

Andrew

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @Andrew_J ,

The due date an excel column. The gist of the flow is to
1. Fetch rows from excel
2. Create HTML table using the rows with an additional column 'Overdue' which is created by checking whether the due date is past today's date.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ccqn ,

Please try:

if( greater(startOfDay(item()?['Due Date']),startOfDay(utcNow()), 'yes', 'no' )

Best Regards,
Bof

Was this reply helpful? Yes No
ccqn 205 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,
It says that the expression is invalid.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ccqn ,

Please try:

if(greater(startOfDay(item()?['Due Date']),startOfDay(utcNow())),'yes','no')

Best Regads,

Bof

Was this reply helpful? Yes No