Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
 View Only
  • 1.  Approvals in PowerApps without using Flow

    Posted Sep 22, 2021 05:55 AM
    Greetings from Bangkok,
    I am building a PowerApps application which would implements a multi-step approval process which goes beyond what Power Automate can do such as approvers being able to provide multiple feedbacks and uploading additional files to an approval request.
    I need to find out approaches to a multi step approval without using Power Automate.
    Can someone share a logical flow model or point to a resource where a flow logic is available to implement a multi-step.
    Thank you.
    Rizwan.

    ------------------------------
    Syed Rizwan Rizvi
    Finance and Budget Officer
    ------------------------------


  • 2.  RE: Approvals in PowerApps without using Flow

    Bronze Contributor
    Posted Sep 23, 2021 02:47 AM
    Hi Rizwan,
    I built an multi-level approval interface, patching the current approval status back to the record, when the approver selects one of the approval buttons on the top.


    for example:

    Set(varRecord, Patch(VCRequests, Gallery1.Selected, 
        {Outcome: "PS Approved",
         PSApprovalDate: Today(),
         ApprovalHistory: DataCardValue42.Text & Char(13) & "PS Approved" & " - " & User().FullName & " - " & Now()
        }
         ));
    Select(btnRefresh);
    VCPowerAppsApproval.Run(varRecord.ID, User().Email)


    the last step actually triggers a flow, but just for sending out a notification mail, based on current request settings.

    hth

    Stefan



    ------------------------------
    Stefan Sauerländer
    Business Analyst
    Ratingen
    ------------------------------



  • 3.  RE: Approvals in PowerApps without using Flow

    Posted Sep 27, 2021 01:44 AM
    Hi Stefan,
    Thank you. I am using a similar approach to Patch records.
    The main issue is the my approvals fall in different categories and based on the category there could be from 2 to 7 levels of review/approvals required for a given request. I need to track how many reviews have been done and when all reviews are done I would mark the request as approved.
    What would be a good tracking mechanism to see the number of steps required, at which step is the process in, what is the next step and when are all steps completed.
    I hope that makes the requirement more clear.
    Cheers.
    Rizwan.​

    ------------------------------
    Syed Rizwan Rizvi
    Finance and Budget Officer
    ------------------------------



  • 4.  RE: Approvals in PowerApps without using Flow
    Best Answer

    Top Contributor
    Posted Sep 28, 2021 08:05 AM
    Could you set up a list of categories and approvers and use that to drive the process? You could number the approvers and then just send to the next person on the list for that category. When you get to the end of the list you issue a final approval.

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------



  • 5.  RE: Approvals in PowerApps without using Flow

    Posted Sep 30, 2021 10:46 PM
    Edited by Syed Rizwan Rizvi Sep 30, 2021 10:57 PM
    Thanks @Brian Scott,
    I used your approach and modified it a bit to get the desired implementation.
    My flow requires a group of reviewers (up to 5) for every step in the process (multiple steps per category). The approval link is sent to all reviewers of that step and any one approving it would approve the step for the entire group.​
    What I have done is to create a Lookup list of all categories of approvals and record total number of steps, approval action (review or approve), and the group of reviewers/approvers for each step. In the requests list, I patch the total number of steps and record the current step for each request and send the link to the first group of approvers. When any one of them reviews/approves, I update the current step column and compare it against the total number of steps. If there is room for more steps, I do a Lookup in the list of categories to find what is the next step number and which group of reviewers/approvers get the link to process it.
    This way I iterate through all steps required to complete the request and mark it as "Approved" when the last step is completed.
    Thanks for the pointer.
    Rizwan.

    ------------------------------
    Syed Rizwan Rizvi
    Finance and Budget Officer
    ------------------------------



  • 6.  RE: Approvals in PowerApps without using Flow

    Posted Sep 27, 2021 01:49 AM
    Hi @Brian Scott,
    Thanks for ​sharing those two video. Laura Rogers, Shane Young and Reza Durrani are my favorites and I keep watching their videos.
    I have watched these videos as well but I could not find exactly what I am looking for.
    I have elaborated a bit on the requirement above.
    Thanks for your help.
    Rizwan.

    ------------------------------
    Syed Rizwan Rizvi
    Finance and Budget Officer
    ------------------------------



  • 7.  RE: Approvals in PowerApps without using Flow

    Top Contributor
    Posted Sep 23, 2021 09:48 AM
    I would look at this video:
    https://www.youtube.com/watch?v=49O284deOAI
    and also this one
    https://www.youtube.com/watch?v=uR46EYGQ0hA

    ------------------------------
    Brian Scott
    Chief Creative Officer
    Concord NC
    ------------------------------