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!!
@ShanesCows6 жыл бұрын
You are welcome!
@BriJ195 жыл бұрын
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!
@ShanesCows5 жыл бұрын
Glad you got it.
@philippseis68939 ай бұрын
Thanks Shane. I would have never thought of using galleries in that way. Great teaching!
@ShanesCows9 ай бұрын
It is still one of my favorite tricks. 😂
@tonyocnos66913 жыл бұрын
Man, I have no words to tell you how useful this video was for me. Thousand thanks!!!
@ashvinpatel57465 жыл бұрын
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.
@ShanesCows5 жыл бұрын
Glad to help. 😀
@mwmstals3 жыл бұрын
Great series on the repeating tables Shane!! Just what i was looking for, thank you so much.
@ShanesCows3 жыл бұрын
Glad to help. 😎
@fadysharobeem6 жыл бұрын
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.
@ShanesCows6 жыл бұрын
Awesome. Be sure to send me some screenshots when you finish it. I would love to see the final product. :)
@stuartlester90522 жыл бұрын
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
@CloudyDangle5 ай бұрын
hi there Stuartlester9052, Did you ever find the issue that helped you get over this hurdle? I feel i'm in the same spot
@RuthOHale24 күн бұрын
Hi! You have to add .Text to the end of ExpenseCard. For Example: ExpenseCard.Text. That fixed the problem for me.
@kimsalas81976 жыл бұрын
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.
@michaelcampbell6721 Жыл бұрын
Another great example and pretty easy to follow. Thanks
@hchemas13 жыл бұрын
Shane, thank you, great video, very helpful!
@ShanesCows3 жыл бұрын
My pleasure!
@adebayoogunmoriyele54973 жыл бұрын
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
@smaug30454 жыл бұрын
Thanks for all your work your videos have helped me so much on the road to learning PowerApps.
@ShanesCows4 жыл бұрын
You are welcome 🙏
@shraddhapatel93545 жыл бұрын
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??
@fklatecki6 жыл бұрын
Nice, I paused your video to steal the great ideas for my current project..
@ShanesCows6 жыл бұрын
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. :)
@peteorrell47607 күн бұрын
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?
@ShanesCows7 күн бұрын
I think this old video will help kzbin.info/www/bejne/Y4fEcneKibWMo8k Crazy how old some of these videos are getting 🤣
@peteorrell47603 күн бұрын
@@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.
@nqobamanana7253 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Need to setup the collection again with the already created items.
@powerappstw4 жыл бұрын
Hi Shane, I learned a lot from your video, I really appreciated what you have done
@ShanesCows4 жыл бұрын
Glad to help. 😀
@bhanuprakash14164 жыл бұрын
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
@ShanesCows4 жыл бұрын
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.
@istvansomogyvari92375 жыл бұрын
Hi Shane, thanks a lot for this video. Welldone!
@ShanesCows5 жыл бұрын
Thanks 😊
@adamengleking93894 жыл бұрын
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.
@ShanesCows4 жыл бұрын
You would have to write logic to control the state with a variable.
@altino912552683 жыл бұрын
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?
@ShanesCows3 жыл бұрын
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.
@julireid95744 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Maybe add a column that has an order number then sort descending by that column
@ghfs06513 жыл бұрын
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?
@pggg50014 жыл бұрын
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)?
@ShanesCows4 жыл бұрын
Just what works beat in this scenario
@saml97582 жыл бұрын
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?
@ShanesCows2 жыл бұрын
Yes. Try the method discussed in this video. kzbin.info/www/bejne/mqPIYnhvfM53gK8
@saml97582 жыл бұрын
@@ShanesCows Thank you
@gordonmennie47454 жыл бұрын
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.
@ShanesCows4 жыл бұрын
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 🤔
@jlh21195 жыл бұрын
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!
@ShanesCows5 жыл бұрын
You can look on the left and that shows all controls, hidden or not.
@appbuilder75763 жыл бұрын
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.
@ShanesCows3 жыл бұрын
You would have to create a column to track row numbers and then make logic to manipulate it all.
@pallavijha85633 жыл бұрын
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?
@stacybroermann5 жыл бұрын
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?
@ShanesCows5 жыл бұрын
You could have a form that has the master I’d already set. All of the pieces are here. You got it. 😀
@thirumaleshm21372 жыл бұрын
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!
@uppalluruanusha47942 жыл бұрын
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?
@ShanesCows2 жыл бұрын
That problem is almost always because you are not setting DefaultSelectedItems correctly. It should be something like ThisItem.Peoplefield This video may help kzbin.info/www/bejne/d4mkk6Cvbt-Mirc
@manojpai19884 ай бұрын
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.
@franknielsen32193 жыл бұрын
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?
@ShanesCows3 жыл бұрын
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. 😀
@franknielsen32193 жыл бұрын
@@ShanesCows that would be so awesome!!
@manojpai19884 ай бұрын
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?
@ShanesCows4 ай бұрын
Add a button that creates a new blank row. It is the same logic that is at the end of the Save button.
@marioramos53845 жыл бұрын
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?
@ShanesCows5 жыл бұрын
I think ideally you would use a different data source like SQL. 😀
@sasidasari26765 жыл бұрын
great video Shane. If i dont use ID and Master ID then how can i filter the gallery
@ShanesCows5 жыл бұрын
You need to find a column that is unique
@manishshasank45153 жыл бұрын
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
@rupammishra87754 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Patch and make sure you include the masterID
@rupammishra87754 жыл бұрын
@@ShanesCows Thanks... Did that and it worked..
@raeannepearson22893 жыл бұрын
@@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 !
@ValerieLJones-ou6xl8 ай бұрын
Is it possible to make the Total Expense and Expense Cost values show up in currency format?
@ShanesCows7 ай бұрын
Yes , use the Text function. PowerApps Text function to format currency and numbers kzbin.info/www/bejne/hYmqiKGprdqssK8
@vaibhavipatel93675 жыл бұрын
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.
@ShanesCows5 жыл бұрын
Delegation is a tricky one. Something in your formula is causing it. Have you tried checking the documentation?
@vaibhavipatel93675 жыл бұрын
Yes, I went through it. I modified a bit in my formula to get the result. Thanks Shane once again.
@MO-ci6wh4 жыл бұрын
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.
@ShanesCows4 жыл бұрын
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.
@meenakshiuniyal3965 жыл бұрын
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.
@ShanesCows5 жыл бұрын
In the video I show you how to make a blank line in the collection
@catgentry5 жыл бұрын
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?
@ShanesCows5 жыл бұрын
I think you could do it. Haven't tried but I don't see any reason you couldn't do it.
@omaiyorubagamjanakyraman74804 жыл бұрын
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.
@Nehalpanchamia074 жыл бұрын
Thanks a ton. you saved my day!!!
@ShanesCows4 жыл бұрын
Sorry I am behind on comments. Glad you got it!
@mplogue6 жыл бұрын
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?
@ShanesCows6 жыл бұрын
Yes. It is something like. TemplateFill = if(thisitem.selected, red, green). Probably not exact but close. Let me know if you cant get it.
@mplogue6 жыл бұрын
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!
@ShanesCows6 жыл бұрын
You are welcome
@mapplenova3 жыл бұрын
@@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.
@thanghuu8873 жыл бұрын
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 ?
@ShanesCows3 жыл бұрын
YOu should only have one filter not two I think
@AmitIngle6 жыл бұрын
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.
@ShanesCows6 жыл бұрын
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.
@yukict114 жыл бұрын
Hi Shane, is it possible to create filter from multiple dropdown box with sortbycolumn from Gallery2?
@ShanesCows4 жыл бұрын
SortByColumns(filter(... should work.
@yukict114 жыл бұрын
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
@StephensonEagles4 жыл бұрын
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!!!
@ShanesCows4 жыл бұрын
You can wrap your Filter function I showed in the video with a Search. So Search(Filter(whatever we did here), textinput1.text, "COlumnToSearch")
@StephensonEagles4 жыл бұрын
@@ShanesCows Thanks! You can actually make this app building enjoyable. Appreciate your skills!
@leopold99992 жыл бұрын
@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?
@ShanesCows2 жыл бұрын
Don’t use Excel. 😎 QTT - Power Apps Excel is a terrible data source kzbin.info/www/bejne/iKXQi4BpqdJlkNU 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.
@markhannah35734 жыл бұрын
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})
@markhannah35734 жыл бұрын
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.
@ShanesCows4 жыл бұрын
Sorry Mark not sure.
@catgentry5 жыл бұрын
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.
@DaleLombard-SilannaIT Жыл бұрын
How would you embed this view/edit feature inside a data card in a Form linked to the main SharePoint List?
@kreali755 жыл бұрын
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?
@ShanesCows5 жыл бұрын
Set the default values of the fields when you create the blank row
@kreali755 жыл бұрын
@@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...
@J7d-tm2iy6 ай бұрын
So good. You are a trooper!
@ShanesCows5 ай бұрын
Thank you! I am hopeful by the summer I will redo this series. 😎
@Kukdai3 жыл бұрын
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.
@ShanesCows3 жыл бұрын
Use split to turn a string back to a table
@radiosonicfan17264 жыл бұрын
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.
@radiosonicfan17264 жыл бұрын
With trial and error figured out. Patch...Defaults...GalleryName.Selected.Fields. Good stuff.
@ShanesCows4 жыл бұрын
Glad you got it 🐶
@ValyGreavu6 жыл бұрын
Great video! Thanks for sharing!
@ShanesCows6 жыл бұрын
Glad it helped.
@moizahmed75934 жыл бұрын
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.
@ShanesCows4 жыл бұрын
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
@robbertolozzi3936 жыл бұрын
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.
@ShanesCows6 жыл бұрын
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?
@ghuerren4 жыл бұрын
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
@ShanesCows4 жыл бұрын
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
@raeannepearson22893 жыл бұрын
Were you able to solve this? Could you share your solution?
@kanishkaroychowdhury40504 жыл бұрын
it is always goo to be here... this ItemCost is the selected row of the child gallery?
@ShanesCows4 жыл бұрын
Not sure what you are asking. Sorry
@bhanuprakash14164 жыл бұрын
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
@ShanesCows4 жыл бұрын
Noted. Thanks for the suggestion.
@macherlayesubabu83115 жыл бұрын
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...
@ShanesCows5 жыл бұрын
Sorry. What do you mean add?
@macherlayesubabu83115 жыл бұрын
@@ShanesCows i got it in inline edit control . Part 3 vedio thank you
@patricklemire79135 жыл бұрын
Is flow run the attachment to the Id and the Master ID ?
@ShanesCows5 жыл бұрын
No flow required
@rajug37295 жыл бұрын
Hi Shane - You can teach us to make a module of Inventory management with Receipt, Dispatch and Inventory. It will be very much helpful
@ShanesCows5 жыл бұрын
I am working on a customer app to do that now. Not sure that will make a video.
@rajug37295 жыл бұрын
@@ShanesCows it will be great if u can teach that and post a sample video... Thanks in advance...
@silasmangeni59765 жыл бұрын
Hi Shane, how can I get the master data from the Details Data in the SharePoint lists ??
@silasmangeni59765 жыл бұрын
Hey, I was able to reverse the logic you used and it returned the values I needed
@ShanesCows5 жыл бұрын
Awesome
@minishrivastav39495 жыл бұрын
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??
@ShanesCows5 жыл бұрын
Check your save or on change code again. You missed something that is causing this.
@minishrivastav39495 жыл бұрын
@@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
@emanuelpinto73946 жыл бұрын
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
@ShanesCows6 жыл бұрын
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.
@MrBijusammathew4 жыл бұрын
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)
@ShanesCows4 жыл бұрын
I believe I built the delete to Remove() directly from SharePoint.
@sasidasari26765 жыл бұрын
Shall we do this with only one sharepoint list ?
@ShanesCows5 жыл бұрын
I don’t think so.
@cvkealey6 жыл бұрын
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.
@ShanesCows6 жыл бұрын
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.
@cvkealey6 жыл бұрын
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
@ShanesCows6 жыл бұрын
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.
@cvkealey6 жыл бұрын
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.
@cvkealey6 жыл бұрын
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): kzbin.info/www/bejne/pYDUhn1qaq-Uo7M. 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.
@surajrevankar60623 жыл бұрын
can we add attachments in repeating sections
@ShanesCows3 жыл бұрын
Yes, I have done it before using a version of this kzbin.info/www/bejne/aYLEmoBuiMqKnK8
@surajrevankar60623 жыл бұрын
@@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
@geraldclerc62466 жыл бұрын
Hi Shane Great video as always. Would there be a way to insert a picture of the expense receipt from a smartphone?
@cvkealey6 жыл бұрын
He covered that in another video back in May: kzbin.info/www/bejne/paeveqqkn5uEoLc
@ShanesCows6 жыл бұрын
Thanks Chad. 👍
@geraldclerc62466 жыл бұрын
Thanks Chad. I didn't see this one :-)
@Eb_Games6 жыл бұрын
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
@cvkealey6 жыл бұрын
You can do this with a combination of the User function(?) and the Office 365 Users connection (with the "GetMyProfile" function). See kzbin.info/www/bejne/fKG7o3lrg6mNmKs (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).
@ShanesCows6 жыл бұрын
Dude! Chad you are crushing it. Thanks again.
@cvkealey6 жыл бұрын
Shane, just trying to repay a bit for all the help I've gotten from your videos.
@saanisirajulhaque3756 жыл бұрын
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
@ShanesCows6 жыл бұрын
What have you tried?
@saanisirajulhaque3756 жыл бұрын
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
@jasminschopfel22743 жыл бұрын
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?
@ShanesCows3 жыл бұрын
You will need to patch your changes for every row. Part 3 talks about it more.