web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter Query using a c...

Power Automate

Answered

Filter Query using a calculated column from a SharePoint list

(0) Share

Report

Report

Posted on by PaulSGodden

47

Have a job that pulls together daily figures however it fails when I get to the category that filters via calculated field

Can see that this is not possible in its current form. Any bright ideas or workarounds welcome. Thanks

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!

For Get items the Filter Query doesn't currently support calculate columns.

I'd suggest filtering out as much as you can within the Filter Query (using non-calculated columns), then use a Filter array to filter further on your calculated column.

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.

Was this reply helpful? Yes No
PaulSGodden 47 on at

Like (0)

Report
Copy link

Link copied!

Hi Grant. Thanks for the response. Partial success but still an issue

Thanks in advance

Was this reply helpful? Yes No
Verified answer

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
In your Compose 2 action try the following to get the length. That's assuming you're trying to find out how many items were returned.

length(body('Filter_array'))

Was this reply helpful? Yes No

Join the conversation