web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Get Items Filter not s...

Power Automate

Answered

Get Items Filter not showing list Names

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Brand Spank'n new to Power Automate.

Building a flow to loop through a SharePoint list.

After specifying the site and list name, in Get Items, the filter does not show any of the list columns :

Existing list:

Flow:

I was expecting to see the list columns in the column list on the right. (The KPI variables are ones I created above this step and NOT from the SharePoint list)

What fundamental misunderstanding do I have here?

Thx

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @Anonymous ,

you can use only the information that's already available from one of the actions before the current one. At the time of the 'Get items' action the flow doesn't know what it'll get, all the columns will be available only after that action.

If you want to use a Filter Query you must type it in using the column internal name on the left side, the operator, and the value inside single quotes on the right side, e.g.

Title eq 'ItemTitle'

Was this reply helpful? Yes No

Join the conversation