You’re offline. This is a read only version of the page.
Announcements
8
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:
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
You will need to use a flexible height gallery to do this with a nested gallery inside. I suggest checking out this video https://www.youtube.com/watch?v=ZzQ1t2sQvj8 on flexible height galleries first. Use GroupBy(ClientList, "VolunteerID","info") and Lookup(Volunteerlist, VolunteerID=ThisItem.VolunteerID, VolunteerName) for the text property of a label in the outer gallery. The Inner gallery will use ThisItem.info as its items property.
Share
Report
All responses (
Answers (
