Power Platform Community Forum Thread Details

Hi everyone. Thanks in advance for having a look at this.

I'm most of the way through developing a Powerapp to be used to keep track of my organisation's volunteers, and the clients that are assigned to them.

I'm now trying to create a table or other visualisation of this info. I have 2 sharepoint lists: 'Clients' and 'Volunteers'. The Volunteers list has the 'Title' column used to store the Volunteer ID (such as V001).

Within the app, the client is assigned to a volunteer by filling a column in the 'Clients' list called Assigned Volunteer' in which the Volunteer ID is entered.

I'd like to create a table with the Volunteer's name in one column, and their assigned clients in another column as shown here in my primitive diagram:

Table sketch.png

I have had some success with nested galleries, however as the number of clients assigned to each volunteer can be different, getting the sizing of the items gallery items to fit without scrolling was beyond me - I need to distribute the info to the volunteers via email, so info hidden due to scrolling won't work. Ideally I'd like to generate an email with the list of volunteers and their assigned clients.

Any help here would be appreciated!

Gavin

Categories:

Building Power Apps