PowerApps Repeating Tables like InfoPath Part 1 - Enter the data 

Great. Thank you for sharing. 😻

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

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

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

Meaning?

Glad they help you Colleen. 😻

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

Cool.

Happy to help Mackenzie

Cool. Take your time with baby steps.

Happy to help.

It is a text column.

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.

🤓

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

Sequence makes this much better these days. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-oKJkVx2gehw.html

Thanks for sharing. Happy 🦃 day

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.

Great to hear!

Awesome!

Thanks 🐶

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 🤩

Thanks Ben. Glad it helped you. :)

Thanks. :) Next video hopefully today.

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

@@traceyrheeder7479 Do you figure this part out? Thanks

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

Glad to help. 😀

Sort your gallery. 😀

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

Awesome. Glad it helped you Shelley!

Thanks Michael

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

@@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!!!

Awesome!

NICE!!!

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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D_Kb7AXSE0s.html Then set the Onselect in that button to create a new row in your collection. Does that help?

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

@@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?

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

@@ShanesCows thanks, appreciate it

Your welcome! 😻

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

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

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

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

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

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

@@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 :)

Glad you got it. And thank you for sharing.

PowerApps created and maintains the whole relationship.

Share your code and I will try to help.

Thanks 🙏

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

😂

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

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

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0xZ4fMJbLvk.html

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

I don’t know how to copy and paste like that. This video shows you how I import. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QcWjAt7QVn4.html

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

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

@@ShanesCows Thanks a lot, it works.

Check out my video on Tabs. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-if_mFIfi5PM.html That is what I do. 😻

Look into Concat function video

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.

Glad it helped. What isn't working?

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...

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

Check your patch. What do you have?

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.

Yes possible to have 12 fields not possible to have both scrolling.

You are welcome

Try this video for help with Excel ID. PowerApps Excel Auto Increment Column ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-plKw_xfVfwY.html

You have to set the DefaultSelectedItems of the Combobox to a value from the collection. 😎

@@ShanesCows Oke I did that with the combobox, but what do I enter in the label.Text? I want the value that is filtered from the result of the comboboxes. Patching to the collection

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

Sure. Just set the button mode to disabled if you have any blanks.

@@ShanesCows Boom! Thanks very much, works perfectly.

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

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.

Try out this video. PowerApps Excel Auto Increment Column ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-plKw_xfVfwY.html

Dropdown.Selected.ColumnName is valid throughout your app or you can set it to a variable is better. ForAll will work across your app also though you should probably be using ForAll to loop through collections not the gallery.

@@ShanesCows Thanks much!

Thanks. 😍

Try storing those values in a variable and make that variable the default value for those fields.

Thank you Shane will give it a try. Would creating collection work the same?

DateAdd function will let you subtract a month. DateAdd(Today(), -1, Month) is what I think it is off the top of my head.

Check the form mode maybe.

Lookup from where? Make it a dropdown

CountRows function

@@ShanesCows Thanks! I'll look it up.

@@ShanesCows thank you for this great information, it helped me a lot. Could you please let me know how add fixed number of rows and patch them together?

For a week data, Monday to Sunday where there is a column date field which should be auto populated with current week date

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

@@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.

Check your data. You should be able to write a number with decimals

Yes. Set the items property to YourSharePointList.ColumnName

Oh man, can't wait to try!!!

@@ShanesCows Hey Shane i tried this but i got this error message "WArning: The columns produced by this rule are alla nested tables and/or records, however the property expects at least some columns of simple values (such as text , or numbers). Whats the syntax for clearcollect for a dropdown list? i guess its not the same like " {LineItem: "", ". . But i cant find what i have to write.

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.

Yes. Put in a dropdown control, just remember to set the Default property of the dropdown. :)

Check the default values for the inputs. Should be ThisItem. And then your column name

ForAll does let you loop through a collection and patch the data. So I would think yes.

Great idea. Thanks. Did you see this video. I talk a lot about how to setup your Excel file here. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--Z_13J02RPU.html

You can multiply two columns or controls by each other.

@@ShanesCows i have done it and the multiplication works. However, when working with decimals, the (asume qty = 1 and price 33.33) the sum from the form 1 total shows in sharepoint list as 3333. How can I make i fix it? :(

helpful

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...

Glad you found Power Apps 😀 I would say this video is still the standard way to do it for better or worse.

The haven’t done it but it should be possible. Need to remember that the key is if you are using a combobox you have to get the DefaultSelectedItems property to return a record that matches the items property.

@@ShanesCows Hi Shane! Thanks for the reply. I was able to make it work just like how you suggested. I have another question - I am trying to use a combo and list box on the repeating portion to get multiple values. However, when I setup the Default and/or DefaultSelectedItems to "ThisItem.LineComboBox" and "ThisItem.LineListBox", I get the error "This formula uses scope, which is not presently supported for evaluation". Have you done anything like that? I tried searching for what the error is all about, but could not really find anything that explains that problem. As an alternative, I am also thinking of just using a "Yes/No" column in place of combo/list box and using a check box to determine whether or not the value was picked. The problem I see with that however is when we need to add, change or remove a choice, we'd have to "touch" the power app, something I believe we need to avoid. Other than that, do you have any opinion about using a Yes/No column in place of a combo/list box? Thanks!

Hi, do you have any details on how you figured that out?

@@billmahimer6245 how were you able to make the people picker field not disappear when going to the next line? Thank you