PowerApps Repeating Tables like InfoPath Part 1 - Enter the data

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 an expense report. We will do this by customizing a gallery to make it the repeating table including full tab support for easy data entry.
Part 2 is here:
• PowerApps Repeating Ta...
Link to video on Collections
• PowerApps Collection -...
For more information check out PowerApps911 www.PowerApps911.com

[@briankeller5267]

I'm an RPA Developer and we are routing invoices through SharePoint List and Power Automate for a client. We needed this exact solution. Shane! You are the man. This was so good. So good!

[@DavidCastilloOnGoogle]

Hi Shane, Truly appreciate your effort in teaching us this and other applications on PowerApps. I am proud to say that because of this, we will be launching our budget approval platform mainly on PowerApps (with SP as backend and Flow for the workflow engine). Truly would not be able to do this without your help, man. Thank you very much! David

[@ShanesCows]

Great. Thank you for sharing. 😻

[@suebrower2275]

Shane! Thank you so very much for this video. It is still relevant 6 years later!!

[@ShanesCows]

You are welcome. It is a fun one for sure. I promise a newer version is coming. Just got to get my ducks in a row. 🤩

[@colleenparker-trueblue234]

Shane, please know how much I appreciate your videos. They are so thorough and helpful!

[@ShanesCows]

Glad they help you Colleen. 😻

[@terrisepulveda627]

LOL I am going to put together a video of Shane's facial expressions! I get a good laugh and I learn a lot. Thank you Shane aka PowerApps Rock Star

[@ShanesCows]

Sounds awesome! Send it over when you get it done. Or send it to the PowerApps911 help desk. They love that stuff.

[@antera30]

Thank you for sharing this Shane, my position is safe now

[@ShyamKumar-rl3rw]

Meaning?

[@altino91255268]

This sequence of three videos has already taught me a lot !!! I can use this logic for so many things !! Thank you Shane!

[@ShanesCows]

Glad to help. Those are some of my favorites I made.

[@terrisepulveda627]

Shane, you are totally awesome! I combined the Animation video mechanics with these mechanics and I have a blinking label that comes up instead of the icon! The instructions are precise , but allows building blocks like the blinking label. I would not have successfully completed my project(s) without these videos. On behalf of the Powerapps community.....Thanks again!!!!

[@avisinha2844]

hi terri can we connect, I had some doubts, i was wondering if you can help me with this?

[@zakirshaikh8448]

Hi Shane, Thanks for the video. I was stuck in a App with the same requirement....Thanks

[@ShanesCows]

Cool.

[@spuds518]

Another great video, thanks a bunch!

[@ShanesCows]

Happy to help Mackenzie

[@melaniedillmon9283]

Thank you so much, Shane! These videos are enabling me to help our team quite a bit in PowerApps. I am making great progress in learning the program thanks to you!

[@ShanesCows]

Happy to help.

[@Ksra09]

new subscriber ! Our University is moving from SP2013 to SPMod and the rest of M365/Teams/PowerApps/PowerAutomate. Tons to learn. Videos like yours are priceless. Very clear, good pace. I'll be creating my first repeating tables application over the next couple of weeks (Asset Disposal). Anyhow my main thing here was a huge thanks for this ! On to parts 2 and 3 ..and the rest of your vids. High quality instruction..

[@ShanesCows]

Thanks Brian. Enjoy the journey. The platform is awesome.

[@marioramos5384]

"Really super geeky" -legend

[@ShanesCows]

🤓

[@zebensuimontenegro1399]

Hi Shane, congratulations for your video. It's very helpful. MasterID column is a text column or a search column? I think if it's a search column, It won't work. How can you obtain a text MasterID column from the expense máster list? Thanks a lot

[@ShanesCows]

It is a text column.

[@PattyJames3478]

I had a little bit of how to do this one also but then figured out... The ID column is already a column that was not default shown in the "Master" list view. If you go in and change your view to include the "ID" column it may make more sense.

[@csjo77]

Great video, Shane! Thanks for posting... I'm a total PowerApps noob whose first app basically involves eating an elephant all in one bite (probably there'll be at least 5 or 6 collections/galleries/etc that all have to tie together)... I think you've now helped me make that possible!

[@ShanesCows]

Cool. Take your time with baby steps.

[@Kimmy-xz3is]

Shane, you are a GODSEND! You were referred to me by ANOTHER genius. That says a lot. I hope you get paid in some way for your time. I'm sorry if you've answered this already. 230 comments to ready through - heavy sigh. I really don't want two lists - unless I have to. My project is for the following : one purchase order for several items that need price adjustments. So, let's say I have 3 list items on 1 PO that need correcting. Once entered, a workflow will kick off. It's important that only one PO is assigned to those 3 items so only one action will be performed. So my problem is staying in the realm of the collection and the one list. At least I think that's my problem. I have too many errors to list.

[@ShanesCows]

Hi Kimmy. If you want to have variable amount of items two lists will be the best solution. Sorry

[@kevingordish9529]

Made one small improvement; Added a Patch(CollectName), Defaults(CollectionName), {}) to the save button; that way if someone does not click add line item row; the current row data gets saved by auto adding a blank row.

[@ShanesCows]

Thanks for sharing. Happy 🦃 day

[@glennbullion9069]

Could you go into details a bit more about this? I am trying to implement this same thing, as some users are forgetting to save the last row. But can't quite get this to work.

[@sbusisosakhiledlamini1324]

You the best Shane! I was struggling with these for the past 24hrs.... you nailed it man!!!!

[@ShanesCows]

Awesome!

[@basstubamatt]

Great video, Shane. I'm a complete novice in PowerApps, and this video helped me build out a shopping cart app.

[@ShanesCows]

Great to hear!

[@benhaynes4677]

Brilliant helped a lot. Like the way you explain each function so that there is an understanding of exactly what you have done

[@ShanesCows]

Thanks Ben. Glad it helped you. :)

[@ASoumakie]

This is great Shane, you've covered most of the concepts might be needed in any form!

[@ShanesCows]

Thanks 🐶

[@nhalblandin]

Just getting my feet wet in Power Platform andcame across your videos Shane. I find your content invaluable, keep up the fantastic work.

[@ShanesCows]

Awesome! Thank you! My free intro class might be good for you. Canvas Apps, Model-driven Apps, Power Bi, and Power Automate all in a free, short class 🤩

[@cyberinspired]

Shane, Thank you for your videos. You make me look so good with the apps I've developed with your help.

[@ShanesCows]

Awesome! keep up the hard work of building apps and learning. It will pay off.

[@0619421034]

Hey Shane, Amazing video, it is people like you who makes life easier for others.

[@ShanesCows]

Glad to help. 😀

[@bluerondo]

LOVE this - you just solved issues with MULTIPLE forms I'm trying to upgrade from on-prem (old) SP to SPO and PowerApps!!! Thank you!!!

[@ShanesCows]

Awesome. Glad it helped you Shelley!

[@michaelcampbell6721]

Amazing.......so easy to follow and I love how you do step by step.....it really helps!!!!

[@ShanesCows]

Thanks Michael

[@lsf87]

Great video Shane, easy to follow. BOOM moment getting the line items into the second list :) Looking forward to the next video.

[@ShanesCows]

Thanks. :) Next video hopefully today.

[@traceyrheeder7479]

Hi StefanieHow did you get the Line Items to the Details List? On my app the Master list updates but not the Details List. I think it is an issue with the MasterID column - did you create this column manually in the list?ThanksTracey

[@lloydcain1879]

@@traceyrheeder7479 Do you figure this part out? Thanks

[@veronicasolano6792]

Lloyd Cain hi, I am facing the same error. Where you able to find the solution for this? Thank you!

[@ScottRosenbloom]

Hey Shane. This worked really well for me, so thanks very much for that! I'm creating a table of entries in a gallery of the various levels of a building. Some levels are above the first floor, and some are below. I want to be able to ask the user how many floors are above and below, and then create the corresponding entries in the gallery (with values of zero in each field for each record, which can be filled in by the user later), and also indicate which of those entries correspond to the levels above and below the first floor. I created a button that creates a new blank entry, with the following as the ONSELECT value: Collect(Ch2AreaCollection, {LvlName: "", LvlExArea: 0, LvlNewArea: 0, LvlTotArea: 0}) What I don't know how to do is repeat that function the amount of times, based on the user's input. Do you have any suggestions, and is that even the best approach? Thanks very much, and keep up the amazing work!

[@ShanesCows]

Sequence makes this much better these days. kzbin.info/www/bejne/pXytnImuZ8yYntk

[@thristanvasquez4882]

Thank you for this video. So helpful. More power!

[@ShanesCows]

Your welcome! 😻

[@sc6084]

You saved my life. Mucho mucho thanks!

[@kevindibb6534]

I've watched this video about 50,000 times. It finally clicked on about the 49,999th time. Thanks.

[@ShanesCows]

Awesome!

[@dcase84]

One change I made is I put my detail labels on the canvas, outside the gallery so they act as a 'header' row. Saves a lot of real estate that way.

[@ShanesCows]

NICE!!!

[@ziadhamandi3595]

Very nice Shane. Your videos are straight to the point. That is what I like about them. I personally prefer to click on “add new item” after save, instead of just tab. Can you touch on that concept please? Thank you.

[@ShanesCows]

Thanks Ziad - I actually had that in the original version and took it out. They way I did it was: I made a floating button at the bottom of the gallery. I show you how to do that in this video: kzbin.info/www/bejne/epCuk2p3jbh4ZtU Then set the Onselect in that button to create a new row in your collection. Does that help?

[@Chuckgtz]

Great video! So helpful Thank you.

[@ShanesCows]

You are welcome

[@Macedvisioned]

Great video. Looks good to use these great InfoPath functionality in PowerApps.

[@ShanesCows]

Thanks 🙏

[@jhhatcher1885]

Thanks Shane - I know this is an old video, but it works great. I had a few issues at the start - I was getting blank rows in my SP list, but I found the error and it works great now. I had to use ThisItem for the naming convention of the textinputs.

[@ShanesCows]

Glad to help. 😀 this is one of my favorite concepts still.

[@jhhatcher1885]

@@ShanesCows Oh wow, I didn't think you were still monitoring these. You are a great easy to follow instructor. Question? How would you put a date picker and or a dropdown in a collection - similar to how you entered the text, but I would rather have a DropDown and a date picker?

[@cedricbouve]

you are the best for power apps it is so interesting thanks you so much

[@ShanesCows]

Thanks. 😍

[@keithgallagher8242]

Hi Shane, thanks for the brilliant tutorials. I have watched quite a few now and everyone has helped me to learn more about PowerApps and sharepoint. I have successfully created the basis of an app using your repeating tables video but I was wondering if there was a way to keep the new blank row at the top of the gallery rather than scrolling down as you add rows.

[@ShanesCows]

Sort your gallery. 😀

[@fklatecki]

Looking forward to the next videos...who says there is nothing to watch during the summer re-runs!

[@ShanesCows]

I am no Game of Thrones but working on it. :)

[@generice3398]

Shane, this series was a tremendous help! However; is there a way to make the fields in the gallery required?

[@fernalication]

Shane, thank you so much for contributing to the community with such useful videos. I'm having some issues (of course) with repeating tables. Thing is, every time I try to create a new item on the 'gallery', it gets created but the first/last one is deleted. No clue what could be happening, just followed same instructions provided on your video. Any comment/suggestion will be much appreciated. Thanks and keep it up!

[@ShanesCows]

Are you maybe using ClearCollect where you should be using Collect?

[@fernalication]

@@ShanesCows - I found it. My error was to add text input boxes but not changing the default value which was "". Then I changed for my custom names (LineItem in your example) and works like a charm. Thanks!!!

[@simonetic]

Thank you very much for your videos...!

[@ShanesCows]

You are welcome.

[@sribalajispaceship]

Helped a lot..thanks!!

[@ShanesCows]

You're welcome!

[@mhysa-solution]

Super explaining. great video

[@ShanesCows]

Glad you think so!

[@danielcarver7403]

This is great, thanks for sharing!

[@ShanesCows]

My pleasure!

[@nikstaron6843]

Thanks so much, I want to try this for a project, I'm working on.

[@ShanesCows]

Hope your project goes awesome!

[@leslieevetts2103]

I'm new at this and watching your videos has been very helpful. I was wondering about setting up the repeated table, if the first box could be a drop down that pulls information from a SharePoint list that then will auto populate other boxes? I have built number of InfoPath forms in this way to save time and hoping this will work in PowerApps as well.

[@stefancochrane2723]

Many thanks, Shane! This looks very promising. In my case, my PowerApps is for a customized SPO list. I added the gallery inside a custom card in the form, and in previewing, it seems to work fine. When the SPO item is opened in Edit mode, I'll figure out how to get the collection from the 2nd list to populate the items. After publishing, the 1st row in the gallery doesn't appear, though. Has anyone else tried this method with a customized SPO list? Thanks! Steve in Spain

[@isahacker]

16:47 hahahahah this is your problemmmmmm epic lol !!! Thank you for taking the time to share your knowledge

[@ShanesCows]

😂

[@PowerThingsWithWes]

@@ShanesCows does the "Tab Order" property of controls not help with this problem? (I understand this video was probably made before that property.)

[@tonyocnos6691]

You just won another subscriber!

[@ShanesCows]

Awesome. Thanks, I hope you enjoy. Lots to learn. 🐶

[@lecuae]

Thanks, Shane, Such a great video. Just created a similar form unfortunately when I run to enter the line I cant see the form on running.

[@user-wt1mr7mp6k]

Hey Shane, The video is excellent and helps me a lot! I would like to know if you can help me regarding the initialization of a date field in the collection, the initialization in the form "" is of text, thus creating a problem for me to use the patch function into a date field.

[@thiagocurtolo6927]

Thank you so much Shane 👏💪🚀🚀

[@ShanesCows]

Happy to help. Have a great day. 🐶

[@gerardosalazar2351]

You are the Best!!!!!!!!!!!

[@ShanesCows]

Awe shucks. You are too kind.

[@Phatgam1ng]

Hi Shane, Great Video really helped me move from an ancient sharepoint system using infopath forms to using powerapps, One quick question, is there a way to save all the items added to a gallery rather than having them save each line before adding the next item ? So to save all the gallery items input them submit them to sharepoint ? Thanks

[@altyrocks]

This video is a lifesaver. Thanks so much! What is the syntax to add a dropdown that pulls from another Sharepoint list to the collection?

[@ShanesCows]

If you had a dropdown you would set the Items property to be the SharePoint list. Also, make sure you set the Default of the dropdown to ThisItem.ColumnName

[@oraben1034]

it really helpful thank you

[@ShanesCows]

Welcome

[@konstruktionsburojb6848]

I just love the style of your tutorials. I learn a lot while actually doing and that suits me perfectly and I am slowly building up a stockpile of useful bits and bobs. However, some bumps on the road for the beginner - especially when you do PowerApps in Scandinavian - right now I am a dead halt when setting button1 up for the ClearCollect function; it simply will not accept the syntax within the brackets and it is driving me bonkers.

[@ShanesCows]

Share your code here and I will see if I can help.

[@konstruktionsburojb6848]

@@ShanesCows This is how it ended up looking, with some extra code from the ensuing videos - and it works too: NewForm(FormMasterData);;ClearCollect(ColExpenses;{LineItem:" "; LineCost: "0"; ShowSaveButtons: true});;Navigate(ScreenOpretPostering; ScreenTransition.None) The double semicolons are a Scandinavian formatting thing, but the real cruncher was the need of double quotes surrounding the 0. That took some hairpulling :)

[@ShanesCows]

Glad you got it. And thank you for sharing.

[@renebernalolmos9533]

Really good videos to start working with repeating tables and develop your first nice powerapp, thanks for share your knowledge. I just have a question, how can we make our Collection updated in the case you does not have a button to go to your form screen? I mean, If you have just one Screen - the form, and you add the clearcollet on the OnVisible event of the Screen, the collection it is not update it, Why? How to solve this?

[@Luca_040]

This is so awesome!

[@ShanesCows]

Thanks

[@Luca_040]

Thank you too and best regards from SGS Germany!

[@Saadssk94]

Love this guy

[@ShanesCows]

Thanks 🐶

[@husseinakberali6516]

Hey Shane, this is awesome. Really appreciate your hard work and patience with going through these different scenarios. I was just wondering, on the repeating table, is it possible to have an attachments on the Gallery Input? Thanks again, your video's are class!

[@ShanesCows]

Yes save the file to a collection and then you can save it to the data source with a ForAll

[@husseinakberali6516]

@@ShanesCows thanks, appreciate it

[@ramnanwani4725]

Thanks for the amazing video. Very helpful The new line in my gallery is going vertical instead of horizontal.

[@stetsonaustinfleming7528]

Really great lesson. I think I might have bitten off more than I can chew(y). When I put in more than on record in the repeating table, It doesn't record more than the first creates multiple entries in the list but the are duplicates of one another (except for the ID). It kind of nullifies the whole point of it.... and the last week of learning powerapps.) You offered help, I am calling upon you to show this newbie what he has done wrong.

[@ShanesCows]

Stetson usually the issue is your patch formula isn't referenceing the values from the collection but instead you are calling the control names. That is why you get the duplicates. Good luck.

[@kylewalp5897]

Great stuff! How do I accomplish something similar but with AAD users within a Dataverse table column? Requirements for my app have changed so that I believe it warrants migrating from SharePoint to Dataverse as the data source, however I cannot seem to replicate the People Picker multi-select functionality.

[@PrasadChinna]

Thanks for the nice video on repeating table. I have a question, you have written onload of the form in 'Create New Expense' Button OnSelect Event instead can't we write the same in OnLoad of NewForm. I didn't find OnLoad method, how can we achieve it? Please suggest me. Basically I want to achieve this functionality in SharePoint list form for New, Edit, and View.

[@hrchiar]

Hello @ShanesCows thank you for the excellent training. But my gallery delete the values entered when I click on Save button, the collection create a new line but delete the data in the previous line, it can keep the data as saved. Could you please help me?

[@susanteng3592]

Thank Shane. Your tutorial is very helpful. I see you use ForAll( ) in Form1 onSuccess to save the ExpenseDetails information to sharepoint List. If I don't have a master list and only need to save ExpenseDetail List. What code I should put in the SAVE button?

[@ShanesCows]

Susan it would be a form of the ForAll code from the OnSuccess you would use in your button OnSelect. Here is a whole vidoe on ForALl if it helps. kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@acranny]

Hey Shane, Thanks for your videos they are fantastic. Having an issue posting data back to on premise SQL table where its attaching all rows for multiple entries, but using the last record data for all entries. Anything feedback/help you could provide would be helpful

[@ShanesCows]

Share your code and I will try to help.

[@williamfenner823]

Hi Shane, love all your videos and this series of vids has helped my solve my InfoPath dilemma. One question, and using your Expense Form as an example, what is the best way to write the Total number of successful "ExpenseDetails" items to a field in the "MasterDetails" , so if the were 5 successful "ExpenseDetails" items, update a field (e.g ItemTotal) in "MasterDetails" with 5?

[@ShanesCows]

CountRows in your collection. Similar to how we update the total expense.

[@georgeevans2087]

Shane, This was a great help in making up a POC app for my Company. Thank you so much. However, I ran into the same issues that a couple of commenters here described. Namely if a drop down control is included in the list/repeater then the selected value is not preserved if the page does a "postback" type operation. In this case it always reverts to the initial stae of the control (first record in my case). I can see WHY it would do this, but wondered if there might be a way to prevent this behaviour that you know of? In other framework tools I have seen, there is an "on pre render" event that fires after initial load that you can use in conjunction with Session (maybe Context in PwrApps) variables. If this existed (or better yet MS made a Repeater object), it would propel PowerApps to the head of many peoples queue for dev tools. IMHO an editable "one to (not sure how) many" relationship in forms and reports is an incredibly common scenario. We can work around this with page branching etc. but how many of our users really want the extra clicks and distraction of a new page? Anyway, like everyone hereI really do want to applaud you for the effort you put into these tutorials. Great job.

[@ShanesCows]

George if you set the dropdowns Default value to ThisItem.ColumnName it shouldn't revert.

[@J7d-tm2iy]

Nice, you're a crackup, so good. Thank you

[@ShanesCows]

Appreciate that 😎

[@itpatel7268]

Thanks for the great video Shane, I have learned a lot. One question, is there a way to make LineItem and itemcost mandatory text input so that way before a user clicks on 'Save' icon, it can show something like a validation message that either of the column are not populated, can you advise please.

[@ShanesCows]

Set the buttons display mode to disabled until those fields are not blank.

[@michelleclark5269]

Hi Shane! Loving the videos and learning so much from you - thank you! My tab space isn’t working though - any tips? And the icon is below the box!!

[@ShanesCows]

I don’t. They are just really finicky😔 with enough moving and shaking you should be able to get it to do what you want.

[@sagirvideos]

Hey Shane! Cant express how much this has helped! You make it real simple and easy to understand and follow... I have am stuck trying to use a dropdown option in my collection... can you help?

[@ShanesCows]

Glad it helped. What isn't working?

[@sagirvideos]

Thanks for hitting me back so quick :) On the "gallery" section, I have a couple of dropdowns that are linked to a sharepoint list, and I am not being able to get the default selected to blank - it always picks the first option or the option selected in the previous entry. The dropdowns on the "form" section, work fine with the default being blank... I noticed the dropdowns on the "form" use 'choice' function instead of 'distinct'... can you also help understand how these are different... and how i can make 'sort' work with 'choice' Here is the code snippets i have.. CertsCollection is the name of the collection. LineOrg and LineCert are the dropdowns. LineDate is a date (works fine), LineAgency is a text field (works fine)... On the Button... NewForm(FormMaster); ClearCollect(CertsCollection, {LineOrg: "", LineItem: "", LineDate: Today(),LineAgency:""}); Navigate(NewItem,ScreenTransition.Fade) LineItem Save Button... Patch(CertsCollection, ThisItem,{LineOrg: InputOrgDropDown.Selected.Value,LineItem: InputCertDropDown.Selected.Value, LineDate:InputDatePicker1.SelectedDate, LineAgency: InputAgencyName.Text}); Collect(CertsCollection,{LineOrg: "", LineItem: "",LineDate: Today(),LineAgency: ""}) This is how I have the Items property on the dropdown set... Sort(Distinct('Certificates List',Title),Result) Hope I was able to explain... let me know if you need anything else...

[@akshataudoshi308]

Hi Sagnik, Please let me know if you were able to get the dropdown values, I am also facing the same issue.

[@Javierzorromorales]

Hi, shane, thank so much

[@ShanesCows]

😀

[@connorwilkinson6575]

Hi Shane, great vid!!! How would i go about patching a date section when trying to adjust the "Save" button in the gallery? Also, in the "OnSuccess" section of the form, how did you manage to lookup the "ExpenseDetails" list? My form doesn't appear to recognise my second list. Thanks again.

[@ShanesCows]

Connor you can use the Now or Today function to get the current date or time.

[@valachohc]

Extra observation, the save button icon, at least now, perhaps not when this video was created, when it is inserted, it seems its Tab index value defaults to -1, which means it won't be part of the tabbing function. Changing the Tab index property of the icon to 0, so that it is recognized, makes it work as expected.

[@nihar4713]

helpful

[@theshao]

Further to this, the whole point of the "tab index" property is to set which order properties are selelcted in when tabbing, so the whole "make the save button below the other fields" can be avoided by giving them all indexes in the order you want to tab between them in...

[@pattywilliams7314]

This is a great video series Shane! I'm following along to build my own app, but my gallery has dropdowns (not combo boxes) that lookup to separate lists. One thing that's happening when I click the save button on a row is that, although a new row appears, all the dropdowns on the previous row revert to the defaults. I've googled this and found posts talking about setting the "DefaultSelectedItems" property for the dropdowns so they retain the values I selected, but I can't for the life of me find it. Can you point me in the right direction? Thanks!

[@ShanesCows]

Patty did you set the dropdown columns to have Default properties from the collection ThisItem.something

[@murieln.8433]

Hello Shane, Thank you very much for this interesting video. I would like to know if there is a way to have one SharePoint list for both the gallery and the input form?! As in I put some of the list fields in the input form and the rest in the gallery. Thanks in advance for your assistance.

[@debaratiray2482]

Hi Shane, Thanks for all your informative videos. I want to bulk upload from excel /or bulk copy paste from excel to the repeatable table. Can you help me how to proceed with this requirement?

[@ShanesCows]

I don’t know how to copy and paste like that. This video shows you how I import. kzbin.info/www/bejne/h5S6m3SqbLaJpJY

[@agytkumar]

Thank you for this video. Really helpful. I was wondering if Form1.LastSubmit.ID mentioned @ 22:50 will always work? e.g. In case of a heavy use app where there might be near simultaneous submits. Can you please make a video explaining any other way to get the ID (like querying the DB for the correct ID)?

[@ShanesCows]

It will always work. Last submit is per user no worries.

[@jameswolstenholm858]

Shane, I am trying to patch data (part information) from an SQL DB into a collection, so additional data (quantity) can be added but I am getting stuck. Right now, my syntax is Patch(CollectionName, DBName, {records}). I have no problem if the source info is a SharePoint list but not having luck with a DB.

[@ehabatme5324]

Big thank you for all your valuable contents. I’m not an expert, but doing well because of you :). I have a question to how I can receive a Purchase Order with segregating item quantities by adding serial, barcode, etc..

[@ShanesCows]

Look into Concat function video

[@JohnMahoney1]

An Idea I would like to see if how to properly create a SP or Excel list, or sheet, to work with PowerApps. Many times you see something and what is missing are basic settings on the data-source. How do you prepare a list for a Powerapp which will need to show a dropdown list, what are the problems, or gotchas? Also, moving something like the Budget Template from Excel to SharePoint which was started in the Friday Functions Series but never finished! ;) Just some ideas! Again, thank you for your great work. It is appreciated.

[@ShanesCows]

Great idea. Thanks. Did you see this video. I talk a lot about how to setup your Excel file here. kzbin.info/www/bejne/Y4vCYmaAZZeFhrc

[@mtamitolanga]

Hi Shane thank you very much for the videos. The relationship between the master list and the details list, was it created in SharePoint or is it created when posting the data from PowerApps to SharePoint

[@ShanesCows]

PowerApps created and maintains the whole relationship.

[@kreali75]

Thanks for the video - working through applying this and am running into a few issues. I'm using SharePoint lists - Parent list is "Scheduling", Child list is "Single" with a lookup field back to the title of Parent (SchedulingTitle), and Collection is DSingleCollection. My form is called 'Basics'. My Patch statement is: Patch(DSingleCollection, ThisItem, {CTitle: InputTitle_2.Text, CUPC: InputUPC_2.Text, CFormat: DropFormat_2.Selected.Value, CReleaseDate: InputReleaseDate.SelectedDate, CExplicits: DropExplicits_2.Selected.Value, CMktTerritories: DropMktTerritories_2.Selected.Value, CBeatport: ToggleBeatport_2.Value, CAssetsDue: InputAssetsDue_2.Text, CPartnerTerms: DropPartnerTerms_2.Selected.Value}); Collect(DSingleCollection, {CTitle: "", CFormat: "", CUPC: "", CReleaseDate: "", CExplicits: "", CBeatport: false, CMktTerritories: "", CAssetsDue:"", CPartnerTerms:""}) and my OnSuccess statement is: ForAll(DSingleCollection, Patch(Single, Defaults(Single), {Title: CTitle, Format: CFormat, UPC: CUPC, Beatport: CBeatport, Explicit: CExplicit, 'Mkt Territories': CMktTerritories, 'Partner Terms': CPartnerTerms, ScheduleLink: Basics.LastSubmit.ID})). 1) Can't seem to get the lookup to work 2) The entries for the repeating table work as long as I hit the save icon to open up a blank row at the end...then a blank row is inserted into the child table as well. Thanks!

[@ShanesCows]

Lookup columns are the devil. If you are going to use them then you will have to find the special azure syntax for patching the complex column.

[@devangmistry6307]

Thanks for the great video. How would it work if I have drop downs and date picker for repeating tables along with text input

[@ShanesCows]

Should be same concept. Nothing different I can think of.

[@devangmistry6307]

@@ShanesCows Thanks a lot, it works.

[@bethjohnson889]

I've been using my variation of this app for quite a while now and it's been excellent - we've been using it for recording defects in a car production factory instead of invoicing. I have some questions about saving additional information against each line item. On the form I have a colour drop down and a shift drop down and i would like these to be saved against each line item like the master id is. Is there a way to code this in? I've also got things like dates which would be useful to have next to each line item as this helps to filter the powerbi data where the data is displayed for our directors. Currently I'm doing this manually but getting this done automatically would be so helpful! Thank you for this video - so easy to follow and has taught me so much about powerapps

[@ShanesCows]

Hey Beth. All things are possible. 🤩 I would guess if things like Shift are static when you are adding items setting that into the collection would be the way to go. Have the collection populate it with a variable and set the variable when they start adding data.

[@radiosonicfan1726]

Any tips on prevent date picker/drop downs from being reset when the 'save button' is clicked. Data is save to collection, but confusing to any adding rows and seems like data from previously row went up in smoke. Any donation links?

[@SharePointIn60Seconds]

great video! is there a way to use an existing SharePoint choice field in the repeating table?

[@markhannah3573]

This works great Shane! I do have one question - How can I get a DatePicker (Date field in SP)and Dropdown (choices field in SP) controls I inserted into my Gallery as part of my collection to transfer to SharePoint. I think I need to change the value when I make a collection using those types of controls. For example do I put "" or 0 or something else when I ClearCollect? "" works for both of those when I make the collection, but not on the OnSuccess of my form. It says it is expecting a record, but is seeing text. The only thing I can figure is that my collection formula is wrong for those two controls.

[@ShanesCows]

Use Today() for the date field and for the Dropdown it will depend on the structur of the SharePoint column you are writing to

[@Test27344]

Hi Shane...great video!! I was just wondering if you had any suggestions if I needed to have 2 repeating sections independent of each other in the same app? For example, one repeating section for the quantity and price of an item and another repeating section for the funding sources? Thank you.

[@ShanesCows]

It works. I have done it before and I call it grand child tables. 😀 Same technique you just need to connect the dots. Sorry don’t have a video for that

[@jl1399]

Do you have a video similar to this but with a SharePoint integration list? It would be different because the list item would have to “know “ what to pull in from the other list

[@bethmahoney3069]

Shane, are users able to use the "Edit in Quick View" to edit the data? It seems like all of the calculations are in PowerApps and that using the Quick View would not be recommended.

[@ryanbond8022]

Hey Shane, thanks so much. What reason do you have for using ForAll and patch to save the repeating data instead of just collecting the collection to sharepoint?

[@ShanesCows]

You could if the columns matched. I typically like ForAll since it give me more control. But collect could be used in some cases

[@utpalchalise]

Hi Shane, This was really great. I am using SharePoint list form customization, and I am running into issue with bulk submit to child list, onSuccess for submitting to parent list. SharePoint form is split across 5 screens.

[@ShanesCows]

Sorry I am slow. Hopefully you got this figured out.

[@utpalchalise]

@@ShanesCows Thanks Shane, I was able to figure it out. I found out that OnSuccess only works with SubmitRequest, not Patch. Currently my issue is gallery not rendering in preview mode, and modern page, where I had embeded the form.

[@mrtanner87]

Shane, Love all your videos. Cannot get this one working though. I can't work out how you get the MasterID column. I only have ID columns and can't rename them. Am I missing something simple??

[@ShanesCows]

ID column doesn't change. In the child list (Items) add a number column called MasterID. 😎😎

[@mastalayne]

awesome!

[@ShanesCows]

Thank you! Cheers!

[@madihasalman1]

Hei Shane learned a lot from ur videos . I have question since u r doing saving of data on one screen . What if we have a big form and we split into two screens . How we can do that ??

[@ShanesCows]

Check out my video on Tabs. kzbin.info/www/bejne/n5fCnnl_m85ohq8 That is what I do. 😻