web

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

News and Announcements icon

Power Platform CommunityForums Power Apps ForAll/Patch to create...

Power Apps

Answered

ForAll/Patch to create multiple records

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

App has a form (Form1) with:

-SP: JobClass_JobSkill

- Dropdown (Dropdown3)-> "Category"

- Text input (Datacardvalue5)->"Job Skill"

-Combobox (Combobox2)m->"Job Classification"

I want to create multiple records to the SP list like this:

Category/Job Skill/Job Classification

Maintenance/Training123/Supervisor

Maintenance/Training 123/Associate

Maintenance/Training 123/Technician

The Submit button OnSelect syntax is: ForAll(ComboBox2.SelectedItems.Value,Patch(JobClass_JobSkill,Defaults(JobClass_JobSkill),{Category:Dropdown3.SelectedText.Value,'Job Skill':DataCardValue5.Text, 'Job Classification':Value}));SubmitForm(Form1)

It's not writing to the SP list. What am I doing wrong? TIA

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

PowerApps forms are designed to submit a single record.
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@shawnawentz,

Based on the issue that you mentioned, do you want to create multiple records based on the Combo Box selected items?

Could you please share a bit more about the scenario?

I think you should combine the Split() function with the ForAll() function.

Set the Submit button OnSelect as follows:

ForAll( Split( Concat( Combobox2.SelectedItems.Value, Value, "," ), "," ), Patch( JobClass_JobSkill, Defaults(JobClass_JobSkill), { Category: {Value: Dropdown3.Selected.Value}, 'Job Skill': Datacardvalue5.Text, 'Job Classification': Table({Value: Result}) } ) )

Hope it could help you.

Regards,

Qi

Join the conversation