Power Automate With Power Apps
About the Author: Manish Luhana
Microsoft business applications specialist and certified trainer.
Categories: Power Automate, Power Platform0 CommentsPublished On: 8 January 2022

This blog post will explain how to use Power Automate and PowerApps to manage a multi person field in Sharepoint.

The context

You might have a multi-select user in PowerApps that you wish to transmit to Power Automate for additional corporate activities like authorization or data transfer. You also need to add a Create SP List item to your checklist.

Employing PowerApps or Power Automate, multi-select is usually a unique and complex task. If we integrate both, it presents us with greater obstacles. 

UI for PowerApps

PowerApps-UI-2

Initiate the Flow

FlowName.Run(Concat(ComboBoxMultiSelectPerson.SelectedItems.Mail, Text(Mail) & “;”))

All actions are Power Automated (Flow)

Power-Automate-Full

Description of Power Automated Actions

  • Establish an immediate cloud flow, assign it an identifier, and choose the ‘PowerApps’ trigger as displayed below.

Create-Flow

  • It generates a trigger action similar to the one seen below.

Action-Intial

Create an activity called “Initialise Variable” using the parameters listed beneath. These variables will hold the PowerApps data.

  • Selected Persons in PowerApps – Name
  • Place the cursor on the Value and click “Ask in PowerApps” Type – String Value – Place the pointer on the Value and click “Ask in PowerApps”

Initialize-Variable-For-Input

  • Create a new action called “Initialise Variable” and give it the properties listed below. This variable holds all claims from the multi-person field.
  • Type – Array Value – [] Name – MultiPersonValue 

Initialize-Variable-Multi-Person

  • Using the divide method, create an action called “Apply to each,” which will loop through each mail.
  • Add a check to ensure the email isn’t empty.apply-to-each
  • Create an action called ‘Append to array variable’ and set the claims for each email.

“Claims”: “i:0#.f|membership|@{Microsoft 365(item())}”

Append-to-Array

  • We must send the values below to the Add Item action to modify the multiselection’s person column.

[

{

“Claims”: “i:0#.f|membership|microsoft 365.com”,

},

{

“Claims”: “i:0#.f|membership|microsoft 365.com”

}

]

‘Create item’ should be added as an action.

  • SharePoint Site Collection – Site Address
  • SP – List Name Name of the list
  • Fill in all required fields.
  • Choose MultiPersonValue on a specified multi-selection field for the Person field.

create-sp-item

  • Change the input mode to Input the whole range. To allocate your collection variables to the field, follow the instructions below.

switch-to-array

Conclusion

We can use PowerApps to contact Power Automate and update multiple people in SharePoint.

Output

Thank you for taking the time to read this!

tech mentor sidebanner
  • Continue reading
  • Continue reading
  • Continue reading
  • Continue reading
  • Continue reading

Leave A Comment