Answered

Help building a form

(1) Share

Report

Posted on by NP-18101421-0

237

I have an input form that allows the users to select a list of responsibilities from a dropdown field. Once they select the responsibility there is a text field that pulls in the owners for each of those responsibilities from a SharePoint List. There can be multiple responsibilities per owner.

As the request works through the workflow, the owners will need to approve the appropriate responsibilities for each request. I am not sure how to build a form for this but was hoping it can be organized in a way where the responsibilities that were requested by the user are grouped by owner. It should look something like the image below where the owners can select the checkbox of the responsibilities they'd like to approve. Any thoughts?

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

WarrenBelz 152,827 Most Valuable Professional on at

Like (0)

Report
Help building a form

Hi @NP-18101421-0

You may be better filtering the responsibilities by the logged-in user and just displaying those. If you have the person's email in a field in the task list - you would need to make this the Items of a Gallery.
Filter( DataSource, YourEmailField = User().Email )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

Help building a form

@WarrenBelz

Unfortunately I would need the screen to look as similar as possible to the screenshot. This is how they approve items right now and want it to appear as similar as possible. I would also later need to add a PDF functionality to allow them to generate that screen to a pdf with all of the populated approvals for each owner.

If the last option is to go with filtering the gallery based on the logged in user, what condition can I use in the WF to know when all approvers have submitted their responses? Each request can have different number of owners that may need approval.

If this is too complex to build in PowerApps, please advise.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,827 Most Valuable Professional on at

Like (1)

Report
Help building a form

Hi @NP-18101421-0

Yes it is possible, but not straight-forward.

You would need a nested gallery set with the "Parent" containing a distinct list of people and the "Child" containing the tasks. Something like (Parent) Items
GroupBy( Filter( DataSource, !TaskCompleted ), PersonName, Grouped )

and then the Items of the Child
ThisItem.Grouped

You will know it all is done when the gallery shows no records.

There is some more work involved in writing it all back to the data source - OnChange of the checkbox, you can send the result back - I have assumed a Yes/No field here and that you are using Classic controls.

Patch( DataSource, { ID: ThisItem.ID, TaskCompleted: Self.Value } )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 152,827 Most Valuable Professional on at

Like (0)

Report

Help building a form

@NP-18101421-0

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report

Help building a form

@WarrenBelz,

This should work, appreciate your help on it.

Was this reply helpful? Yes No