web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ComboBox creates new r...

Power Apps

Answered

ComboBox creates new record rather than update

(0) Share

Report

Report

Posted on by FA-18030952-0

25

Hi

I am fairly new to Powerapps so any help will be much appreciated.

I have the form below which creates a new project and I use the combo box to select multiple users and store them in the text field multiusers.

However when I create a new record all the other fields save as one record and the users then save as another.

The code in the combo box is:

Office365Users.SearchUser({searchTerm:cmb_SavePeople.SearchText})

and the save button is:

SubmitForm(Form2);

Patch('Project Details',{MultiUsers:Concat(cmb_SavePeople.SelectedItems,DisplayName, " ; ")});

Reset(cmb_SavePeople)

How can I get it to create one record and not two.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
You code is supposed to create two records. Try below one.

SubmitForm(Form2); Patch( 'Project Details', LookUp('Project Details', ID = Form2.LastSubmit.ID), { MultiUsers: Concat(cmb_SavePeople.SelectedItems, DisplayName, " ; ") } ); Reset(cmb_SavePeople);

Was this reply helpful? Yes No
FA-18030952-0 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi
Thank you that works!!
I also have an edit button which selects the record from the gallery and allows the user to edit the form. How can I get the combobox to list the current user names and the option to add or delete users and then save?

Was this reply helpful? Yes No

Join the conversation