Sharepoint inserting multiple rows using one form

%3CLINGO-SUB%20id%3D%22lingo-sub-1019290%22%20slang%3D%22en-US%22%3ESharepoint%20inserting%20multiple%20rows%20using%20one%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1019290%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20sharepoint%20list%20which%20saves%20the%20data%20coming%20from%20Infopath%20form.%20There%20is%20multiple%20check%20box%20picker%20that%20I%20am%20using%20in%20my%20form%20which%20gets%20saved%20in%20a%20column%20inside%20sharepoint.%20I%20want%20to%20create%20a%20functionality%20where%20if%20user%20selects%20multiple%20items%20then%20it%20should%20create%20multiple%20rows%20in%20sharepoint%20list.%3C%2FP%3E%3CP%3EEg%20%3A%20checkbox%20contains%20%3A%2002C%2C%20P2P%2CR2R.S2S%3C%2FP%3E%3CP%3EUser%20selects%20O2C%20and%20P2P%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESharepoint%20list%20should%20have%202%20rows%3C%2FP%3E%3CP%3EName%2C%26nbsp%3B%20Amount%20%2C%20Title%3C%2FP%3E%3CP%3ETest1%20%2C%203234%20%2C%2002C%3C%2FP%3E%3CP%3ETest1%20%2C%203234%20%2C%20P2P%3C%2FP%3E%3CP%3EAs%20you%20can%20see%20it%20duplicates%20the%20other%20columns%20but%20splits%20the%20checkbox%20items%20into%20two%20rows.%3C%2FP%3E%3CP%3EHow%20can%20we%20achieve%20this%20using%20flows%20or%20infopath%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1019290%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1025486%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20inserting%20multiple%20rows%20using%20one%20form%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1025486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F462557%22%20target%3D%22_blank%22%3E%40Arushi9%3C%2FA%3E%26nbsp%3BI%20have%20tried%20this%20with%20repeating%20tables%20in%20InfoPath%20but%20with%20no%20luck.%20Since%20InfoPath%20is%20on%20the%20way%20out%2C%20I%20would%20suggest%20you%20to%20transform%20the%20soloution%20to%20PowerApps.%20Shane%20Young%20has%20made%20a%20great%20video%20about%20the%20issue%20with%20repeating%20tables%20in%20PowerApps%20like%20InfoPath%2C%20and%20that%20helped%20me%20a%20lot.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2Fxgznk4XlPCo%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2Fxgznk4XlPCo%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FDylxsXIUyDc%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FDylxsXIUyDc%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20it%20is%20not%20a%20direct%20answer%20to%20your%20question%2C%20but%20hope%20it%20can%20guide%20you%20to%20a%20soloution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2FFrank%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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

1 Reply

@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

In this video, you will learn how to create PowerApps repeating tables like you had in InfoPath. We will use SharePoint lists as the data sources and create ...
In this video, you will learn how to view and edit the data that was entered via the repeating table for this expense report example. You will create cascadi...