You showed a bunch of concepts in this solution including cascading galleries, contextual variables, adding custom card, mathematical formulas etc. Thanks again for sharing and helping the community!!
Shane, this is amazing!!! This one from Egypt :). I saw the first one too. This is a great job done. You actually inspired me to redo my an entire powerapp application build for inventory management. Again this is Job well done.
I always learn something when I watch your videos. It never occurred to me that you could put a formula in the Patch statement for the Delete button! But now I know. Keep doing great videos. Appreciate how you explain things, too.
Hi Shane, Here you have shown like editing the existing expense details values, how can we add a new expense detail using edit form. Please let us know, i was stuck on this from a week Thank you
@20:43 - When i hit save it seems to take ages to refresh and update the value for me. I'm using an excel database, and it updates the data in the excel instantly, however the page takes 20 - 40 seconds to update the value. refreshing the database, or leaving the page entirely and coming back doesn't speed this up. Any ideas?
Don’t use Excel. 😎 QTT - Power Apps Excel is a terrible data source th-cam.com/video/RtmZM3tm2Zs/w-d-xo.html Other than that you could use Monitor to see where the formula is hanging up but I think it is just due to Excel being not ideal.
Thanks one again. My question is how do you perform the sum when you have so many lines that could be edited and some fields are calculated fields based on other fields
Thanks Shane. Really insightful video and of great help. Quick question. What would you tweak to ensure that you could add a new expense on the editing screen. Your help would be appreciated.
Hi Shane, the edit functionality was very useful for the child, I have a senecio where from the gallery I need to edit parent and child together on another screen, but at the same time child is shown only base on a particular drop down value. If the drop down is something else then edit main list. How do I resolve that??
Thank you Shane, this is a great video and so informative. Is there any way to add the "Comment" section to a PowerApp so the user can add comment and track conversion?
Yes, Frank. What you would need to do is setup a collection like we did on the other screen. And then track that a row was "New" via a column. Then if Column is New ForALl to create the new rows. Several people ahve asked about this. I need to make a video on it. 😀
I have used this several times now and it's amazing. I do have one quick question, is there a way to sort that gallery so the blank row stays at the top of the list rather than at the bottom? I have a scenario where there could be a large number of items added at one time with the requirement that individual items could be added after and having the 'new item' row at the top would be great.
Shane, Great video! A question on collections - Is there a way a new row can be inserted between two existing rows? A customer has a request to be able to insert a row in between.
It is great how you solve these problems, I am extremely impressed. Thanks for the video ! I did everything exactly with what you taught and I feel that my application was slow, how can I solve it? have any tips?
If the amount of data is massive then SharePoint gets slow. Moving to a faster datasource, like SQL or Dataverse is probably the best answer. But without more details of slow hard to say.
Hi Shane, thanks for the video, 6 years old and still going strong! I've followed closely and had success replicating but now wondering how I would go about filtering the data so a user can only see/edit the reports that they have submitted. Can you point me in the right direction?
@@ShanesCows Legend! Two more questions if I may - 1 - The SubmitForm on the Save button for my app is not saving all data back to my SP list. Its saving Title (Single Line Text), Date (DatePicker), Total Expense (Text) and a column that I added (Person/Group) but not the Expense Type (Choice). I have tried the Patch() option and this also did not work. 2 - I think you may have answered this on another video but for the life of me I can't find it - if the user clicks the delete button (which removes the option to create a new line) but then decides they want to add a new line - what's the best way of doing this? Thank you.
Hi Shane. The video was very helpful. I was wondering if there is a way for the edit form to go away once you select save. As of now, whenever I select to edit the gallery and save the changes, the edit form stays on the screen whenever I choose another item in the Master Gallery to view. Is there a way to make the edit form not show when selecting another item, other than returning to the home screen and re-opening the View Screen? Thanks.
Great video - super helpful. Any insight on how to enable a user to add an item to the expense report when they are on the View/Edit screen? i.e. The user is reviewing their expense report and realized they forgot an expense and want to add it in. How does that get added in?
Hello Shane! Great video(s) on PowerApps Repeating Tables ... Question on all the items that are hidden (Forms, Buttons, etc...) .... When in the PowerApps create tool, is there a mode/method/way to know or see items that are hidden on the screen(s) if the items happen to be hidden at the time? If an app is inherited from someone else, how would it be known that a screen contains a hidden gallery, form, button(s), and the placement of those items, just by looking at the screen? Thanx!
Shane, Fantastic! Can you explain how I can Search the "MasterID Gallery" and filter down the "ID" gallery? Example: Have customer info in "ID gallery" and Unit cost and part number in repeating "MasterID Gallery". (SharePoint). How do I search for specific part number in the repeating row gallery and filter the main ID gallery........Wow that was long winded. I hope you get the gist of what I'm asking. Thanks Again!!!
this is amazing. it worked for me. although i would like to know one more thing; How can we show data from multiple sharepoint lists to a single stand alone pa form with the details grouped by a single common column?
Hi Shane.. Appreciate your efforts very helpful. How do I add a new Item to the existing Expense Details Gallery and update the Master Gallery and reflect the same in SharePoint Lists.
@@rupammishra8775 Could you share how you solved this? I cant figure this out. Are you connecting to the collection of the data? Did you add to the form or the gallery? If you could share your code I would appreciate it !
Hey Shane, great video. I followed your instructions but when I create a few records in the collection, the patch function patches the wrong record when I click the save icon, it's as if ThisItem references a different item from the one selected. I've used galleries many times but this one is a bit more dynamic than the ones I have used in the past. I wonder if this is a bug in Powerapps? Gordon.
HI Shane. I've followed the video in part 2 and have the expenses View and Edit working, however on the section whereby I have added the Card and Label field in order to do the calculation e.g. MasterGallery.Selected.TotalExpense - Item Cost + ExpenseCard, this does not work for me. The first step in the above works, and I get the TotalExpense value back in the field, but the rest does not work when I select the - Item Cost in the string the field goes blank and I get a red x circle in the corner. I have checked this by going back through this video in fine detail to ensure I am following this exactly but every time I try I do not get the results you do in the video. My fields are the same and I have changed the same field names as you do in the video, but this part just does not work for me and means I cannot update the Sharepoint list with any changes applied at the item cost level. Can you tell me how to overcome this please. Thanks Stuart
It is great how you solve these problems. Thanks for the video ! I have one question, I followed all your step but didn't understand why do I need to double-click on Save Button to Save, Is there a solution to the problem?
Another fantastic, well-articulated/thought out video. Just to play devil's advocate, what if the user goes directly to the Expense details list in sharepoint, and adds an item with a completely random MasterID? Is there a way to stop users from doing this and only create new records from this app?
Very groovy! So, one question. Is there a way to highlight (change the background color) of the items selected in the different gallery views so you know which ones are selected/displayed when opening up a "child" gallery?
Will do. I'm just getting started with PA - I've been using Infopath for a while and am currently just getting the feel of this - I've only piddled around with it so far, but planning on really digging in this week. Your videos are really helpful - many thanks for putting these together!
@@ShanesCows If(ThisItem.IsSelected,Red,Green) And big thanks for all of these tutorials!! I'm actually moving from an MS Access world, looking for web-based front ends, and am hopeful that PA can do that job.
Hi Shane, Thank you for this wonderful video. Could you please advise for this error message ' Delegation Error. The 'Filter' part of this formula might not work correctly on large data sets.' on Expense Details gallery while filtering from Master Gallery as a result I can't see any Expense Detail for further edit.
Hey Shane, wonderful videos..happy learning!! Can we use PowerApps to break SP list item permissions & set it after item is created / updated. This will mainly help in scenarios where we need to make it read only item once item is sent for approval etc.
I always enjoy watching your videos and like the way you make it so simple for the complex workaround. I do have a quick question on the repeating section you developed. You did create child records from the collection with multiple rows in the Expensedetails list. what would be the case if I delete a repeating section from the form and I still see the record in the child list. Can I delete that from power app or can you please help me how can we delete that. The issue is even though I delete a repeating section and submit the form to main list. View mode of that form is still getting me the record (repeating section) that I deleted. Any help or suggestion please? Thanks in advance!
Shane, thank you for posting all these and all your help! I have scoured the internet to no avail. I am wondering if there is a way to take something similar to what you have created in this video to an approval. I am trying to create an overtime approval app. I would be creating collections of employees for overtime, based one which day (Sat, Sun, Weekday) and sending multiple employees in those groups off to be approved. I am unsure how to get these groups all approved or rejected at the same time. Do you have any resources for solving this? THANK YOU.
I don’t have an easy answer. I would send the table of employees as an email to the approver and then make approvals in the app not using Flow. Look at deep linking video for how I would send the approval.
While this is much more complicated to set up than a Repeating Table in InfoPath, it's actually MUCH more useful. One question, though: For the "ExpenseDetails" gallery...could you throw that into a Collection (OnSelect for the ExpenseMaster Gallery would be "ClearCollect(ExpenseItems,Filter(ExpenseDetails, MasterID = ExpenseMaster.Selected.ID))") and then use the same SUM function as before against that Collection? Basically, pull the data into a local collection, do the calculations, then write it back out to SharePoint when done? I've been trying to use Collections more to avoid delegation issues and (hopefully) speed the apps up a bit by minimizing how much data they need to bring back with each call. I *think* this is one of the intended uses of Collections, but I'm not 100% sure.
Great question Chad. I messed with that a bit and it wasn’t working for me. The clearcollect function isn’t delegatable so same issue. If you find a work around let me know though.
I guess I don't follow how delegation applies to functions like collect and clear collect. As an example, I have an app where it reads from a list of time cycles (academic terms) and I want to return only the current one (where now() >= term start date and = start date and
To your original question. If you use Collect or ClearCollect against a SharePoint it will only get the first 500 items from the list. Technically, you can raise this limit to 2,000 but either way, there is a hard limit. What I would recommend is you read this a couple of times to help. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview Delegation looms large in the SharePoint data source scenarios.
Yeah, I read that through a few times yesterday. It seems like the trick is going to be including fields/columns that can be used with Filter to guarantee that the Collect call is bringing back an allowable/acceptable number of results. The more complicated part is going to be explaining this to our users who hear the word "limit" and immediately start looking for another solution.
Shane, it's not the same exact scenario as yours, but I was able to answer the question I posed originally. Here's a short video showing what I mean (sorry, no audio...too noisy with the neighbors setting off fireworks): th-cam.com/video/oOqUJ45JamQ/w-d-xo.html. Basically, I have a gallery showing "compatible add-ons" for a particular device. Clicking the + adds the item to a collection, then there's a field that provides a sum of the selected items' costs. I was hoping the "repeating tables" thing would help me find a more coordinated way for the app "owners" to manage the data (adding/updating device choices and add-ons), but I've been spinning wheels on that for a few days. For now, they can just manage it in the lists in SharePoint.
In Video 2: Show search reports and edit details (and delete line items). How could you get the collect function of video 1 to add an expense (in Video 2) when the expense details gallery is open? Thanks.
Hi Shane, Firstly this videos help me a lot to achieve the repeating functionality using powerapps. I would like to ask you to make a video of view and edit in the same way you did for New item, i mean can we add the form and gallery for view and edit and do the things over there , i was trying out , but facing difficulty in edit form I just added a form and under that i have added the gallery for edit form, i facing issue in how to save them into the SharePoint list, as this is an update to existing item. If you could make a video on this, it would be really a great help for me, i was struggling for this from past 3 days and could not achieve it Thanks
Shane Young my gallery2 is in a new screen and I tried to add in multiple Dropdown box but the gallery doesn’t filter. Tried to create collection and it didn’t work too
Hi Shane, Thanks for your tutorials, it's amazing and very informative. I am new to powerapps and creating a repeated section. I was able to create new line and save that to sharepoint list. The problem i face is that, when i hit "Save" button to create new line, the new line appears, but the previous line, text inputs disappears. It's available in the collection, but not visible in the form. Really not sure what's am i missing.
Unrelated to my other comment about the data source issue, but I have another question. All of this is based on creating an App from the PowerApps studio.... how would this be different if you were to use the SharePointIntegration where you click 'Customize Form' under the PowerApps button in a SharePoint list? Most of the forms I've created in the past use this as a launching point. For many users, it's easier to view the data in a list format opposed to a gallery. When you create an app via the SharePointIntegration method, you get new properties such as: OnNew, OnEdit, OnView. Would I need to create an Add New Form, Edit Existing Form, and View Only form for each possible option?
Hi @Shane! Thanks once more for such great content! Please, I need and Add Button in this form so we can add new expenses. Can you give me some guide ones about it? Tx
I think part 1 covers the add button? If not use the code from the second half of the save button. It creates a blank row and that is what you want the add button to do
Hi Shane, I am facing an issue. People picker combo box in repeating section is not retaining values in edit form. Can you please help me to achieve this?
That problem is almost always because you are not setting DefaultSelectedItems correctly. It should be something like ThisItem.Peoplefield This video may help th-cam.com/video/AXAbmy9zYTU/w-d-xo.html
Shane I need an assistance, I see that there is no attachment control for both master and slave date in your video, I have it but I am not sure how to add attachment control inside my slave Gallery at the time when the item is being created, can you please help me with that.
Towards the end of the Video once you Delete don't you have to hit the save button so that the changes are updated in the sharepoint. Or doesn't need to hit the Save Button (Auto Save)
Hello Shane!! Thanks a lot for your videos! They are great! I'm from Portugal and I have been showing then to colleagues and friends here and all over Europe!! Now I have a challenge for you: when using a DatePicker in my apps it gives me a nice date in my excel DB. Problem: some of my apps users have browsers in different languages. So when reading those dates they have creasy values. All dates are written in English. Can you make a video how to fix it?! :p
Thanks. 😀. I haven’t done a lot with dates in Excel for international. Wha type might try is storing the date as text and then use the PowerApps functions to convert it to a properly formatted date in the app.
Hi Shane, In collection don't have any data when first time user come so how can I show the table? Whenever I create table columns not display on run time. Please help me out this.
Shane, another great video. Quick Question. Do you know when or if Microsoft will be adding formatting options to Text-Input so it will show as Currency or % in the input box? Or maybe I'm just missing the correct field I should be modifying.
Thanks Rob. Are you asking that you want when a user is typing in the data you want it to show as currency? Or when you are displaying it you want to show as currency?
@@ShanesCows thanks! I need to add multiple lineitems against a parent line item . each child item needs to have an attachment , do you have any videos for this
I am trying a similar repeating table but it is for the same list. Trying to save the repeating table value to a multiline string as it does in SharePoint. My problem is I am not able to load back it in the edit form or display form. I can enter the values they get stored in the string column but how to reload them from the string. How to load the gallery if the string is not null else leave it like a new gallery.
Hi! I have a repeating table (gallery) and it is working fine except that when I add a new row the fields that are dropdowns copy the value of the previous (first) row. How can I make them blank when a new row is added?
@@ShanesCows Thanks - my dropdowns are set to the field name in the collection, otherwise they wipe out whatever value I put in there when I'm editing..so for example in my Collection I have a field called CDropdownStatus that has options of Blank, 'Edited', 'Extra'. My default is set to CDropdownStatus. The OnChange value is set to patch that field into the collection. If I move to the next row, my dropdown field CDropdownStatus in line 2 will autopopulate with whatever I had in the first line. If, instead, I change the default to be blank (which is a possible selection) then when I select the value in line 1 for Status and move off that field when the OnChange runs for the next field (still in line 1) it resets my selection to Blank...
Hello Shane, I have question in my mind, let me know is it possible, I want to do bulk edit like in a grid format, Suppose I have a gallery1 having checkboxes on them. Once I click on number of checkbox on gallery1 those items(all selected one) should get copied into new gallery or something grid and I want to bulk edit or create new records on those copied items. Is it Possible? as I have searched all videos showing 1 edit at a time. I want to mask edit . Please help me out, with some solution or alternate solution. Many thanks
Problem when I get to adding the Form on the view screen. After the blank form is added, I have to connect to a data source, but none of my data sources are connected here. When I click on the drop down arrow to select the correct one, Powerapps is showing "undefinedundefinedundefined" where they should be. So, I click 'connect to data' and add a new data source. Now I have duplicate data sources because the new one has a suffix of _1 at the end. Any idea why this form would fail to find the data source even though other screens, galleries, etc. can see it? I assume that connecting to this data source twice will slow things down.
Hi Shane thank you for this video! I want to create a edit screen which looks exactly the same the New item screen: I did a gallery at my start screen connected to my Masterlist which shows all available titles: OnSelect property: Navigate('Screen edit and view work package';ScreenTransition.Cover) On my Edit screen I got a edit form as you said connected to my Masterlist: Item property: LookUp('3400 ILLU Arbeitspakete Mastersheet';ID='Gallery Auswahl Arbeitspaket'.Selected.ID) Default property: Edit To submit my changes I got a simple button: SubmitForm('Form Arbeitspaket bearbeiten') I added a gallery collected to my Items List below my form: Item property: Filter('3400 ILLU Arbeitspakete Items';MasterID='Gallery Auswahl Arbeitspaket'.Selected.ID) At first it only showed me the title of my items but I inserted the rest of my items list: ThisItem.'Auswahl Tätigkeit/Bezug'.Value, ThisItem.'Prio'.Value, ThisItem.’Abteilung’,…... So they are not named ThisItem.Linexxx.... And my gallery shows me all my items belonging to my work package. I only got some issues with my save button after every row. What is the function for this?
Hello Shane, I have followed exactly your steps but failed at this filter (Filter(Product_requisition_details, MasterID = MasterGallery.Selected.ID)) --> system said invalid argument type. Could you please help ?
I am having a problem updating the total expense. I am using the patch formula as you wrote it(expect for my datasource and total name are different), but it is not changing the total. I have also noticed that when I try to edit an expense item again the number in the label I added to the card in the form goes back to the original total. Is that a clue to my issue? The error I get is that the object must implement IConvertible. Here is my formula - Patch(Expenses,MasterGallery.Selected,{Total:expenseChange})
I mae the patch show it as a value, and I am not getting an error. But it is still behaving the same way as I mentioned above. the label is reverting back to what it was before I made any edits and the total is not updating.
Work through it again. You must have missed a step. You can always download a working version of the app by signing up here training.powerapps911.com/courses/video-library
I am making an restaurant app..whenever I m trying to select menu items and trying to add that item its selecting same item in each row instead of selecting one item at a time..its updating all previous items in row,...so what should be done now??
Hi I have one doubt how can i update multiple item in SharePoint for example i need to assign multiple item to a employee using power apps how can i achieve it please help me
Hey Shane, can I ask how would you pre-fill a input field with the users displayname that is using the app. This input field is a person or group column in SharePoint. Thank you
You can do this with a combination of the User function(?) and the Office 365 Users connection (with the "GetMyProfile" function). See th-cam.com/video/FpXrF5NDZbI/w-d-xo.html (EDIT: I'm not sure that Shane specifically shows how to do what you're asking about in that video, but what's there should get you close).
Thanks Shane. I would have never thought of using galleries in that way. Great teaching!
It is still one of my favorite tricks. 😂
You showed a bunch of concepts in this solution including cascading galleries, contextual variables, adding custom card, mathematical formulas etc. Thanks again for sharing and helping the community!!
You are welcome!
Such a helpful tutorial. Had a Solutions Architect sell this and I thought we were out of luck! Fortunately, you were here to guide me through!
Glad you got it.
Man, I have no words to tell you how useful this video was for me. Thousand thanks!!!
Shane, You are very detail oriented and you do a great job in explaining complex issue into a very simple form. Thanks again for all your videos.
Glad to help. 😀
Great series on the repeating tables Shane!! Just what i was looking for, thank you so much.
Glad to help. 😎
Shane, this is amazing!!!
This one from Egypt :).
I saw the first one too. This is a great job done.
You actually inspired me to redo my an entire powerapp application build for inventory management.
Again this is Job well done.
Awesome. Be sure to send me some screenshots when you finish it. I would love to see the final product. :)
Another great example and pretty easy to follow. Thanks
I always learn something when I watch your videos. It never occurred to me that you could put a formula in the Patch statement for the Delete button! But now I know. Keep doing great videos. Appreciate how you explain things, too.
Thanks for all your work your videos have helped me so much on the road to learning PowerApps.
You are welcome 🙏
Shane, thank you, great video, very helpful!
My pleasure!
Nice, I paused your video to steal the great ideas for my current project..
That is perfect! That is what I want. :) Even better can you share details or screenshots on your project? Love to see what people are building. :)
Hi Shane,
Here you have shown like editing the existing expense details values, how can we add a new expense detail using edit form. Please let us know, i was stuck on this from a week
Thank you
You would need to make a new button that shows the form and puts it in new mode. Then you could piece things back together.
@20:43 - When i hit save it seems to take ages to refresh and update the value for me.
I'm using an excel database, and it updates the data in the excel instantly, however the page takes 20 - 40 seconds to update the value. refreshing the database, or leaving the page entirely and coming back doesn't speed this up.
Any ideas?
Don’t use Excel. 😎 QTT - Power Apps Excel is a terrible data source
th-cam.com/video/RtmZM3tm2Zs/w-d-xo.html Other than that you could use Monitor to see where the formula is hanging up but I think it is just due to Excel being not ideal.
Thanks one again. My question is how do you perform the sum when you have so many lines that could be edited and some fields are calculated fields based on other fields
Thanks Shane. Really insightful video and of great help. Quick question. What would you tweak to ensure that you could add a new expense on the editing screen. Your help would be appreciated.
Need to setup the collection again with the already created items.
So good. You are a trooper!
Thank you! I am hopeful by the summer I will redo this series. 😎
Hi Shane, thanks a lot for this video. Welldone!
Thanks 😊
Hi Shane, the edit functionality was very useful for the child, I have a senecio where from the gallery I need to edit parent and child together on another screen, but at the same time child is shown only base on a particular drop down value. If the drop down is something else then edit main list. How do I resolve that??
Hi Shane,
I learned a lot from your video, I really appreciated what you have done
Glad to help. 😀
Thank you Shane, this is a great video and so informative. Is there any way to add the "Comment" section to a PowerApp so the user can add comment and track conversion?
Yes. Try the method discussed in this video. th-cam.com/video/dre1E9GiDJM/w-d-xo.html
@@ShanesCows Thank you
This is my all time favorit video Shane. But is it possible to add extra rows when you edit the data? Not just edit the data that is already there?
Yes, Frank. What you would need to do is setup a collection like we did on the other screen. And then track that a row was "New" via a column. Then if Column is New ForALl to create the new rows. Several people ahve asked about this. I need to make a video on it. 😀
@@ShanesCows that would be so awesome!!
I have used this several times now and it's amazing. I do have one quick question, is there a way to sort that gallery so the blank row stays at the top of the list rather than at the bottom? I have a scenario where there could be a large number of items added at one time with the requirement that individual items could be added after and having the 'new item' row at the top would be great.
Maybe add a column that has an order number then sort descending by that column
Shane, Great video! A question on collections - Is there a way a new row can be inserted between two existing rows? A customer has a request to be able to insert a row in between.
You would have to create a column to track row numbers and then make logic to manipulate it all.
It is great how you solve these problems, I am extremely impressed. Thanks for the video !
I did everything exactly with what you taught and I feel that my application was slow, how can I solve it? have any tips?
If the amount of data is massive then SharePoint gets slow. Moving to a faster datasource, like SQL or Dataverse is probably the best answer. But without more details of slow hard to say.
Hi Shane, thanks for the video, 6 years old and still going strong! I've followed closely and had success replicating but now wondering how I would go about filtering the data so a user can only see/edit the reports that they have submitted. Can you point me in the right direction?
I think this old video will help th-cam.com/video/-VaADTTPYmg/w-d-xo.html Crazy how old some of these videos are getting 🤣
@@ShanesCows Legend! Two more questions if I may -
1 - The SubmitForm on the Save button for my app is not saving all data back to my SP list. Its saving Title (Single Line Text), Date (DatePicker), Total Expense (Text) and a column that I added (Person/Group) but not the Expense Type (Choice).
I have tried the Patch() option and this also did not work.
2 - I think you may have answered this on another video but for the life of me I can't find it - if the user clicks the delete button (which removes the option to create a new line) but then decides they want to add a new line - what's the best way of doing this?
Thank you.
Hi Shane. The video was very helpful. I was wondering if there is a way for the edit form to go away once you select save. As of now, whenever I select to edit the gallery and save the changes, the edit form stays on the screen whenever I choose another item in the Master Gallery to view. Is there a way to make the edit form not show when selecting another item, other than returning to the home screen and re-opening the View Screen? Thanks.
You would have to write logic to control the state with a variable.
Great video - super helpful. Any insight on how to enable a user to add an item to the expense report when they are on the View/Edit screen? i.e. The user is reviewing their expense report and realized they forgot an expense and want to add it in. How does that get added in?
You could have a form that has the master I’d already set. All of the pieces are here. You got it. 😀
Thanks a ton. you saved my day!!!
Sorry I am behind on comments. Glad you got it!
Hello Shane! Great video(s) on PowerApps Repeating Tables ... Question on all the items that are hidden (Forms, Buttons, etc...) .... When in the PowerApps create tool, is there a mode/method/way to know or see items that are hidden on the screen(s) if the items happen to be hidden at the time? If an app is inherited from someone else, how would it be known that a screen contains a hidden gallery, form, button(s), and the placement of those items, just by looking at the screen? Thanx!
You can look on the left and that shows all controls, hidden or not.
great video Shane. If i dont use ID and Master ID then how can i filter the gallery
You need to find a column that is unique
Shane, Fantastic! Can you explain how I can Search the "MasterID Gallery" and filter down the "ID" gallery? Example: Have customer info in "ID gallery" and Unit cost and part number in repeating "MasterID Gallery". (SharePoint). How do I search for specific part number in the repeating row gallery and filter the main ID gallery........Wow that was long winded. I hope you get the gist of what I'm asking.
Thanks Again!!!
You can wrap your Filter function I showed in the video with a Search. So Search(Filter(whatever we did here), textinput1.text, "COlumnToSearch")
@@ShanesCows Thanks! You can actually make this app building enjoyable. Appreciate your skills!
this is amazing. it worked for me. although i would like to know one more thing; How can we show data from multiple sharepoint lists to a single stand alone pa form with the details grouped by a single common column?
Hi Shane.. Appreciate your efforts very helpful. How do I add a new Item to the existing Expense Details Gallery and update the Master Gallery and reflect the same in SharePoint Lists.
Patch and make sure you include the masterID
@@ShanesCows Thanks... Did that and it worked..
@@rupammishra8775 Could you share how you solved this? I cant figure this out. Are you connecting to the collection of the data? Did you add to the form or the gallery? If you could share your code I would appreciate it !
Shane thank you so much for your video, I have a query here once I edit if I need to add more line Items, how will I do it?
Add a button that creates a new blank row. It is the same logic that is at the end of the Save button.
it is always goo to be here... this ItemCost is the selected row of the child gallery?
Not sure what you are asking. Sorry
Hey Shane, great video. I followed your instructions but when I create a few records in the collection, the patch function patches the wrong record when I click the save icon, it's as if ThisItem references a different item from the one selected. I've used galleries many times but this one is a bit more dynamic than the ones I have used in the past. I wonder if this is a bug in Powerapps?
Gordon.
I have done a lot like this and never seen this behavior. I would look harder at the collection. Maybe you have duplicate data? Not sure 🤔
HI Shane. I've followed the video in part 2 and have the expenses View and Edit working, however on the section whereby I have added the Card and Label field in order to do the calculation e.g. MasterGallery.Selected.TotalExpense - Item Cost + ExpenseCard, this does not work for me. The first step in the above works, and I get the TotalExpense value back in the field, but the rest does not work when I select the - Item Cost in the string the field goes blank and I get a red x circle in the corner. I have checked this by going back through this video in fine detail to ensure I am following this exactly but every time I try I do not get the results you do in the video. My fields are the same and I have changed the same field names as you do in the video, but this part just does not work for me and means I cannot update the Sharepoint list with any changes applied at the item cost level. Can you tell me how to overcome this please. Thanks Stuart
hi there Stuartlester9052, Did you ever find the issue that helped you get over this hurdle? I feel i'm in the same spot
Hi! You have to add .Text to the end of ExpenseCard. For Example: ExpenseCard.Text. That fixed the problem for me.
Thanks for the video but I have a questions.
Is there any reason why you used Submit(Form2) to update ExpenseDetail instead of Patch(ExpenseDetails)?
Just what works beat in this scenario
It is great how you solve these problems. Thanks for the video ! I have one question, I followed all your step but didn't understand why do I need to double-click on Save Button to Save, Is there a solution to the problem?
Another fantastic, well-articulated/thought out video. Just to play devil's advocate, what if the user goes directly to the Expense details list in sharepoint, and adds an item with a completely random MasterID? Is there a way to stop users from doing this and only create new records from this app?
I think ideally you would use a different data source like SQL. 😀
Very groovy! So, one question. Is there a way to highlight (change the background color) of the items selected in the different gallery views so you know which ones are selected/displayed when opening up a "child" gallery?
Yes. It is something like. TemplateFill = if(thisitem.selected, red, green). Probably not exact but close. Let me know if you cant get it.
Will do. I'm just getting started with PA - I've been using Infopath for a while and am currently just getting the feel of this - I've only piddled around with it so far, but planning on really digging in this week. Your videos are really helpful - many thanks for putting these together!
You are welcome
@@ShanesCows If(ThisItem.IsSelected,Red,Green)
And big thanks for all of these tutorials!! I'm actually moving from an MS Access world, looking for web-based front ends, and am hopeful that PA can do that job.
Hi Shane,
Thank you for this wonderful video. Could you please advise for this error message ' Delegation Error. The 'Filter' part of this formula might not work correctly on large data sets.' on Expense Details gallery while filtering from Master Gallery as a result I can't see any Expense Detail for further edit.
Delegation is a tricky one. Something in your formula is causing it. Have you tried checking the documentation?
Yes, I went through it. I modified a bit in my formula to get the result. Thanks Shane once again.
Hey Shane, wonderful videos..happy learning!!
Can we use PowerApps to break SP list item permissions & set it after item is created / updated. This will mainly help in scenarios where we need to make it read only item once item is sent for approval etc.
I have not seen a way to change SharePoint permissions. Have you looked at SharePoint approvals though? They kind of work that way by default.
I always enjoy watching your videos and like the way you make it so simple for the complex workaround. I do have a quick question on the repeating section you developed. You did create child records from the collection with multiple rows in the Expensedetails list. what would be the case if I delete a repeating section from the form and I still see the record in the child list. Can I delete that from power app or can you please help me how can we delete that. The issue is even though I delete a repeating section and submit the form to main list. View mode of that form is still getting me the record (repeating section) that I deleted. Any help or suggestion please? Thanks in advance!
Great video! Thanks for sharing!
Glad it helped.
Shane, thank you for posting all these and all your help! I have scoured the internet to no avail. I am wondering if there is a way to take something similar to what you have created in this video to an approval. I am trying to create an overtime approval app. I would be creating collections of employees for overtime, based one which day (Sat, Sun, Weekday) and sending multiple employees in those groups off to be approved. I am unsure how to get these groups all approved or rejected at the same time. Do you have any resources for solving this? THANK YOU.
I don’t have an easy answer. I would send the table of employees as an email to the approver and then make approvals in the app not using Flow. Look at deep linking video for how I would send the approval.
While this is much more complicated to set up than a Repeating Table in InfoPath, it's actually MUCH more useful. One question, though: For the "ExpenseDetails" gallery...could you throw that into a Collection (OnSelect for the ExpenseMaster Gallery would be "ClearCollect(ExpenseItems,Filter(ExpenseDetails, MasterID = ExpenseMaster.Selected.ID))") and then use the same SUM function as before against that Collection? Basically, pull the data into a local collection, do the calculations, then write it back out to SharePoint when done? I've been trying to use Collections more to avoid delegation issues and (hopefully) speed the apps up a bit by minimizing how much data they need to bring back with each call. I *think* this is one of the intended uses of Collections, but I'm not 100% sure.
Great question Chad. I messed with that a bit and it wasn’t working for me. The clearcollect function isn’t delegatable so same issue. If you find a work around let me know though.
I guess I don't follow how delegation applies to functions like collect and clear collect. As an example, I have an app where it reads from a list of time cycles (academic terms) and I want to return only the current one (where now() >= term start date and = start date and
To your original question. If you use Collect or ClearCollect against a SharePoint it will only get the first 500 items from the list. Technically, you can raise this limit to 2,000 but either way, there is a hard limit.
What I would recommend is you read this a couple of times to help. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview Delegation looms large in the SharePoint data source scenarios.
Yeah, I read that through a few times yesterday. It seems like the trick is going to be including fields/columns that can be used with Filter to guarantee that the Collect call is bringing back an allowable/acceptable number of results. The more complicated part is going to be explaining this to our users who hear the word "limit" and immediately start looking for another solution.
Shane, it's not the same exact scenario as yours, but I was able to answer the question I posed originally. Here's a short video showing what I mean (sorry, no audio...too noisy with the neighbors setting off fireworks): th-cam.com/video/oOqUJ45JamQ/w-d-xo.html. Basically, I have a gallery showing "compatible add-ons" for a particular device. Clicking the + adds the item to a collection, then there's a field that provides a sum of the selected items' costs. I was hoping the "repeating tables" thing would help me find a more coordinated way for the app "owners" to manage the data (adding/updating device choices and add-ons), but I've been spinning wheels on that for a few days. For now, they can just manage it in the lists in SharePoint.
In Video 2: Show search reports and edit details (and delete line items). How could you get the collect function of video 1 to add an expense (in Video 2) when the expense details gallery is open? Thanks.
With trial and error figured out. Patch...Defaults...GalleryName.Selected.Fields. Good stuff.
Glad you got it 🐶
Hi Shane,
Firstly this videos help me a lot to achieve the repeating functionality using powerapps.
I would like to ask you to make a video of view and edit in the same way you did for New item, i mean can we add the form and gallery for view and edit and do the things over there , i was trying out , but facing difficulty in edit form
I just added a form and under that i have added the gallery for edit form, i facing issue in how to save them into the SharePoint list, as this is an update to existing item.
If you could make a video on this, it would be really a great help for me, i was struggling for this from past 3 days and could not achieve it
Thanks
Noted. Thanks for the suggestion.
Hi Shane, is it possible to create filter from multiple dropdown box with sortbycolumn from Gallery2?
SortByColumns(filter(... should work.
Shane Young my gallery2 is in a new screen and I tried to add in multiple Dropdown box but the gallery doesn’t filter. Tried to create collection and it didn’t work too
Thanks for sharing valuable content. But I can't see the edit function in Repeat gallery (Pencil). Could you please add that one also. I need it...
Sorry. What do you mean add?
@@ShanesCows i got it in inline edit control . Part 3 vedio thank you
Hi Shane, Thanks for your tutorials, it's amazing and very informative. I am new to powerapps and creating a repeated section. I was able to create new line and save that to sharepoint list. The problem i face is that, when i hit "Save" button to create new line, the new line appears, but the previous line, text inputs disappears. It's available in the collection, but not visible in the form. Really not sure what's am i missing.
Unrelated to my other comment about the data source issue, but I have another question. All of this is based on creating an App from the PowerApps studio.... how would this be different if you were to use the SharePointIntegration where you click 'Customize Form' under the PowerApps button in a SharePoint list? Most of the forms I've created in the past use this as a launching point. For many users, it's easier to view the data in a list format opposed to a gallery. When you create an app via the SharePointIntegration method, you get new properties such as: OnNew, OnEdit, OnView. Would I need to create an Add New Form, Edit Existing Form, and View Only form for each possible option?
I think you could do it. Haven't tried but I don't see any reason you couldn't do it.
Is it possible to make the Total Expense and Expense Cost values show up in currency format?
Yes , use the Text function. PowerApps Text function to format currency and numbers
th-cam.com/video/OXGWnsxuyzM/w-d-xo.html
Hi @Shane! Thanks once more for such great content! Please, I need and Add Button in this form so we can add new expenses. Can you give me some guide ones about it? Tx
I think part 1 covers the add button? If not use the code from the second half of the save button. It creates a blank row and that is what you want the add button to do
Were you able to solve this? Could you share your solution?
Hi Shane - You can teach us to make a module of Inventory management with Receipt, Dispatch and Inventory. It will be very much helpful
I am working on a customer app to do that now. Not sure that will make a video.
@@ShanesCows it will be great if u can teach that and post a sample video... Thanks in advance...
Is flow run the attachment to the Id and the Master ID ?
No flow required
Hi Shane, how can I get the master data from the Details Data in the SharePoint lists ??
Hey, I was able to reverse the logic you used and it returned the values I needed
Awesome
Hi Shane, I am facing an issue. People picker combo box in repeating section is not retaining values in edit form. Can you please help me to achieve this?
That problem is almost always because you are not setting DefaultSelectedItems correctly. It should be something like ThisItem.Peoplefield This video may help th-cam.com/video/AXAbmy9zYTU/w-d-xo.html
Shane I need an assistance, I see that there is no attachment control for both master and slave date in your video, I have it but I am not sure how to add attachment control inside my slave Gallery at the time when the item is being created, can you please help me with that.
Towards the end of the Video once you Delete don't you have to hit the save button so that the changes are updated in the sharepoint. Or doesn't need to hit the Save Button (Auto Save)
I believe I built the delete to Remove() directly from SharePoint.
Hello Shane!! Thanks a lot for your videos! They are great! I'm from Portugal and I have been showing then to colleagues and friends here and all over Europe!!
Now I have a challenge for you: when using a DatePicker in my apps it gives me a nice date in my excel DB. Problem: some of my apps users have browsers in different languages. So when reading those dates they have creasy values. All dates are written in English. Can you make a video how to fix it?! :p
Thanks. 😀. I haven’t done a lot with dates in Excel for international. Wha type might try is storing the date as text and then use the PowerApps functions to convert it to a properly formatted date in the app.
How would you embed this view/edit feature inside a data card in a Form linked to the main SharePoint List?
Hi Shane,
In collection don't have any data when first time user come so how can I show the table?
Whenever I create table columns not display on run time.
Please help me out this.
In the video I show you how to make a blank line in the collection
Shane, another great video. Quick Question. Do you know when or if Microsoft will be adding formatting options to Text-Input so it will show as Currency or % in the input box? Or maybe I'm just missing the correct field I should be modifying.
Thanks Rob. Are you asking that you want when a user is typing in the data you want it to show as currency? Or when you are displaying it you want to show as currency?
can we add attachments in repeating sections
Yes, I have done it before using a version of this th-cam.com/video/3QaiM8SeWfM/w-d-xo.html
@@ShanesCows thanks! I need to add multiple lineitems against a parent line item . each child item needs to have an attachment , do you have any videos for this
Hi Shane
Great video as always. Would there be a way to insert a picture of the expense receipt from a smartphone?
He covered that in another video back in May: th-cam.com/video/ovLIwnj6QjU/w-d-xo.html
Thanks Chad. 👍
Thanks Chad. I didn't see this one :-)
I am trying a similar repeating table but it is for the same list. Trying to save the repeating table value to a multiline string as it does in SharePoint. My problem is I am not able to load back it in the edit form or display form. I can enter the values they get stored in the string column but how to reload them from the string. How to load the gallery if the string is not null else leave it like a new gallery.
Use split to turn a string back to a table
Hi! I have a repeating table (gallery) and it is working fine except that when I add a new row the fields that are dropdowns copy the value of the previous (first) row. How can I make them blank when a new row is added?
Set the default values of the fields when you create the blank row
@@ShanesCows Thanks - my dropdowns are set to the field name in the collection, otherwise they wipe out whatever value I put in there when I'm editing..so for example in my Collection I have a field called CDropdownStatus that has options of Blank, 'Edited', 'Extra'. My default is set to CDropdownStatus. The OnChange value is set to patch that field into the collection. If I move to the next row, my dropdown field CDropdownStatus in line 2 will autopopulate with whatever I had in the first line.
If, instead, I change the default to be blank (which is a possible selection) then when I select the value in line 1 for Status and move off that field when the OnChange runs for the next field (still in line 1) it resets my selection to Blank...
Hello Shane, I have question in my mind, let me know is it possible, I want to do bulk edit like in a grid format, Suppose I have a gallery1 having checkboxes on them. Once I click on number of checkbox on gallery1 those items(all selected one) should get copied into new gallery or something grid and I want to bulk edit or create new records on those copied items. Is it Possible? as I have searched all videos showing 1 edit at a time. I want to mask edit . Please help me out, with some solution or alternate solution. Many thanks
Shall we do this with only one sharepoint list ?
I don’t think so.
Problem when I get to adding the Form on the view screen. After the blank form is added, I have to connect to a data source, but none of my data sources are connected here. When I click on the drop down arrow to select the correct one, Powerapps is showing "undefinedundefinedundefined" where they should be. So, I click 'connect to data' and add a new data source. Now I have duplicate data sources because the new one has a suffix of _1 at the end. Any idea why this form would fail to find the data source even though other screens, galleries, etc. can see it? I assume that connecting to this data source twice will slow things down.
Hi Shane thank you for this video! I want to create a edit screen which looks exactly the same the New item screen:
I did a gallery at my start screen connected to my Masterlist which shows all available titles:
OnSelect property:
Navigate('Screen edit and view work package';ScreenTransition.Cover)
On my Edit screen I got a edit form as you said connected to my Masterlist:
Item property:
LookUp('3400 ILLU Arbeitspakete Mastersheet';ID='Gallery Auswahl Arbeitspaket'.Selected.ID)
Default property: Edit
To submit my changes I got a simple button: SubmitForm('Form Arbeitspaket bearbeiten')
I added a gallery collected to my Items List below my form:
Item property: Filter('3400 ILLU Arbeitspakete Items';MasterID='Gallery Auswahl Arbeitspaket'.Selected.ID)
At first it only showed me the title of my items but I inserted the rest of my items list: ThisItem.'Auswahl Tätigkeit/Bezug'.Value, ThisItem.'Prio'.Value, ThisItem.’Abteilung’,…...
So they are not named ThisItem.Linexxx....
And my gallery shows me all my items belonging to my work package.
I only got some issues with my save button after every row. What is the function for this?
You will need to patch your changes for every row. Part 3 talks about it more.
Hello Shane,
I have followed exactly your steps but failed at this filter (Filter(Product_requisition_details, MasterID = MasterGallery.Selected.ID)) --> system said invalid argument type. Could you please help ?
YOu should only have one filter not two I think
I am having a problem updating the total expense. I am using the patch formula as you wrote it(expect for my datasource and total name are different), but it is not changing the total. I have also noticed that when I try to edit an expense item again the number in the label I added to the card in the form goes back to the original total. Is that a clue to my issue? The error I get is that the object must implement IConvertible. Here is my formula - Patch(Expenses,MasterGallery.Selected,{Total:expenseChange})
I mae the patch show it as a value, and I am not getting an error. But it is still behaving the same way as I mentioned above. the label is reverting back to what it was before I made any edits and the total is not updating.
Sorry Mark not sure.
Shane My MasterID column is not working i followed the exact steps of your video but is is not picking up the value from powerapps. Please Help Asap.
Work through it again. You must have missed a step. You can always download a working version of the app by signing up here training.powerapps911.com/courses/video-library
I am making an restaurant app..whenever I m trying to select menu items and trying to add that item its selecting same item in each row instead of selecting one item at a time..its updating all previous items in row,...so what should be done now??
Check your save or on change code again. You missed something that is causing this.
@@ShanesCows Sir i m trying to generate bill so can u plz tell me about any ref. video regarding invoicing and inventory mgmt in powerapps
Hi I have one doubt how can i update multiple item in SharePoint for example i need to assign multiple item to a employee using power apps how can i achieve it please help me
What have you tried?
I was trying by customizing the list in power apps but when we select mutiple item edit option we are not able to edit it can you please help
Hey Shane, can I ask how would you pre-fill a input field with the users displayname that is using the app. This input field is a person or group column in SharePoint. Thank you
You can do this with a combination of the User function(?) and the Office 365 Users connection (with the "GetMyProfile" function). See th-cam.com/video/FpXrF5NDZbI/w-d-xo.html (EDIT: I'm not sure that Shane specifically shows how to do what you're asking about in that video, but what's there should get you close).
Dude! Chad you are crushing it. Thanks again.
Shane, just trying to repay a bit for all the help I've gotten from your videos.
Celebrating Form2's success