Filter Gallery from other Gallery selected

(0) Share

Report

Posted on by DennisJarnstal

Hi,

I have a Gallery 1 and 2 where Gallery 1 is supposed to show results based on Gallery 2.

Gallery 2 filters to show only the post connected to the active user. This works fine.

Gallery 1 is supposed to filter based on the shown posts in Gallery 2 where there is a multiple choice column as a Lookup field.

In the image below you can in the top see what "instruktion" is linked to the post (this is Gallery 2), and below that gallery is Gallery1 which I want to display only the linked values, the lookup values that are for the shown posts. So in the below screenshot in the bottom gallery what I want to be shown is "Instruktion Johan, Instruktion 2 and Instruktion 3", but for some reason it shows all of the "Instruktion" that currently is available in the List.

Code used in item of Gallery 1 is

Filter(Instruktioner;Concat(ForAll(Gallery2.Selected.KoppladeInstruktioner;Value = Title);Value))

Thanks for any help

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @DennisJarnstal ,

If you just need to show Instruktions in Gallery2 selected item, please try below formula:

Gallery2.Selected.KoppladeInstruktioner

then set Text of Label to ThisItem.Value

Best regards,

Was this reply helpful? Yes No
DennisJarnstal 44 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

If i use this it only shows the "instruktion" that is connected to the very first item in Gallery1. See below screenshot:

The items in the one called "QCR medarbetare" is not showing.

Best regards
Dennis

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @DennisJarnstal ,

Sorry, I was thinking you just need instruktion belongs to Gallerys selected item. If you need all instruktions in Gallery2, please try below:

Distinct(UnGroup(ForAll(Gallery2.AllItems, KoppladeInstruktioner),"Value"),Value)

and Label Text property in Gallery1 set to:

ThisItem.Result

Best regards,

Was this reply helpful? Yes No
DennisJarnstal 44 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Thank you so much, that did the trick. Works perfectly.

Have a nice weekend.

Was this reply helpful? Yes No