Search an Search Multiple Choice Field in a Gallery

Like (0) Share

Report

Posted on 29 Jun 2023 17:42:25 by Community Power Pla...

Hello everyone, I have a list with the column "Acronym", that the person can choose more than one Acronym, like in the picture WII + WIT. The Acronym column is the type SEARCH and MULTIPLE SELECT. My doubt is how can I link the search bar with my gallery.

To show the Acronym, I used

Concat(ThisItem.Acronym;Value;",")

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Ami K 15,665 Super User 2024 Season 1 on 29 Jun 2023 at 19:23:06

Like (1)

Report
Re: Search an Search Multiple Choice Field in a Gallery

@Anonymous , to use a Search function on a SharePoint multi-choice field, see example below:

Search( AddColumns( 'Your Data', "_concatAcronym", Concat( Acronym, Value & "," ) ), TextInput1.Text, "_concatAcronym" )
------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No