Search concatenated field within gallery

(0) Share

Report

Posted on by ChrisS81

134

Good morning,

I'm hoping someone can help with this issue I'm running into.

I have an app that uses a SharePoint list as a backend data source. The main page of the app is a gallery. One of the fields in the gallery is a concatenated text field that concatenates 4 single line of text columns from the SharePoint List item.

For instance, the columns are "Animal 1", "Animal 2", "Animal 3", "Animal 4".

So for each list item it displays as:

Item 1 Dog, Cat, Bear, Ape

Item 2 Cat, Monkey, Dog, Squirrel

Item 3 Ape, Lion, Bear, Turtle

What I'd like to do is have a drop down of all the possible animals and when I select one or more animals, it filters the gallery to shows the items that have the selected animals. So for instance, if I select "Dog" then Item 1 and Item 2 displays in the gallery.

Is this possible? Please let me know if I need to better explain the scenario. Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ChrisS81 ,

Please try this:

You can use below formula on Items property of control or create collection to save result.

Filter(AddColumns(ListName,"test",Concatenate('Animal 1', 'Animal 2', 'Animal 3', 'Animal 4'),DropDown.Selected.Value in test,ItemColumnName)

Best regards,

Rimmon

Was this reply helpful? Yes No
ChrisS81 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mengmli-msft thanks for the response. I'm having an issue with the formula. I believe it's with the concatenate portion of the formula. Any ideas?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChrisS81 ,

Have you tried above formula? What is the difference between the result and your requirement?

Best regards,

Rimmon

Was this reply helpful? Yes No
ChrisS81 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mengmli-msft yes I tried the formula. Maybe I have the formula wrong. I'm receiving the error message "The function 'Concatenate' has some invalid arguments. Also, just so I'm clear, in the formula what does "ItemColumnName" refer to?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChrisS81 ,

It means your column name. Please replace it with yours. This is also for 'Animal' columns.

The formula will return a table like below.

Best regards,

Rimmon

Was this reply helpful? Yes No
ChrisS81 134 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-mengmli-msft understood. I'm still getting the error message "The function 'Concatenate' has some invalid arguments."

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChrisS81 ,

Could you please show the formula?

Was this reply helpful? Yes No