I need to create a collection from another collection that has 3 columns, Approver, Approver Email and Employees.
Approver and Approver Email need to be distinct (1 instance of Approver along with their email address) and employees needs to be a concatted column of all the employee display names that belong to the manager.
I am not quite sure how to build the ClearCollect statement to accomplish this.
I have this much
ClearCollect(Managers, Distinct(RequestInnput, Approver))
Where do I go from here or is this even possible?
Solved! Go to Solution.
Hi @JR-BejeweledOne ,
Try:
ClearCollect(
Managers,
DropColumns(
AddColumns(
GroupBy(RequestInput,"Approver","Approver Email","Result"),
"Employees",
Concat(Result,Employees&";")
),
"Result"
)
Hope it helps !
Hi @JR-BejeweledOne ,
Try:
ClearCollect(
Managers,
DropColumns(
AddColumns(
GroupBy(RequestInput,"Approver","Approver Email","Result"),
"Employees",
Concat(Result,Employees&";")
),
"Result"
)
Hope it helps !
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
192 | |
69 | |
50 | |
38 | |
29 |
User | Count |
---|---|
245 | |
112 | |
92 | |
91 | |
71 |