Answered

Patch multiple records inside a Dataverse column

(0) Share

Report

Posted on by Sumitra_Sai

Hi, I have a form like below where the user enters the person's name who are inside their organization and also have the ability to enter the names who are outside the organization. I'm using Dataverse as the backend.

For Internal, user has the ability to select many names from the people picker ComboBox. So, on click of Submit button, we are storing the selected names separated by comma.

For External, user has the ability to give name and their corresponding email address. User clicks on Add button, which will add those inside a collection.

But how do we need to store these multiple external users value in External Users column along with Internal Users in the Dataverse? or is there any other alternate way to achieve this?

Kindly help me to resolve this issue.

Thanks in advance 🙂

Categories:

Building Power Apps

All responses (8)

Answers (1)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Sumitra_Sai , Do you want to add these external user into single row as separated by ";" ?

First concate into string using
Concate(colExternalPeople,PersonName,";")
Use above code in your patch code.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
Sumitra_Sai 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ANB , Thanks for the reply.

I need to store those External Users in separate rows. For eg. if the user adds 2 External Users, then it should create 2 separate rows in the Dataverse table on click of Submit button. Where name should come under "ExternalPeopleName" and email should come under "ExternalPeopleEmail" column.

Kindly help me to resolve this issue.
Thanks in advance 🙂
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sumitra_Sai , You can use this code:
ForAll(colExternalPeople As var, Patch(DataverseTable, Defaults(DataverseTable), { ExternalPeopleName: var.PersonName, ExternalPeopleEmail: var.PersonEmail } )

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
Sumitra_Sai 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ANB , thanks for your reply.

For external users it's fine, but how can I patch those internal users name as well as radio selected value along with the external users?

Kindly help me, thanks in advance 🙂
Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Sumitra_Sai , Please try this:
ForAll(colExternalPeople As var, Patch(DataverseTable, Defaults(DataverseTable), { ExternalPeopleName: var.PersonName, ExternalPeopleEmail: var.PersonEmail, TestRadioProperty:Radio1.Selected.Value, InternalPeople:Concat(ComboBox1.SelectedItems,DisplayName,";") } )

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @Sumitra_Sai , I was wondering whether using above suggestion whether you were able to fix the issue?

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
Sumitra_Sai 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ANB , thanks for your help. It's working fine now 🙂
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Sumitra_Sai , I am glad that it worked for you. I would request you to press the “Accept as Solution” as this makes the post far easier to find in the future for users with a similar issue.

Please check this post which talk about community guide for posting any query on forum: https://powerusers.microsoft.com/t5/Power-Platform-Integrations/A-guide-to-posting-on-the-Community-Building-Power-Apps-forum/td-p/685962

Thanks,
ANB