lookup multiple selected gallery items from table

(0) Share

Report

Posted on by mukeshkavia

Hi,

I have a requirement to use the lookup function with a datasource and multiple items to lookup.

i.e. i have a gallery with checkbox for each item in gallery. let's say a user selects 5 items in gallery, i want to get the lookup of each selected item from a datasource. now, in the lookup function, you can normally only lookup a single distinct value. if you want to find multiple items then you would loop through the multiple items. but, you can't do a loop within a lookup in powerapps.

any ideas?

THanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

hi @mukeshkavia you can use Filter or Search for this. Filter is best for a single column and search for multiple, you can use filter for multiple columns as well but search is better imo.

Give it a try and if you need more info let me know.

Hope it helps,

R

Was this reply helpful? Yes No
Sunil-Narnaware 681 on at

Like (0)

Report

@mukeshkavia first you have to create a collection which would store the records which are selected from gallery by selecting checkboxes.. so OnCheck of Checkbox add the record in collection and on OnUncheck remove it from the Collection.. Now you use ForAll(collection, Filter(Datasource, Value = ThisRecord.Value)) or something similar..

Was this reply helpful? Yes No
Verified answer

mukeshkavia 45 on at

Like (0)

Report

thanks Sunil, this was useful to point me in the right direction. i didn't have to use ForAll. I just updated my Patch formula to include the lookup

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @mukeshkavia ,

Have you solved this problem? It seems you figured it out but could you please share your formula to help other users?

Best regards,

Was this reply helpful? Yes No
Verified answer

mukeshkavia 45 on at

Like (0)

Report

Hi,
I used the lookup function with the text object of the gallery rather than trying to lookup all the data at once.

Was this reply helpful? Yes No