Repeating Table

%3CLINGO-SUB%20id%3D%22lingo-sub-197769%22%20slang%3D%22en-US%22%3ERepeating%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197769%22%20slang%3D%22en-US%22%3E%3CP%3EAll%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20am%20creating%20a%20new%20Form%20for%20a%20Sharepoint%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20one%20table%20with%20three%20fields%20that%20I%20only%20want%20to%20be%20filled%20out%20once.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20second%20table%20with%207%20fields.%26nbsp%3B%20i%20would%20like%20for%20this%20table%20to%20be%20repeating%2C%20giving%20the%20person%20filling%20it%20out%20the%20option%20to%20add%20another%20set%20of%20the%20same%207%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20upon%20saving%2Fsubmitting%2C%20a%20new%20item%20is%20created%20in%20the%20SP%20list%20for%20each%20row%20in%20the%20repeating%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20seen%20a%20couple%20of%20links%20in%20this%20forum%20but%20none%20of%20them%20includes%20a%20usable%20solution%20for%20someone%20like%20me%20who%20is%20very%20new%20to%20PowerApps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197769%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-212483%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-212483%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Zane%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20not%20fluent%20in%20developing%20Power%20Apps%20you%20can%20use%20a%20third%20party%20solution%20-%20Sintel%20Forms.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsintel.ie%2Fproducts%2Fsintel-forms%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsintel.ie%2Fproducts%2Fsintel-forms%2F%3C%2FA%3E%3C%2FP%3E%3CP%3EIt%20is%20free%20for%20up%20to%202%20forms.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20article%20describing%20how%20to%20configure%20related%20lists%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsintel.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360007005691%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsintel.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360007005691%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EMichal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-202504%22%20slang%3D%22en-US%22%3ERe%3A%20Repeating%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-202504%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Zane%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20do%20this%20you%20need%20to%20create%20two%20lists%20in%20SharePoint%2C%20one%20for%20the%203%20fields%20and%20the%20second%20for%20the%20repeating%20fields.%20In%20the%20repeating%20list%20you%20need%20to%20have%20a%20Lookup%20field%20which%20links%20this%20list%20to%20the%20first%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20PowerApps%20you%20need%20to%20link%20the%20two%20fields%20to%20each%20other%20using%20the%20lookup%20field%20ID.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20I%20understand%20correctly%20then%20it%20is%20something%20like%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2F5GGn7QAI8WI%26nbsp%3B%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2F5GGn7QAI8WI%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20video%20I%20have%20created%20a%20custom%20form%2C%20but%20in%20SharePoint%20you%20do%20this%20by%20creating%20the%20Power%20App%20from%20the%20first%20list%20(the%20one%20with%203%20fields)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20hope%20this%20helps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

All,

 

i am creating a new Form for a Sharepoint list.

 

I have one table with three fields that I only want to be filled out once.

 

I have a second table with 7 fields.  i would like for this table to be repeating, giving the person filling it out the option to add another set of the same 7 fields.

 

Then upon saving/submitting, a new item is created in the SP list for each row in the repeating section.

 

I have seen a couple of links in this forum but none of them includes a usable solution for someone like me who is very new to PowerApps.

2 Replies
Highlighted

Hi Zane,

 

To do this you need to create two lists in SharePoint, one for the 3 fields and the second for the repeating fields. In the repeating list you need to have a Lookup field which links this list to the first list.

 

In PowerApps you need to link the two fields to each other using the lookup field ID.

 

If I understand correctly then it is something like this https://youtu.be/5GGn7QAI8WI 

 

In the video I have created a custom form, but in SharePoint you do this by creating the Power App from the first list (the one with 3 fields)

 

I hope this helps

 


 

How to building a simple job tracker with PowerApps and SharePoint. A great new way to build mobile applications for phones and tablets without needing to be...
Highlighted

Hi Zane,

 

If you are not fluent in developing Power Apps you can use a third party solution - Sintel Forms.

https://sintel.ie/products/sintel-forms/

It is free for up to 2 forms.

 

Here is the article describing how to configure related lists

https://sintel.zendesk.com/hc/en-us/articles/360007005691

 

Regards

Michal