I am looking to get a subset of Accounts from CDS/Dynamics, filtered by a multi-select option set.
On our Accounts Entity we have a mutli-select optionset call Relationship Type, I want to retrieve just the Accounts with the Relationship Type of Member.
I've tried the following based on other posts:
ClearCollect(collectMyMembers, Filter('Accounts', CountRows(Filter('Relationship Type', Value = [@'Relationship Type'].Member))>0))
or just simple:
ClearCollect(collectMyMembers, Filter('Accounts', 'Relationship Type' = "Member")))
Just get an invalid argument error on the equals sign.
Thanks in advance.
Go to Solution.
Hi @Brisbane_Jones ,
My workaround is to create a new column to store the concatenated selections, and it will be much easier to filter by than Multi-selection OptionSet field.
ClearCollect(collectMyMembers, Filter(AddColumns('Accounts',"NewColumn", Concat('Relationship Type',Text(Value))), "Member" in NewColumn))
Hope this helps.
View solution in original post
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.