web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

List Rows filtering using multi column alternate key

(0) ShareShare
ReportReport
Posted on by 107

Hi,

 

I have created a multi column alternate key in a dataverse table. The system job has ran successfully and created the index.

 

For the sake of writing the key uses 3 columns - Presentation, Code, State.

 

I am trying to build a flow using the Dataverse list rows actions to filter based on the alternate key but am struggling with what to put in the filter query. I have read when querying against the Dataverse API you put the query in brackets so something like this (mmm_Presentation eq 'Bold', mmm_Code eq 'ABC', State eq 'DEF').

 

However, if you try to take a similar approach in the flow it complains about using the commas.

 

Does anyone have any suggestions on how you can do this within a flow please?

I have the same question (0)
  • Trutz-Sebastian Stephani Profile Picture
    48 on at
    Re: List Rows filtering using multi column alternate key

    Hi,

    You need to write the filter as follows:

     (mmm_Presentation eq 'Bold' and mmm_Code eq 'ABC' and State eq 'DEF')

     

    You can use the FetchXML Builder Tool of the XRMToolBox to create your query and then use the View Power Automate Parameters option to get the correct values:
    FetchXML Builder - Features

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard