Power Platform Community Forum Thread Details

Hello,

I am having trouble getting this function to work how i want. Please let me know if what i want to accomplish is even possible.

I have a request form that i want to allow the requester to request multiple things for multiple people.

I need to be able to split and patch three columns "mobile equipment", "Trainee full name" and trainee email" to submit as separate items in my share point list.

The form and formula is pictured below:

Categories:

Building Power Apps

Hi @faithdwn ，

Do you want to create new records that user name and email are one-to-one correspondence?

From you screenshot, I see that the mailbox name is the corresponding user name, so do you want to create 6 new records based on your current input?(since you have 2 mobile equipment and 3 user information now. If you type 2 value in mobile equipment and 4 value in user information, it should create 8 new records).

If yes, you can refer to my steps:

1. Create a list to keep the records. My list called “bulkpatch” with three Text columns called “mobile equipment”, “Trainee full name” and “Trainee email”:

2. Add a button and use below formula to combine "Trainee full name" and Trainee email" together(also save Split(DataCardValue3.Text,",") into a collection called “equipment”):

Clear(Combined);
ForAll(
Sequence(CountRows(Split(DataCardValue18.Text,","))),
Collect(Combined,{
fullname:Last(FirstN(Split(DataCardValue18.Text,","),Value)).Result,
email:Last(FirstN(Split(DataCardValue19.Text,","), Value)).Result
})
)
ClearCollect(equipment,Split(DataCardValue3.Text,","))

3. Add another button to patch new records:

Ungroup(ForAll(Combined,
 ForAll(equipment,
 Patch(bulkpatch,Defaults(bulkpatch),{Title:"JustTitle",'mobile equipment':Result,'Trainee full name':Combined[@fullname],'Trainee email':Combined[@email]})
 )
 ),"Value")

See results: