Using contains for Filter Rows in List Rows for a lookup column

(0) Share

Report

Posted on by evalindag

117

Hi everybody

I'm trying to List Rows from Dataverse where a Lookup Column value (_st2_group_value) is equal to any of the items in a array I have composed in a previous step (see screenshots) ->

raw input:

{
 "host": {
 "connectionReferenceName": "shared_commondataserviceforapps",
 "operationId": "ListRecords"
 },
 "parameters": {
 "entityName": "st2_bookings",
 "$filter": "contains([\"38eca23e-faeb-ec11-bb3d-6045bd8ea63b\",\"42eca23e-faeb-ec11-bb3d-6045bd8ea63b\"],_st2_group_value)"
 }
}

I get the following error:

I would really appreciate it if somebody could help me 🙂

Best regards

Eva

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @evalindag ,

Unfortunately, odata query cannot use column name as the second parameter.

I suggest you create a filter action after 'List rows' action.

Best Regards,

Wearsky

Was this reply helpful? Yes No
evalindag 117 on at

Like (0)

Report
Copy link

Link copied!

@v-xiaochen-msft
Thank you, this worked 🙂

Best regards
Eva

Was this reply helpful? Yes No