Filter query syntax

[asafweis]

Hi,

I'm trying to add a filter on a list rows action, but my syntax seems to be incorrect. I have it written as so:

JobID eq @'1234' AND (Event eq 'QC Check' OR Event eq 'Audit')

JobID and Event are the fields. I want the action to list all the records that have a JobID of 1234 and also have an Event as 'QC Check' or 'Audit'

Any ideas?

Thanks.

[MarconettiMarco]

Hello @asafweis ,

from where to you want filter rows? SharePoint? Datavers?

Can you share the detailed flow in Edit Mode?

BR,

Marco

[asafweis]

It's coming from Dataverse.

[MarconettiMarco]

ok @asafweis ,

I suggest to use this Dataverse connector:

and in the List rows action, use the Fetch XML query, got from the Dataverse Advanced Find, it's much easier:

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

BR,

Marco

[asafweis]

Unfortunately I can't see this new connector on this old flow. The new connector only appears on new flows that create. 

Is there anyway to bring up the newer connector?

[MarconettiMarco]

Hello @asafweis ,

could you please re-create the flow?

BR,

Marco

[asafweis]

That would be a lot of work so I would prefer not. 

Is there another way?

[v-jefferni]

Hi @asafweis ,

Could you please share more details about your scenario? What types are the two columns? What error have you got from this action?

As the alternate, you can only apply "JobID eq varJobID" on Filter query and use a Filter array operator to filter the outputs of List rows on the other two conditions. I believe that filter on Job ID has enough restricted the rows getting from data source.

Below is a video about syntax of filter query Dataverse LookUp and Choices columns:

Power Automate Flow odata filter dataverse lookup and choice columns - Bing video

Best regards,

[v-jefferni]

Hi @asafweis ,

Have you solved this problem?

Best regards,

[asafweis · Accepted solution]

Yes I did. I ended up using this:

(crff0_jobid eq '@{body('Parse_JSON')?['EmbedContextParameters']?['varJobID']}' and crff0_event eq 'QC Check') or (crff0_jobid eq '@{body('Parse_JSON')?['EmbedContextParameters']?['varJobID']}' and crff0_event eq 'Audit')