Repeating Table in PowerApps - Similar to InfoPath Form | Gallery | PowerApps | Power Platform

In this video we will see how to create repeating table in PowerApps, same as InfoPath Form.
CODE SNIPPET
Combine table data into one string variable ----
Set(AllItemsString,Concat(GalleryRepeatingTable.AllItems,Concatenate(ItemSerialNumber.Text,";",VisitorName.Text,";",VisitorPhoneNumber.Text,";",VisitorEmail.Text,";",VisitorCity.Text,"|")))
------
Add new row in Gallery ----
Collect(CollItems,{CItemSerialNumber: Text(Last(CollItems).CItemSerialNumber + 1) ,CVisitorName:"",CVisitorPhone:"",CVisitorEmail:"",CVisitorCity:""})
-------
Remove Row from Gallery -----
RemoveIf(CollItems,CItemSerialNumber = ThisItem.CItemSerialNumber)
----
Pull data and generate collection object -----
Clear(CollItems);
Set(AllItemsString,Left(AllItemsString, Len(AllItemsString)-1));
ForAll(Split(AllItemsString,"|"),
Collect(CollItems,
{CItemSerialNumber: Text(Last(FirstN(Split(Result,";").Result,1).Result).Result),
CVisitorName:Text(Last(FirstN(Split(Result,";").Result,2).Result).Result),
CVisitorPhone:Text(Last(FirstN(Split(Result,";").Result,3).Result).Result),
CVisitorEmail:Text(Last(FirstN(Split(Result,";").Result,4).Result).Result),
CVisitorCity:Text(Last(FirstN(Split(Result,";").Result,5).Result).Result)}))
----------------------------------------------------------------------------------------------------------------
PowerApps Learning Playlist - • PowerApps Learning
Check out my articles and blogs on
www.c-sharpcor...
#powerapps #sharepoint #powerplatform

[@naveedraza7662]

It's very nice , however u should have done this step by step. I mean to say create entire thing freshly by explaining that will help alot to new user also to understand whatever all properties u have made changes to get that look

[@lakshmiganneboyina5248]

Great vedio easy to understand and very useful for us

[@wh3resmycar]

this is some next level PowerApps coding right here.

[@putriayunurbayti1393]

Your vidoe tutorial is what I searching for long. Could you show step by step how to create the table like excel from beginning.. thankyou so much

[@nevwhile]

Nice Video, really helpful but I have a couple of questions as I just can't get the data to pull back:- 1. How do you get saved value back from SharePoint list in edit mode - how/where do you populate the variable AllItemsString? You mention this at the top of your slide at 11:45 but you do not show how to do it. 2. What do you have configured for "Default" and "Update" on the Datacard that corresponds to the SharePoint column where the record will be saved? I know this is an old video but it would be great to see the full thing from scratch with all components configured. It would be a huge help to PowerFx beginners like me. Thank You.

[@boyan9600]

This is a great solution! Clean and elegant. Thanks for sharing.

[@mahesh1984c]

Very nice thanks a lot...Too good

[@gerardosalazar2426]

Hi Sarvesh, you have a different way to do it and is great, also the way to pull is also a plus!!

[@SarveshShinde]

Gerardo Salazar - Thanks, glad that you liked it.

[@smallmoneytrading6583]

Thank you so much.

[@ericernst1552]

This is exactly what I was looking for! What does the SharePoint list output look like with the Set command?

[@jl1399]

Showing the data going into a SharePoint list or other might be useful

[@innovativeguys]

That's great tutorial to understand the powerapps capabilities but it will be great if you can provide web link for same

[@lenzypetty1097]

Great video. I like the repeating table video, but I want Inputs for my individual Item or Record to have input as (1) single line text (2) number, and (3) choice drop down. Is that possible?

[@homaperween9580]

Hello sir, yr video is very helpful thanks for sharing this video I have question can u help me how to create new row in between of two rows when I click add incon using collection .

[@shashankpawitwar4355]

Hi Sarvesh, Your video is a saver. However, I do have question on delete feature. When I added delete feature, it is working to remove row, but I notice that it is removing previous row not the one I selected. I used similar formula showed in you video. My formula is as "Select(Parent);Remove(CollItems,ThisItem)". Have you encounter this error previously?

[@harshagowda81]

Hi Sarvesh - Very nice video on repeating table. I have a similar Requirement of Repeating Table to Pull the Data from SQL Table1 to repopulate for the user and additional fields that user fill in and store the user submission data into SQL Table2 for reporting purpose and also have attachment upload options for user, Is this doable in Power Apps if yes can you pls do a video on this requirements

[@SarveshShinde]

Hi Harsha, Thanks for your comment. Surely I will make a video on this topic, but that will take some time. Till that time I will give you some heads up. 1. Populating existing SQL table in PowerApps is possible with Gallery control 2. Adding additional field in this gallery is also possible - need to use AddColumns function 3. We can submit additional column values to seaprate tables using Patch and Collect function in another table 4. Uploading attachment - till now uploading only imags is possible to SQL or Azure blob. If you are connecting SharePoint list/library - then you can upload any type of file. So it depends on what attachments you want users to upload? If its only images, then yes its possible with SQL connector in PowerApps. Hope this helps.

[@harshagowda81]

@@SarveshShinde Thank you will wait for your video....meanwhile will try to do as per you suggestions

[@brijendraydv]

@@SarveshShinde Hi Sarvesh,do we have the video out using sql server db?I guess using db is premier connector and we have to pay for it?Thanks

[@debaratiray2482]

@@SarveshShinde I am looking for the same as well.

[@debaratiray2482]

@@SarveshShinde Let's say uploading an excel file to a able as bulk load.Is it possible?

[@rahulkumarjain2251]

Thanks Mr. Sarvesh, But one problem I am facing, while putting Datepicker in galleryitem, one day less is recorded in Excel table ?....plse provide solution for this.

[@lamahasan8122]

can you show me the serial number code or how its working? what you add exactly on serial number? and why we add C before the field name? thanks

[@kimlundsteen]

Super vidoes. Can you do flexible heigt for repeating tables - I.e. (VisitorStory.Text / CVisitorStory). To be like InfoPath, where the fields have autoheigt ..

[@SarveshShinde]

I havent tried it yet. But try using Flexible height gallery control. See if that helps. Usually flexible height with gallery - works only when you are showing readonly data. I dont think it will work when we are getting inputs from user. The text controls will start showing scroll bar instead of changing the gallery template size...

[@sachinmangalwedhe8194]

Thank you very much for all knowledge you are sharing. could you please let me know how to add date without time.also, in my excel data source date is showing onde day lesser than powerapps. How to fix that.

[@hemantrathod6235]

This is exactly what we were after thank you for the video, But just one thing missing how did you get that table on PowerApps ? i.e column titles, + button etc

[@SarveshShinde]

Thanks, Those are just labels and plus icon - arranged in a way that it looks like heading section of your gallery.

[@hemantrathod6235]

@@SarveshShinde Thank you very much for the prompt reply, this video will help me a lot with the solution I am working on. :)

[@newabyuser]

how are you storing it in sharepoint List? Does Name, phone, email and city have there own each column in list?

[@mclark23]

No-one ever shows the sharepoint process assuing that it's easy. Well, it's not obvious. Can you please show the sharepoint steps.. Do them before or after you make this?

[@daniloortiz7530]

Hello, I'm from Colombia, I would like to be able to see the subtitles in Spanish please i like your videos

[@juanmanuelenriquez3635]

You can active them by clicking in Captions and select Spanish. Activalos en Caption... buscalo en tu mismo you tube.. saludos.

[@2007pradipta]

what is the use of RemoveIf ? I use Remove(CollItems,ThisItem) and it deleting the row in the beginning. I have no column to show serial number. please help me.

[@ratanapouy]

Can u make a demo if item list is drop down list?

[@SarveshShinde]

Ratana POUY - do you mean in the sharepoint list forms? yes I am working on it. in next 2 days I will upload video on it.

[@SarveshShinde]

Here it, check it out kzbin.info/www/bejne/r4LUdWmZe9Wqfrs

[@justincphilip]

@@SarveshShinde Hi Sarvesh, I think he means if one of the columns in the repeating table is a drop down list/lookup field (e.g. City).. how can we save, and pull and bind data for that column. This video is excellent but only shows 4 text fields in the repeating table. Is it possible to make a demo of a repeating table with various types of fields in the columns? Please 🙂🙏

[@SarveshShinde]

@@justincphilip - You can add Dropdown or combobox in Gallery also. It works exactly same as when these controls are used outside the Gallery. Directly bind SP list as Datasource to Items property. Or bind local collection to Items property. Are you facing any issue with it?

[@Test27344]

Great video! Showed a different way to achieve Repeating Tables which I really appreciate. My question is that when I hit the "Pull and Bind Data" button, it pulls the data just fine, but if you hit it again and starts removing data from the screen. Is there a way to prevent this? Thank you.

[@SarveshShinde]

Thanks for comments. I had added those buttons for demo purpose only. You should hit clear items button first and then click Pull button. OR make sure you have written Clear(collection) function on pull button.

[@Test27344]

Thank you for the reply. I really appreciate it. One more question if you don't mind. I'm trying to add a form and combine the form data and the repeating table data to the same row in a SP list. When I submit the data from the form and repeating table they are on separate lines (ID's). Can you point me in the right direction to combine them?

[@SarveshShinde]

@@Test27344 Use Patch function - using patch function you can submit multiple forms, separate columns - all together as one request for one record. Patch(listname, Defaults(listname), {ColumnName: Value}, Form1.Updates, Form2.Updates)

[@silverwhite11]

Hi ,how do I freeze the left column cell in excel table when using powerapps? When scrolling the table to the right, I would like the left column to freeze. Thank you for the great videos.

[@SarveshShinde]

Don't think this is possible right now. But as workaround try using two galleries. First with one column on left side.and second with other columns on right side. Only challenge here is how to sync scroll up and down of both of these galleries.

[@silverwhite11]

@@SarveshShinde, thank you Sarvesh. Best videos to learn powerapps, will keep up with the good work

[@amirgohary]

Hello When I remove CustomGallerySample to add CollItems in the Gallery Text, the form disappear

[@ianalexandertorres6189]

Hello, Thanks for this tutorial, i noticed that some data are not saved in the string when using concat in gallery.allitems. Hope you can help me thanks

[@ianalexandertorres6189]

123456|||||||||||||||||||||||||||||||789| here is an example

[@nduagubadev]

Hi Sarvesh Shinde , I want to able to submit to a people picker field also seperate from the "AllItemsString" variable. I added it as a combox but how do i get the data within to the list

[@SarveshShinde]

Do you need help in binding office365users data to combobox? or do you need info on how can you submit selected user data in people picker column back in SP list? if its second then refer my article here >> www.c-sharpcorner.com/article/set-default-value-to-person-or-group-field-in-powerapps/

[@yougiri08]

How to get the data from SP list to the PowerApp forms to View and edit? Thank you!

[@susheelsingh1716]

Hi, I have one question what's visitorlist? Thanks

[@Kukdai]

how do you read the SharePoint column value to populate the gallery while editing the form with gallery

[@mclark23]

What does pull and bind mean? It's perfectly good english but it's a technical term that's not obvious. PLease explain..

[@mfonobongpeter]

thank you sir for this, is there a way to validate user input? i tried using if statement in the ForAll Loop, but it didn't work out

[@SarveshShinde]

Hi, With ForAll it should work. How are you submitting the data from gallery to your data source? Set(IsGalleryValid,true); ForAll(Gallery.Allitems, If( IsMatch or IsBlank or IsEmpty ,Set(IsGalleryValid,false))); If(IsGalleryValid, Submit your data) Another suggestion - you can change the background color of your control, if the data entered is not valid or empty. Use fill property of control in gallery - write validation logic and set color.

[@mfonobongpeter]

@@SarveshShinde I have tried this: Set(IsGalleryValid,true); ForAll(Gallery4.AllItems, If(IsBlank(TextInput1.Text) || Value(TextInput2.Text) > 0 ,Set(IsGalleryValid,false),Set(IsGalleryValid,true))); i am still having the error that the Set function cannot be invoke within a ForAll Loop. The second option won't work for me because i want to prevent users from submitting the if any of the conditions fails, but that works for only the first row of controls in the gallery, if you have more than one row, it fails, i suppose the validation logic needs to be in the ForAll loop so it could iterate through all rows. I am submitting record using Patch function in the ForAll Loop

[@SarveshShinde]

@@mfonobongpeter You are right. Set function is not allowed in ForAll. I will look for the solution and will soon update you.

[@SarveshShinde]

@@mfonobongpeter As I can see you are using Patch function inside ForAll - do not use set function. Instead validate using ismatch, isblank functions and if its correct then in true condition call patch function otherwise show notification message to user. I will make video on it soon. Hope that helps.

[@SarveshShinde]

Hi Mfonobong, I have uploaded separate video on validating gallery inputs. Please have a look. It should help you for sure. kzbin.info/www/bejne/d2e9gqmPfKiroqc

[@AfeeqAzmi]

How you make the rules sir? I have problem to combine between data card and gallery?

[@shiyong6444]

Is It possible to Patch all items in the repeating table without making it into a string?

[@SarveshShinde]

Hi, Yes its possible. You can store each row in repeating table as record in your back end data source. Please watch this video where I have explained how to do bulk update/insert of records - kzbin.info/www/bejne/qX2QaaasbtesiaM

[@ftl9222]

Can you please share the Code files or the presentation which you have prepared?

[@SarveshShinde]

Sure. Here it is SAVE DATA => Set(AllItemsString,Concat(GalleryRepeatingTable.AllItems,Concatenate(ItemSerialNumber.Text,";",VisitorName.Text,";",VisitorPhoneNumber.Text,";",VisitorEmail.Text,";",VisitorCity.Text,"|"))) Add new ROW => Collect(CollItems,{CItemSerialNumber: Text(Last(CollItems).CItemSerialNumber + 1) ,CVisitorName:"",CVisitorPhone:"",CVisitorEmail:"",CVisitorCity:""}) REMOVE FROM GALLERY => RemoveIf(CollItems,CItemSerialNumber = ThisItem.CItemSerialNumber) Fetch AND BIND DATA => Clear(CollItems); Set(AllItemsString,Left(AllItemsString, Len(AllItemsString)-1)); ForAll(Split(AllItemsString,"|"), Collect(CollItems, {CItemSerialNumber: Text(Last(FirstN(Split(Result,";").Result,1).Result).Result), CVisitorName:Text(Last(FirstN(Split(Result,";").Result,2).Result).Result), CVisitorPhone:Text(Last(FirstN(Split(Result,";").Result,3).Result).Result), CVisitorEmail:Text(Last(FirstN(Split(Result,";").Result,4).Result).Result), CVisitorCity:Text(Last(FirstN(Split(Result,";").Result,5).Result).Result)}))

[@vamsikrishnamodu1512]

How to create a serial number for existing app?

[@SweetSisters778]

How to update serial number after deleting the record

[@Kumar.MVlogs]

I need to migrate from infopath form repeating tables to powerapps sharepoint online list. In Sharepoint online using Powerapps i need to create Canavas app with repeating table fields in the registration form to store data in sharepoint online list. do i need to create two sharepoint lists to store data app data? or one list is fine two store complete list form data? separate list is for repeating table all fields data storing and other registration form fields data should be stored in another sharepoint online list? What is the best approch to develop repeating table fields in powerapps sharepoint list. Can any one please share article for above requirement.

[@SarveshShinde]

Hi Kumar, It depends on how you or your users need to process the data in future. If you need to repeating table data to be available to access directly in SP list, or for reporting purpose or for export purpose - then its recommended to store it in separate list. if you really dont repeating table data for reporting or for direct access - then you can always store it in multiple line text field in same sp list.

[@Kumar.MVlogs]

@@SarveshShinde hi sarvesh thank you so much for your videos. If we want to store repeating table all rows data in single multiline text field then is there any limitation of charectors to store data in single multiline text field??? Have you prepared any video to store data in two seperate lists? Could you please share article to share data in two lists.

[@SarveshShinde]

@@Kumar.MVlogs There is no limit on char as its multiple line text field in SP list.

[@rdavel777]

How do you patch a dropdown in the gallery?

[@SarveshShinde]

Dropdown field in SP list? - here is code to update choice field in SP list using patch. Patch('List Name',{ID:CurrentPRItemID}, { Status:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Id:1,Value:Enter your value here}});

[@bavajijhon8737]

I want small help form your side help me sir

[@SarveshShinde]

Tell me.. what help do you need..

[@SarveshShinde]

@@bavajijhon8737 - Sorry but I am not able to understand what you have written. Can you please write it in nice way. Try to use . , in your sentence.

[@bavajijhon8737]

How to create relation ship between parent and child and how to create multiple rows in single column in share point list

[@SarveshShinde]

@@bavajijhon8737 You can easily build casecaded dropdowns, use dropdowns and bind collections to it. Refer this video kzbin.info/www/bejne/r4LUdWmZe9Wqfrs About storing multiple rows in single column - you need to concat all rows/columns into one single string (, separated) - and then store this in multiple text field. while retriving you can split string into a collection object and bind it to gallery - check this repeating table video.

[@bavajijhon8737]

@@SarveshShinde sir I want to your help this my mail id [e-mail] give me your contact number I will talk u sir

[@narenderguguloth8469]

Your video has no clarity . how to pull data back from Share point . could you please share os

[@saanisirajulhaque375]

I am getting error in pulling the item ForAll(Split(AllItemsString,"|"), Collect(CollItems, {CItemSerialNumber: Text(Last(FirstN(Split(Result,";").Result,1).Result).Result), CVisitorName:Text(Last(FirstN(Split(Result,";").Result,2).Result).Result), CVisitorPhone:Text(Last(FirstN(Split(Result,";").Result,3).Result).Result), CVisitorEmail:Text(Last(FirstN(Split(Result,";").Result,4).Result).Result), CVisitorCity:Text(Last(FirstN(Split(Result,";").Result,5).Result).Result)})) Error is coming like the Result is not recognized what misttake I am doing can anybody help me please

[@piyushborkar1988]

instagram id plz

[@karlajoselynmunozsilos5907]

My first line is not saved in my collection :( any reason why? All the next ones are saved but not the very first help please

[@lenzypetty1097]

Great video. I like the repeating table video, but I want Inputs for my individual Item or Record to have input as (1) single line text (2) number, and (3) choice drop down. Is that possible?

[@SarveshShinde]

You mean in repeating table - you want text, number and dropdown fields to be added? Yes its possible. Just add TextBox, TextBox (with number formatting), Dropdown list in Gallery Item Template.