Sharepoint inserting multiple rows using one form

Copper Contributor

I have a sharepoint list which saves the data coming from Infopath form. There is multiple check box picker that I am using in my form which gets saved in a column inside sharepoint. I want to create a functionality where if user selects multiple items then it should create multiple rows in sharepoint list.

Eg : checkbox contains : 02C, P2P,R2R.S2S

User selects O2C and P2P

 

Sharepoint list should have 2 rows

Name,  Amount , Title

Test1 , 3234 , 02C

Test1 , 3234 , P2P

As you can see it duplicates the other columns but splits the checkbox items into two rows.

How can we achieve this using flows or infopath?

 

Thanks in advance

2 Replies

@Arushi9 I have tried this with repeating tables in InfoPath but with no luck. Since InfoPath is on the way out, I would suggest you to transform the soloution to PowerApps. Shane Young has made a great video about the issue with repeating tables in PowerApps like InfoPath, and that helped me a lot.

https://youtu.be/xgznk4XlPCo

https://youtu.be/DylxsXIUyDc

 

I know it is not a direct answer to your question, but hope it can guide you to a soloution.

 

/Frank

Thank you for helping me create a repeating list. However, I'd like the user to be able to upload files (pdf) and images.  How do I name them in the button formula, similar to "lineItem"?  Thank you. @Frank Nielsen