Announcements
Hi @AdityaDani ,
Please add .Value after 'CAS dependency(Choice)' and it should then work.
You'll need to use the 'in' operator and Concat() to change the values to a string so they are accessible. Something like this.
If(IsBlank(SearchBox.Text),Final_Master, Filter(Final_Master,TextInput1.Text in Concat('CAS dependency(Choice)', Value, " ")))
@Pstork1 Thanks a ton. I love this community. So much to learn
@BCBuizer it only works for one column. I don't know why this ignores the other columns
Can you please clarify what you mean with "one" and "other" columns?
By other I meant I could not search based on other multi select choice column.
But I got it fixed. its working properly
Hi Pstork1,
I am using the concat function for the text property of a Label in order to have Commas, between each record like this. 'CAS Dependency' is a multi select choice type column in SharePoint List(My data source)
But I don't want to print a Comma where there is just one record and on the last record .
EX : Record1,record2,
or Record1,
I tried finding a way where I could count the number of records so that I can use that as a counter for a loop inside a conditional statement but couldn't find any. Please help.
Thanks and Regards 🙂
You can surround the entire Concat with a Left() function to return all the characters minus one.
Left(Concat(everything you have now),Len(Concat(everything you have now)-1)
or use a With
With({NewString: Concat(everything you have now)}, Left(NewString, Len(NewString)-1))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 413
WarrenBelz 355 Most Valuable Professional
timl 315 Super User 2026 Season 1
