Unanswered

Remainders based on calculated column in SP list

(0) Share

Report

Posted on by JohanSmith001

Hi, I need to send remainders based on a calculated column in sharepoint list (calculated because Items have different times). This is what I've done.

Steps:

Recurrence
Get Items
1. In the field "Filter Query" I compare the calculated column with 2 days before throught the next formula
2. formatDateTime(addDays(utcNow(),-2),'yyyy-MM-dd')
Appy to each
1. Send emails.

The above secuence return an error indicating that the "calculated column" can't be used in the expression (formula).

Error 2.PNG

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @JohanSmith001 ,

Calculated column in SharePoint isn't supported in OData filter query, please consider to use Filter Array action to filter the list based on calculated column. For instance:

Hope this helps.

Sik

Was this reply helpful? Yes No
JohanSmith001 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft I tried using Filter Array action however the step Get Items is requiring something in OData field as shown below.
And other thing, after using Filter Array action, should I use for each action?

Thanks.

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

Like (0)

Report
Copy link

Link copied!

Hi @JohanSmith001 ,

I'm not sure what's intention of sending email? Do you want to send each record individually or as a whole? Please elaborate on it.

In addition, I would suggest you delete and re-create the Get Items action to eliminate that error.

Hope this helps.

Sik

Was this reply helpful? Yes No