Unanswered

Nested gallery

(0) Share

Report

Posted on by vidarv

Hello,

I want to create a nested gallery. I have two sharePointlist, YearPlan and ActivityPlan. There can be multiple YearPlans for companys containing multiple activityplans.

List1 (YearPlan) PlanID, HumanResoutces, ITResources, Techresource

List2 (ActivityPlan) PlanID, Category, Category2, Indicator

How do I set up the filtering ? on the nested Gallery

First gallery I suppose the Items would be YearPlan

In the nested gallery it should be somthing like

Filter(YearPlan;ThisItem.Title in ActivityPlan.Title)

But this only show the items of the first list.

Can anybody please help me ?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@vidarv

GroupBy(Activity Plan, "PlanID", "Data"). Put a subgallery inside with items: ThisItem.DATA

Add labels in main gallery like

LookUp(YearPlan, ID=ThisItem.PlanID, HumanResources)

Was this reply helpful? Yes No
vidarv on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Thank you for answering. When i use the lookup command I got incompatible type for compare. Can not compare number table

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@vidarv

The outer gallery has PlanID exposed. If you have done it correctly, LookUp(YearPlan, ID=ThisItem.PlanID).columninYearPlan does not involve another table.

Was this reply helpful? Yes No
vidarv on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Drrickryp
The Items in the outer gallery are set to
GroupBy(ActivityPlan;"Title";"Data")
Title =since this is the first coloumn
I can find all the coloumns by dooing the lookup but i still got incompatible types
All the fields in the sharepoint list are text.
LookUp(YearPlan,ID=ThisItem.Title).Manager
Since this will be the approval center in Powerapps. As a workaround. The outer first gallery are showd as
Distinct(YearPlan,Title)
And the nested gallery as
Filter(YearPlan,Title=ThisItem.Value)
I have then filtered the status as Evaluation on both the nested gallery..
Both nested gallerys are then only showing the posts that have status evaluation.
But a cleaner solution would be only one gallery with a nested one.

Was this reply helpful? Yes No