Unanswered

Creating multiple records on SharePoint from a single form entry

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

My issue is described in the title. I have a combo box where multiple locations can be selected. Depending on how many combo box options are selected, a record is added to SharePoint for each one. Each record has only the location changed, all other record values staying the same.

For example, America, Ireland and Australia are selected.

This is what is added to the SharePoint list:

System | Location | Business Area

XP | America | Instruments

XP | Ireland | Instruments

XP | Australia | Instruments

Is this possible upon submitting a single form and adding each record based on how many locations are selected in the combo box? It is beyond my capability and would love some direction if possible.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MagnusGöransson 424 on at

Like (0)

Report
Copy link

Link copied!

I think you need to look into the Patch function together with the ForAll function.

I will see if i can come up with a solution when i have some spare time to test it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I will look into these now, thanks.

Was this reply helpful? Yes No
MagnusGöransson 424 on at

Like (1)

Report
Copy link

Link copied!

This is maybe not bang or target, but at least it may give you some ideas

https://powerusers.microsoft.com/t5/General-Discussion/Patch-Combobox-to-SharePoint-Choice-Coloum/td-p/166522

Was this reply helpful? Yes No