web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Create multiple reques...

Power Apps

Answered

Create multiple requests using people picker on Share point form

(0) Share

Report

Report

Posted on by Neha2904

94

I need to create a form where the request can be created for multiple users using the people picker combo box.

So, if two users are selected, 2 records should get created in share point list.

User1.DisplayName, User1.Mail, User1.LineManager, UserType, ActionType, Role

User2.DisplayName, User2.Mail, User2.LineManager, UserType, ActionType, Role

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Neha2904

what are the names of the comboboxes on your screenshot?

each record will have 6 columns to populate, what are the names and datatypes of those columns?

Neha2904

94 on at

Like (0)

Report

Thanks for the response. The form is structured as below:

Field Type	Field in PowerApp	DataCard Name	Column in SPList	Type
Combobox	Requested For	DataCardValue3	Full Name	Text	Multiselection people picker
Combobox	Requested For	DataCardValue3	Email	Text
Combobox	Requested For	DataCardValue3	Line Manager Email	Text
Combobox	User Type	DataCardValue11	User Type	Choice
Combobox	ActionType	DataCardValue2	Action Type	Choice
Combobox	Role	DataCardValue4	Role	Text	All values of combobox are added as , separated text

Verified answer

v-chenzhi Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Neha2904 ,

Could you please show me your SharePoint List?

I assuem you have this in SharePoint and have a test on my side, please try the following workaround.

Add an Edit form.

Add data.

Set the Items property of ComBobox1 to:

Office365Users.SearchUser()

Set the OnChange property of ComBobox1 to:

ClearCollect(Col,ComboBox1.SelectedItems)

Add a Button, Set the OnSelect property of Button to:

ForAll( Col, Patch( '1222', Defaults('1222'), { 'Full Name': ThisRecord.DisplayName, Email: ThisRecord.Mail, 'Line Manager Email': Office365Users.ManagerV2(ThisRecord.Mail).mail, 'User Type': {Value: DataCardValue5.Selected.Value}, 'Action Type': {Value: DataCardValue6.Selected.Value}, Role: DataCardValue7.Text } ) )

Best Regards,

Zhi Chen
Neha2904 94 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-chenzhi Thankyou for the solution. It worked.

Join the conversation