Build PowerApp using Gallery to populate multiple rows from Ref table

(0) Share

Report

Posted on by prabakar21

Hello,

Requesting support on building an application using PowerApps for the following sample requirement.

Build a ‘Project Allocation app’ using which users should be able to select and assign multiple employees to a project and add allocation to them in one shot.

Allocation table structure is shown below- Employee ID and Project ID act as composite key for this table which are primary key in Emp and Project tables respectively.

I have built an application using Radio control, gallery and Edit Forms which facilitate adding one employee at a time. (as shown below). Employee Names in Radio button are populated from Employee table, Project Names for Gallery are populated by Project table. The Edit Form loads the data to Allocation table.

But the requirement is to on-board multiple employees at a stretch.

Request any ideas/suggestions on building this requirement please.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

gizmobrat 63 on at

Like (0)

Report
Copy link

Link copied!

My suggestion would be to create a collection as a buffer to hold all the employees you wish to onboard. An then have a button that does a ForAll command with the Patch function.

Was this reply helpful? Yes No
prabakar21 29 on at

Like (0)

Report
Copy link

Link copied!

Hello, Thanks for your quick note. I am pretty new to PowerApps and find challenges to build the logic., appreciate your support on some sample code snippet or any reference links please.

Was this reply helpful? Yes No
gizmobrat 63 on at

Like (0)

Report
Copy link

Link copied!

When you load multiple people onto a project are all the dates the same? If so that would make it easy. Otherwise, you might have to go through multiple edit forms in a row.

Was this reply helpful? Yes No
prabakar21 29 on at

Like (0)

Report
Copy link

Link copied!

The dates may not be the same always. I guess, would need to have multiple forms added based on the number of employees selected.

Was this reply helpful? Yes No
Deek 31 on at

Like (0)

Report
Copy link

Link copied!

@ShaneYoung has a great video of forall and patch which I believe are some of the mechanics your looking for. See link below for the video.
You may also need to leverage the look up formula when patching some of the employee allocation data.
https://youtu.be/0xZ4fMJbLvk?si=sCM6An-i8rphG2bP

Was this reply helpful? Yes No
prabakar21 29 on at

Like (0)

Report
Copy link

Link copied!

Thanks Deek for sharing the link. I have already on it. The video narrates how to patch multi selected values status to the same table by looking up IDs. But I have to insert the selected records as new rows in the Allocation table. That leads to the complexity.

Was this reply helpful? Yes No
Deek 31 on at

Like (0)

Report
Copy link

Link copied!

new rows you can use the patch function setting default as the base record part of the parameters for the syntax. For example

Patch(tbldatasource, defaults(tbldatasource),
{
Column 1: value
Column 2: value
Etc.....
}
)

So tieng back to what @gizmobrat mentioned, maybe something like...
Forall(gallery name ,
If radiobutton.selected = true, patch function))

I haven't messed with radio button before so I am not sure what value the button returns when you check it. In my example above I assumed it would return a true value. You could change the buttons to a check box. Believe a box that is checked returns either a "yes" or a true.

Hope this helps!

Was this reply helpful? Yes No