0

I am trying to filter my Get Items for multiple conditions. So my first condition on its own works fine but when I add the later 2 conditions, my flow fails.

Requester_CostCenter eq 1463 and Specific Automation Type eq 'Testing' and Specific Automation Type eq 'Management Reporting'

What am I doing wrong here?

Improve this question

1 Answer 1

Reset to default
1

I think you are trying to use the "Display name" of list columns in filter query.

However, filter query in Power automate flow works in internal name of list columns (same as SharePoint REST API).

So, try using internal name of columns in filter query. You can get internal name of list columns by following this article: Find the internal name of SharePoint column

Related Microsoft documentation: Use OData query operations in SharePoint REST requests

Improve this answer
4
  • 1
    Thanks Ganesh, how do I find the internal name?
    – Jonnyboi
    Commented Dec 15, 2022 at 16:20
  • Check links in my updated answer.
    – Ganesh Sanap - MVP
    Commented Dec 15, 2022 at 16:21
  • okay so this seems to work, however when adding an Or to my statement it fails. Requester_CostCenter eq 1463 and (SpecificAutomationType eq 'Management Reporting' Or SpecificAutomationType eq 'Testing') but this works: Requester_CostCenter eq 1463 and SpecificAutomationType eq 'Management Reporting'
    – Jonnyboi
    Commented Dec 15, 2022 at 16:37
  • Try using or without capital letters.
    – Ganesh Sanap - MVP
    Commented Dec 15, 2022 at 16:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.