Unanswered

Having data from dropdown go into the same record as data from form control

(0) Share

Report

Posted on by ChattyLinkin

I have a form control that populates my Dataverse table without any issues. However, I also have separate dropdowns that I want to be included in the same record as the data from the form control. I have the following patch function, but this creates a new row every time.

Patch(
 'Onboarding Requirements',
 Defaults('Onboarding Requirements'), 
 {
 'Std Dept No.': LookUp(
 Divisions,
 Location = Dropdown1_1.Selected.Value && 'Company Name' = Dropdown_company.Selected.Value && 'Division Name' = Dropdown1.Selected.Value,
 'Division No.'
 )
 }
)

I'm hoping to simplify the process by having just one button that both submits the form and runs the patch function without creating a new row every time. Does anyone have any ideas on how to achieve this?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ChattyLinkin , Defaults function will always create new record. Instead you should use LookUp function to look up the record in the source and patch the value.

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

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
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ChattyLinkin

If the result of Defaults is used, a record is created.

Use ThisItem function:

Patch( 'Onboarding Requirements', ThisItem, { 'Std Dept No.': LookUp( Divisions, Location = Dropdown1_1.Selected.Value && 'Company Name' = Dropdown_company.Selected.Value && 'Division Name' = Dropdown1.Selected.Value, 'Division No.' ) } )

Use a lookup function:

Patch( 'Onboarding Requirements', LookUp('Onboarding Requirements', ID = UnqiueField), { 'Std Dept No.': LookUp( Divisions, Location = Dropdown1_1.Selected.Value && 'Company Name' = Dropdown_company.Selected.Value && 'Division Name' = Dropdown1.Selected.Value, 'Division No.' ) } )

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ChattyLinkin 51 on at

Like
a
(0)

Report
Copy link

Link copied!
I am a little confused. Do I need to create a unique ID for each record using this?

LookUp('Onboarding Requirements', ID = UnqiueField),
ChattyLinkin 51 on at

Like
a
(0)

Report
Copy link

Link copied!
Update:

I tried creating a column with the name Unique ID. I know that's not going to make it unique every time. Just wanted to test. Any idea why the original plan of having the std dept no. update the current record instead of creating a new one didn't work?

Patch( 'Onboarding Requirements', LookUp('Onboarding Requirements', 'Unique ID' = "12345"), { 'Std Dept No.': LookUp( Divisions, Location = Dropdown1_1.Selected.Value && 'Company Name' = Dropdown_company.Selected.Value && 'Division Name' = Dropdown1.Selected.Value, 'Division No.' ) } ); SubmitForm(Form1);