Answered

Power Automate - using the Filter Query on Get items to filter SharePoint items

(0) Share

Report

Posted on by Dog_mom

Good morning.

I've been working on a flow to filter SharePoint items but getting an error when I test the flow. The error states the column does not exist.... but it does. Unless I'm grabbing the name in the wrong place. Attached are screenshots to better explain my process. Thanks for any help!

Column Name:

Filter Query:

Error:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Dog_mom

Just a try have you tried using the column name as 60daysnotification

Was this reply helpful? Yes No
Verified answer

Pstork1 69,129 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you run the flow without using the odata query and limit the returns to the top 5 what does the field name look like in the output? That should be the name you want to use. Some of the fields may be inside {} braces. Those are part of the field name in this case.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Dog_mom

If this is a calculated column then it will not work in the OData zfilter

Was this reply helpful? Yes No
Dog_mom 12 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your help! The output gave me the correct name for the column I needed. Based on my output, I needed to add OData_ to the front of the name. Great troubleshooting tip as well! Many thanks to you!

Was this reply helpful? Yes No