Unanswered

Filter dataverse multi choice column

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am trying to grab only rows that contain a related content to populate with a number (say there are 6 rows in the Activities table that relate to the LGA table) - In the LGA table I have the reference number associated with each of the choice options - seemed easier than trying to find the actual name value associated but I am still getting the error "The condition operator Like is not valid for MultiSelectPicklistAttribute type"

The column in Activities table will always have more than one selection, is there a way to be able to filter this table?

Filter rows: contains(ccb_lgam, '@{items('Apply_to_each')?['ccb_reference']}') - this isnt currently working.

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

MarconettiMarco 3,812 Super User 2024 Season 1 on at

Like (0)

Report

Hello @Anonymous ,
have you already considered to filter rows based on the Fetch XML query got from the Dataverse Advanced Find.
In this way you can easily build your query, download the Fetch, copy and paste it in this field:

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the reply Marco, I've never actually used the advanced find?

Does it require a relationship? I found this resource but it doesn't really explain how to use it as you've described.

I have found a work around using a filter array but would love further instructions as you've peaked my interest - it could be a better way of doing it.

Was this reply helpful? Yes No