Unanswered

Createing a Power App with multiple Approval Steps and saving to sharepoint

(0) Share

Report

Posted on by Community Power Pla...

I am making a power app for a approval process which lets say has 10 steps. I have created a sharepoint list to store the response to each step as a individual column and the approval record.

At first, I would like the responder to fill the frist 3 steps and then send it for approval. Once approval is obtained, only then can the responder fill steps 4-7. After this the responder as to submit the form to the second approval. Once approved the responder can submit the last entires for the final approval.

Is it possible to set up an edit form that intergrates with power automate in this fashion? I was hoping that the resonses to each step are stored in one row. i was also hopeing that lets say the responder is in step 1, they can't respond to the questions in step 2 and 3. Simialr for the step two, the user can not edit what they entered in step 1 and they can not fill the quesitons in step 3.

The other thing I would want is that the responses and approvals be stores in the same row.

I have read about patching, but I have nevered used it before. Is it possible to use patching and a editform at the same time for my case?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@Anonymous

You mentioned that this is in a Form, so I would ignore anything about Patching. You can submit your form as normal.

The key to what you are doing is that you need to store the "current step" in your record. Then in your app, set the visibility and displaymodes of DataCards based on the step.

So, for example, let's say some fields should only be visible in step 3, then you would set the Visible of datacards that should be visible to: ThisItem.CurrentStep=3

For fields that should be visible at any time after a certain step, then it would be ThisItem.CurrentStep>2 (those would be visible after step 2 is done).

For fields that you don't want to be editable after a certain step, set the DisplayMode of the datacard to: If(ThisItem.Step > 4, View, Edit)

I hope this is helpful for you.

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like (0)

Report
It sounds like you are early in designing this app, so I'll keep my responses pretty high level. The short answer is: yes, you can do what you describe. Here are the basic steps:

Create a List with all the columns you will need, which include columns to record the results of your approval steps. I recommend single line of text columns that will contain a string such as "Yes" or "Approved"

Decide how you want to structure the app(s). A. You could do separate screens for each major part of your process - the user will be taken to the appropriate screen depending on the approval stage. Or, B. you can carefully craft the form's card's DisplayMode depending on the state of the selected record. Structure A is probably more intuitive for newer app Makers.

You can use a Patch() to update particular fields, but use the form controls as much as possible. Again, for newer Makers this is an easier path

You can use Power Automate flow(s) triggered by changes to the SharePoint List or the app itself to send out notifications/approval requests to the next designated team member. You can also use the Mail connector to automatically send out an email message. There are lots of ways to accomplish a notification.

Power Automate does have approval functionality, but for this case, it might be better to make your own as described above.

Go ahead and start on the first few steps, and once you get past those come back with specific questions or do some searches on here.

Hope that helps,

Bryan

Was this reply helpful? Yes No