
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?
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