Repeating tables in PowerApps

%3CLINGO-SUB%20id%3D%22lingo-sub-36416%22%20slang%3D%22en-US%22%3ERepeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36416%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20InfoPath%20there%20was%20the%20repeating%20table%20control%20that%20would%20let%20one%20add%20dynamically%20rows%20in%20a%20table.%20Is%20there%20anything%20similar%20in%20PowerApps%3F%20I%20have%20looked%20at%20the%20gallery%20but%20it%20looks%20like%20you%20have%20to%20specify%20the%20number%20of%20items%20in%20the%20gallery.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-36416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-238607%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-238607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10660%22%20target%3D%22_blank%22%3E%40Sreeni%20Amrutur%3C%2FA%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F119323%22%20target%3D%22_blank%22%3E%40vijendra%20kondeti%3C%2FA%3E%26nbsp%3BWe%20hope%20you'll%20consider%20avoiding%20the%20private%20message%20and%20email%20routes%20and%20post%20your%20questions%20and%20solutions%20publicly%2C%20so%20everyone%20can%20benefit%20from%20your%20expertise.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-197781%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197781%22%20slang%3D%22en-US%22%3EHow%20did%20you%20achieve%20this%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-181822%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-181822%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3ESo%20I%20think%20this%20is%20exactly%20what%20I%20am%20looking%20to%20do%20as%20well%20-%20I%20have%202%20SharePoint%20lists%2C%20Projects%20and%20Tasks...the%20tasks%20is%20a%20multiple%20to%20one%20relationship%20with%20the%20projects%20but%20the%20caveat%20is%20that%20depending%20on%20the%20category%20of%20the%20project%2C%20there%20are%20a%20set%20number%20of%20tasks%20that%20need%20to%20be%20added%20to%20the%20project%20and%20values%20edited%20upon%20creation%20of%20the%20project.%26nbsp%3B%20Can%20you%20share%20how%20you%20achieved%20the%20editing%20of%20the%20repeating%20table%20(gallery%20item)%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166039%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166039%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20achieved%20this%2C%20have%20a%20look%20at%20attached%20snapshot.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29301iF419BFA188D93AFB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22reeating%20table.png%22%20title%3D%22reeating%20table.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-166037%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-166037%22%20slang%3D%22en-US%22%3ECorrect%20if%20below%20understanding%20is%20correct.%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Create%20new%20APP%20design%3CBR%20%2F%3E2.%20Add%20a%20gallery%20control%20with%20datasource%20display%20only%20mode%3CBR%20%2F%3E3.%20Create%20a%20Item%20new%2Fedit%20form%20for%20adding%20new%20items%2Fediting%20items%3CBR%20%2F%3E4.%20Add%2Fupdate%20the%20value%20in%20gallery%20when%20add%20event%20is%20fired%3CBR%20%2F%3E5.%20On%20submit%2C%20save%20collection%20object%20in%20specified%20datasource.%3CBR%20%2F%3E%3CBR%20%2F%3EQuestions%3F%3CBR%20%2F%3E1.%20How%20to%20add%20items%20in%20to%20local%20gallery%20object%3F%3CBR%20%2F%3E2.%20How%20to%20save%20collection%20object%20in%20datasource%3F%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-165988%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-165988%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ehave%20you%20found%20a%20solution%20%2C%20please%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-160078%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-160078%22%20slang%3D%22en-US%22%3EHi%20Sreeni%2C%3CBR%20%2F%3EThanks%20for%20your%20quick%20response%2CI%20have%20tried%20as%20you%20suggested%20but%20it%20is%20not%20working.Could%20you%20please%20share%20the%20screen%20shots%20or%20any%20POC.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159623%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159623%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F119323%22%20target%3D%22_blank%22%3E%40vijendra%20kondeti%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20will%20have%20to%20add%20a%20gallery%20control%20and%20the%20Items%20property%20of%20the%20control%20will%20need%20to%20be%20set%20to%20display%20the%20items.%20The%20gallery%20will%20have%20to%20be%20designed%20to%20have%20the%20fields%20that%20you%20want%20in%20the%20repeating%20table.The%20items%20can%20be%20a%20collection%20object%20in%20PowerApps%20and%20the%20collection%20will%20need%20to%20be%20patched%2Fsaved%20up%20to%20the%20data%20source.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-159596%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-159596%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3EI%20am%20also%20facing%20this%20problem.Please%20let%20me%20know%20how%20to%20approach%20it.This%20is%20my%20mail%20id%20macherla1990%40gmail.com.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-155306%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-155306%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F623%22%20target%3D%22_blank%22%3E%40Cedric%20Oster%3C%2FA%3E%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20was%20able%20to%20find%20a%20solution%20for%20this%20in%20PowerApps.%20It%20may%20not%20work%20exactly%20like%20Infopath%20but%20it%20is%20possible.%20If%20you'd%20like%20to%20know%2C%20I'd%20be%20happy%20to%20help%20via%20PM.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-154612%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-154612%22%20slang%3D%22en-US%22%3E%3CP%3EI%20guess%20that's%20not%20what%20Sreeni%20is%20looking%20for.%20Laura%20article%20is%20about%20%3CEM%3Edisplaying%3C%2FEM%3E%20data%20from%202%20SharePoint%20lists.%20What%20Infopath%20was%20used%20to%20be%20able%20to%20do%20was%20to%20create%20an%20entry%20form%20for%20users%20to%20input%20data%20on%20a%20repeating%20tabet.%20For%20example%20in%20a%20plane%20tickets%20booking%20scenario%20where%20the%20user%20enters%20first%20name%2C%20last%20name%20and%20age%20of%20'person%201'%20and%20then%20clicks%20on%20a%20%2B%20button%20to%20add%20another%20passenger%20%3A%20the%203%20%3CEM%3E%3CSTRONG%3EInput%3C%2FSTRONG%3E%3C%2FEM%3E%20fields%26nbsp%3B%3CSPAN%3Efirst%20name%2C%20last%20name%20and%20age%20are%20then%20repeated%20do%20user%20can%20add%20a%20second%20passenger%20details.%20The%20data%20was%20stored%20in%20the%20%3CEM%3Esame%3C%2FEM%3E%20SharePoint%20list%20with%20no%20data%20binding%20to%20a%20SharePoint%20column%20but%20to%20an%20XML%20file%20dealt%20by%20Infopath.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EI'malso%20looking%20for%20such%20a%20solution%20%3Abeaming_face_with_smiling_eyes%3A%3C%2Fimg%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36603%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36603%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20working%20Sreeni%20!%20Just%20copy%20the%20URL%20insead%20of%20clicking%20it%20if%20that%20is%20not%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36602%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36602%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jasjit%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20But%20that%20link%20is%20broken%2C%20Please%20let%20me%20know%20if%20there%20is%20a%20different%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36591%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36591%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sreeni%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20you%20go%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwonderlaura.com%2F2016%2F12%2F21%2Fpowerapp-galleries-repeating-tables%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwonderlaura.com%2F2016%2F12%2F21%2Fpowerapp-galleries-repeating-tables%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EJasjit%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-716949%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-716949%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F41707%22%20target%3D%22_blank%22%3E%40Eric%20Starker%3C%2FA%3E%26nbsp%3Bif%20you're%20still%20looking%20for%20a%20way%20to%20achieve%20this%20I%20suggest%20you%20follow%20Shane%20Young's%20suggestion.%20I've%20used%20it%20previously%20and%20have%20had%20no%20issues%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELink%20to%20his%20blog%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.petri.com%2Fcreate-infopath-repeating-tables-sharepoint-powerapps%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.petri.com%2Fcreate-infopath-repeating-tables-sharepoint-powerapps%3C%2FA%3E%3C%2FP%3E%3CP%3EHe%20also%20has%20it%20documented%20on%20his%20Youtbue%20channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20of%20luck%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-717742%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20tables%20in%20PowerApps%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-717742%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F91863%22%20target%3D%22_blank%22%3E%40Earlline%20Alcide%3C%2FA%3E%26nbsp%3BHello!%20Sounds%20like%20a%20great%20suggestion%2C%20but%20I%20think%20you've%20tagged%20the%20wrong%20person.%20I%20didn't%20ask%20the%20original%20question.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

In InfoPath there was the repeating table control that would let one add dynamically rows in a table. Is there anything similar in PowerApps? I have looked at the gallery but it looks like you have to specify the number of items in the gallery. Thanks.

16 Replies
Highlighted
Highlighted

Hi Jasjit,

 

Thank you. But that link is broken, Please let me know if there is a different link.

 

Thanks.

Highlighted

It is working Sreeni ! Just copy the URL insead of clicking it if that is not working.

Highlighted

I guess that's not what Sreeni is looking for. Laura article is about displaying data from 2 SharePoint lists. What Infopath was used to be able to do was to create an entry form for users to input data on a repeating tabet. For example in a plane tickets booking scenario where the user enters first name, last name and age of 'person 1' and then clicks on a + button to add another passenger : the 3 Input fields first name, last name and age are then repeated do user can add a second passenger details. The data was stored in the same SharePoint list with no data binding to a SharePoint column but to an XML file dealt by Infopath.

I'malso looking for such a solution :beaming_face_with_smiling_eyes:

Highlighted

@Cedric Oster,

 

I was able to find a solution for this in PowerApps. It may not work exactly like Infopath but it is possible. If you'd like to know, I'd be happy to help via PM. Thanks.

Highlighted
Hi,
I am also facing this problem.Please let me know how to approach it.This is my mail id macherla1990@gmail.com.

Thanks.
Highlighted

@vijendra kondeti,

 

You will have to add a gallery control and the Items property of the control will need to be set to display the items. The gallery will have to be designed to have the fields that you want in the repeating table.The items can be a collection object in PowerApps and the collection will need to be patched/saved up to the data source.

Highlighted
Hi Sreeni,
Thanks for your quick response,I have tried as you suggested but it is not working.Could you please share the screen shots or any POC.

Thanks.
Highlighted

hi,

 

have you found a solution , please help

Highlighted
Correct if below understanding is correct.

1. Create new APP design
2. Add a gallery control with datasource display only mode
3. Create a Item new/edit form for adding new items/editing items
4. Add/update the value in gallery when add event is fired
5. On submit, save collection object in specified datasource.

Questions?
1. How to add items in to local gallery object?
2. How to save collection object in datasource?
Highlighted

I have achieved this, have a look at attached snapshot.

 

reeating table.png

Highlighted

Hi

So I think this is exactly what I am looking to do as well - I have 2 SharePoint lists, Projects and Tasks...the tasks is a multiple to one relationship with the projects but the caveat is that depending on the category of the project, there are a set number of tasks that need to be added to the project and values edited upon creation of the project.  Can you share how you achieved the editing of the repeating table (gallery item)? 

Highlighted
How did you achieve this?
Highlighted

@Sreeni Amrutur @vijendra kondeti We hope you'll consider avoiding the private message and email routes and post your questions and solutions publicly, so everyone can benefit from your expertise. 

Highlighted

@Eric Starker if you're still looking for a way to achieve this I suggest you follow Shane Young's suggestion. I've used it previously and have had no issues

 

Link to his blog: https://www.petri.com/create-infopath-repeating-tables-sharepoint-powerapps

He also has it documented on his Youtbue channel.

 

Best of luck

Highlighted

@Earlline Alcide Hello! Sounds like a great suggestion, but I think you've tagged the wrong person. I didn't ask the original question.