Unanswered

Unable to filter using calculated sharepoint column

(0) Share

Report

Posted on by Dee-LDRC

Hi...I'm new to PA and trying to build an email reminder to send out a reminder 15 days before expiry date column (calculated column) . The SPO columns are: Email Address (text), Date Subscribed (date/time field) and ExpiryDate (calculated column Date Subscribed+1056)

Attached is what I have tried and understand that you cant filter using a calculated field, so I'm looking for other solutions.

Much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Dee-LDRC

Post "Get items" action, add "Filter array" action. Using filter array action you would be able to filter the data from calculated column.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Dee-LDRC 9 on at

Like (0)

Report
Copy link

Link copied!

How is that suppose to look like? Is this correct? Here are the sharepoint columns. I would like an email sent for every expiry date in the past and up to 15 days prior to the expiry date. I'd appreciate your further assistance.

Was this reply helpful? Yes No
Dee-LDRC 9 on at

Like (0)

Report
Copy link

Link copied!

Or should it look like this?

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Dee-LDRC

In 'Apply to each' action loop, pass the body of filter array action as those are the items for which actions needs to be taken. If you want to get dynamic values using dynamic content window then use 'Parse Json' action.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No