web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Content of related lis...

Power Apps

Answered

Content of related list in gallery

(0) Share

Report

Report

Posted on by uwenagel

382

I'm working on an app for task management. It contains (among others) two lists: The first one contains the tasks and the second one contains all the people, that are working on the specific tasks. The two lists are related by the task ID from the main list.

Now I want to show the tasks in a gallery. One field should show the names of all the people (from the second list) that are working on that specific task, concatenated in one string.

I tried several syntax possibilities but either received an empty string or all the items from the second list show on each line of the primary list.

Can someone tell me what is the right syntax?

Thanks.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

uwenagel 382 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I should illustrate my problem to help people understand what I'm trying to do.
These are the two tables:

TableA

ID
Task
1 Task A
2 Task B

Table B (related table with TaskID being a lookup to the ID of the first table)

ID TaskID Supporter
1 1 Name A
2 2 Name B
3 1 Name C

The result should be like this

colResult

ID Task SUPPORTER
1 Task A Name A; Name C
2 Task B Name B

I tried the following syntax:

ClearCollect(colResult,AddColumns(Table A,"SUPPORTER",Concat(Filter(Table B,TaskID.Id = ID),Supporter,"; ")))

but it always shows 'Name A' in the SUPPORTER results column.
Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @uwenagel , welcome to the community

There are a few ways to do this I will use filter.

consider the two sources:

__Tasks with and id and task name.

__Assignees with a task id and assign name

__Tasks (id, task)

_Assignees (task id, assignee)

Lets use filter to get all the assignees assign to the task id, which will be part of the gallery showing the __Tasks

add a label to the task gallery and set the text to the code below

Concat( Filter( __Assignees, id = ThisItem.id ), assign, "," )

The result

How many teasks do you have on average?

Hope it helps,

R

Join the conversation