Multiple Approvers Flow “PowerAutomation” through “PowerApps”

Here We look in to the Requirement,

Where the user add a data into the SharePoint list in one field and save, then Application to be opened

in PowerApps through a link in mail using PowerAutomate

Scenario :

When the data is added to one field in SharePoint list and saved with rest of the columns being empty

For example :

We take first column as Title, second column as X, third column as Y and so on

Here If the user enter the data into the first column and save the SP list then it directs to the PowerApp

where, the Title Datacard displays with the data in it and all theremaining X, Y Datacards will be empty

as it has to be entered the data in the PowerApp with the options Approve/Reject.

When Approve button is clicked then next screen has to be directed through the PowerApp link

(which the navigation of screens explained in the previous post)

The PowerApp screen link is sent through the Automation flow for the First Approver and when the first approver receives link in emiail and when the link is clicked on it directs to the PowerApp, So First approver enter the details in the ‘ X Datacard ‘ and ‘ Y Datacard ‘ then clicks on the button approve/reject.

Here the entered details in PowerApp screen will be stored the SharePoint list which we created

How the details get stores into the SharePoint when it is entered in the PowerApp

By Just providing the patch function for the buttons in the PowerApp

As click on the button

1. Then goto Onselect in the leftpane
2. provide the below function to the Onselect fn.

Patch(
    ListName,
    First(
        Filter(
            ListName,
            ID = ParamId
        )
    ),
    {ColumnName: DatacardName.Text});

• Here ListName – It is dataname fetches from the SharePoint
• ColumnName – The column which in the Sharepoint list
• DatacardName – It is which auto generated in the PowerApp screen

The .Text in the above function depends upon, if you take the text box put .Text

Else if you take the Dropdown or combobox put .value after the datacardname

The PowerAutomation works here as sending the Approval or Reject emails.