If statement in select

Like (0) Share

Report

Posted on 8 Apr 2024 01:43:48 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.

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-bofeng-msft on 08 Apr 2024 at 02:42:31

Like (0)

Report

Re: If statement in select

Hi @ccqn ,

Please try:

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

Best Regads,

Bof

Was this reply helpful? Yes No
ccqn 205 on 08 Apr 2024 at 02:40:41

Like (0)

Report

Re: If statement in select

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

Was this reply helpful? Yes No
v-bofeng-msft on 08 Apr 2024 at 02:31:30

Like (0)

Report
Re: If statement in select

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 08 Apr 2024 at 02:11:01

Like (0)

Report

Re: If statement in select

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
Andrew_J 1,962 Moderator on 08 Apr 2024 at 02:04:09

Like (0)

Report

Re: If statement in select

@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