I just started working with/using/developing PowerApps last week and found your videos. I am a previous developer of about 16 years but haven't programmed in over 10 years. You do a great job presenting the info quickly and applicably. Thank you!!!
I wanted to let you know how much you helped me!! I was able to change the entire process at my work, from excel spreadsheet to Sharepoint with PowerApps. Thank you so much Shane!!!!
You are fantastic! Best videos I have found to help me - we are gov't so really behind with our software and I am just learning PowerApps after being a SharePoint Admin for years. THANK YOU THANK YOU THANK YOU!!!
Was able to learn a lot from this video towards my own project for a job opening. Don't know if I'll be accepted, but at least my horizons are further opened now. Thanks, Shane!
I really appreciate your way of explaining things - very clear and concise. I am not used to working on a browser interface, and one trap I keep falling into is that when I'm in Preview mode, the browser Back button is just too juicy to ignore. Of course, after hitting it many of the previous changes are not saved...
That is awesome Paul. Good news I have one or two more to go even deeper with Forms. 😀 If you have specific nooks or crannies I should cover let me know.
The form that you had, was that brought in from MS Forms Pro (Preview)? Looking to make a form using power apps, that then has automation with power automate. I.e a custom Purchase Request Form, that once a form is submitted in power apps, the form goes to the relevant parties for approval.
Sorry for the delay. The video you saw didn't use MS Forms as the base, it was all Power Apps. THis video ruclips.net/video/49O284deOAI/видео.html talks about approvals like you want to do.
I really did not understand PowerApps until you explained it. I am still not an expert (not even close LOL) but at least I can create one that works. Thanks Shane
Hi Shane, good video. Quick question related to that video. I understand the Edit and View modes however if I"m in Edit mode, I edit some fields and afterward I click your button Cancel (change mode to View) what happen with the fields that I had changed? The fields will be reset to original values or not? Dave
Hi Shane, have you done any videos where you have an input form with a subform. Eg. a customer order which you input data from the order table and input data into an order details table in a subform
I don't believe that you can. You will need to edit the data outside the gallery or switch to a more complicated gallery. Something like this. ruclips.net/video/xgznk4XlPCo/видео.html
Hello Shane, great Video. My question is : Why are the changes made in 'Edit' or "New' mode are not reflected in a Excel sheet, which is used as a common data source. Do we have to go through some more steps to map the changes to the drive?
@@ShanesCows Thank you for the reply. I did figure it out. If excel is open when I make my changes from app, it throws an error. Please reply to my other question of work around for max limit of 2000 rows. It would solve a major issue. And no, I cannot have more than one data table/gallery.
HI Shane, I created a Form which Default Mode is View and I added the same buttons you did on this example, new, edit, save and reset, when I change the form to Edit Mode using the edit button I added everything works fine and I can change the content of the form but when I save it the form remains in Edit form, so I added an additional function to save button "SubmitForm(Form1) = ViewForm(Form1)" It works , saves the information and changes to FormMode View but I'm getting a Runtimeerror "The form you are trying to submit is in read-only (view) mode. Only editable forms can be submited. As I said it works but I do not know if this error could mean an issue in the short term. Thanks in advance for the guidance!
Hey Shane. Thanks for the video. It really helped with a project I'm working on at the moment. But quick question - once I've clicked the save button, my form is still in the 'edit/new' mode. I want to click save and have it return to the view mode once it has saved it ... can't work it out ... I've tried this: "submitform(form2);form2.mode = view" on my save button (on select) but that's not working. I've also tried a similar thing on the 'on success' message of the form but that's not working either... thanks!
Hey Shane, thank for the video and it does help me to understand PowerApps more and more everyday by following your video. Keep up the good job! Thanks!
Great to learn something new with the difference between Form Mode and Display Mode. I think in a few of my projects I have been using Display mode. Great stuff
Excellent video. Is it possible to keep the data inside the text and drop down fields after you submit? This would keep the end user from having to refill out the fields if they are needing to add just a few new details and submit a new entry to a Sharepoint list.
Hi Shane, I have enjoyed so many of your videos. I have spent 2 days on a problem and need solving. My primary table contains rows of data with ID numbers and names of other tables with the linking ID numbers. I'm using a form to display the data of the primary table but need to display some values from the other tables by using one of the fields from the primary table that has been selected. I have tried 'Search' and 'Filter' but cannot seem to get to the info. Can you help with this even if it is a video you can point me in the direction of. Please ask if you need further info.Thanks.
@@ShanesCows Hi Shane, thank you for your reply. I went through the part 2 video but it referenced two specific tables. Apologies as I had not explained it correctly. The Transaction table (Main Table) has a column that has company names for each table. When a transaction is selected it shows the company name in the gallery but in the details I want to call up the specific company (table) with it's details but cannot reference it until the transaction is selected. I hope this makes sense. Thanks again for your reply. I really enjoy your videos and humour.
@@ShanesCows I have managed to get it working using this formula: LookUp( Ladbrokes, TransID = Gallery1.Selected.TransID, Stake ) I have used the actual table name "Ladbrokes" but when I try and use this: LookUp( Gallery1.Selected.BackBookie, TransID = Gallery1.Selected.TransID, Stake ) It does not work. I have tried other variations but have run out of ideas. I hope this makes sense. Thanks Shane.
@@ShanesCows I have managed to find a workaround by using the Switch command which has worked. I would prefer a better solution but here is my solution with just a few of the bookies if it helps anyone. Switch(Gallery1.Selected.BackBookie,"Ladbrokes",LookUp(Ladbrokes,TransID = Gallery1.Selected.TransID, Stake), "Novibet",LookUp(Novibet,TransID = Gallery1.Selected.TransID, Stake), "Bet365T",LookUp(Bet365T,TransID = Gallery1.Selected.TransID, Stake), "Betfred",LookUp(Betfred,TransID = Gallery1.Selected.TransID, Stake), "Coral",LookUp(Coral,TransID = Gallery1.Selected.TransID, Stake), "Race Bets",LookUp(RaceBets,TransID = Gallery1.Selected.TransID, Stake), "A888Sport",LookUp(A888Sport,TransID = Gallery1.Selected.TransID, Stake) )
Hi Shane. Your videos save me so much and make me look awesome at work! I've got quick question though. With the "Submit / Save" button, what happens when you've got 2 forms on the screen, one that is being filled/edited and one that is pulling information from another list. Can the info from both forms be written back to the "parent" list which is the editable one?
You would have to submit both forms. Or maybe look at using Patch to write the data you want to the second list with the OnSuccess property of the form you are submitting.
Hi Shane, thanks for the video ! I've got a little issue ... when I swith to view mode I can't view the selected result contained in my form's Dropdowns or ComboBox
Try making the field/card wider. That can be a challenge with Multi-select fields. You may also need to add a label with Concat function to better display when in view. Sorry, no easy answer.
Thankyou for the information. Here you have achieved the functionality to change to mode by placing the buttons into the screen. I have placed my buttons inside the Form within the datacard. Now the same EditForm(SharePointForm1) function on Onselect is not working. Need your help on this.
@@ShanesCows Thank u . I have placed in the bottom of the screen for view mode . It's working now. I have another requirement, need to disable the past dates in the calendar picker.. need your suggestion please.
Hi, Love the videos thank you. Just started last week and am taking in a lot. I have an issue that I am using two forms and you mention this. I have a form with a data grid (not a gallery) as my menu from there I can select a record, open, edit and save, however if I create a new record, I can open my form and enter details, when I hit my save button the record saves and it goes back to the previously selected item from the data grid as the form source from the grid, any ideas I want it to hold the record I've just saved,
It is possible with a gallery by using a variable to tell it what row to highlight. Not sure about a data grid. Unfortunately I haven't done a video I can point to for help. Boo me.
Hi Shame, I enjoy your videos. I've encountered a problem while working on a customizing a PowerApps SharePoint List Form. Before I knew what I was doing (I still don't really) I removed some fields instead of making them not visible. Now I would like to use some of those fields but can't figure out how to get them back. Is there some way to do this that I am missing?
Thanks a lot for your videos. They help a lot. I have an issue and not sure if you can help me but I'm trying to create a form for a sharepoint list so anyone that needs to create a new iteam on it, can see the designed form made in powerapps but I added a submit button instead of using the save one on the top of sharepoint and does not work. I moved it out of the form per the suggestion you made but still I can't make it work.
Thank you for all of your videos. I have spent a ton of time creating a SharePoint Form to be used to edit SharePoint data. I would also like to create a similar Phone App based off of the same list. Is there a way to copy the Form view and create a Phone app using similar functionality to avoid creating the same app twice using two different form factors?
Hi Shane ! Great video as always! I have trying to create a form whose defaultmode is Edit, however the form loads only in the View Mode. I have a primary key column also in the table ( using Apache Impala connectors to connect to my table) Can you help me out
Hi@@ShanesCows ! Thanks for the reply. It seems that the Apache Impala(incubating) connector is the open source, native analytic database for Apache Hadoop. Connecting to your Impala database only reads data from tables. Thus we cant have a Edit Form because the connector doesn't support writing back to the database. Could you shed some light on this ? Impala connector official documentation - docs.microsoft.com/en-us/connectors/impala/
Hey Shane, can you direct me to the video you mention at the end of this one? The one about OnSuccess, OnFailure and OnReset. I haven't been able to find it
Hi, I am from India. Such a helpful Video. I am watching the entire series and its very helpful. One help please. What if I want to show a field only if it has value in it else want to hide it if has no value. Can you please tell me the OnVisible function for it ?
Hi Shane, your videos are really helpful. I am trying to create different forms for new/edit but I have a question what is a point of OnEdit, OnNew and OnView under SharePointIntergration. I wanted to add there for instance that OnEdit I get different form but it's not working. So there is no way to do this unless I add a button on my form?
Dear Shane, Thank you so such, really I gained a lot. By the by I am new to PowerApps. Initally I failed to view Excel table data in display form of PowerApps. When I select display form and mapped data source from OneDrive, it shows nothing. After adding the fileds from the data source, it shows only filed names. But when I select edit form it dispays all table data. Would pls suggest how may I view all data from a table.
Hi Shane, I have a question regarding the drop-down box and radio button in the custom form.The question is , the value which I select in radio button the same value should reflect in the drop-down box I am unable to fix it. Could you please guide me in it.
Hi Shane, thanks for this. I just have a new scenario. I save a new form data, all good. I want to edit a record, all good but here, I want the form to be auto populated which is happening but post making changes the record must be saved as new record in the SharePoint list and not update the existing. How to achieve this?
Awesome videos. Have 2 questions. Is it possible to turn a data card in the form to a drop down or one of the other controls?. I also have multiple screens that I want the data to connect to. I would like the name that is entered to auto fill in other screens, is that possible?
Yes and yes. I think in my SharePoint customize forms video I cover changing to a dropdown. Then on other screens you can reference the control that has the value. Watch the video on PowerApps variables for 2 different options.
Hi Shane! Thank you for your direct, clear, plain language explanations of how to do all things PowerApps! I do have a question about this process. So, I have an app with a Browse, Details and Edit screen, where an icon on Browse allows for the Edit screen to go into New Mode and an icon on the Details screen puts it in Edit Mode. The Add mode works fine - puts in my Hint text or blank fields. The Edit mode however does not show the contents from the Details screen, but the blank fields and/or Hint text! Now, I can play with the Default field of each card and make it display the actual contents of the field, but then that field doesn't show Hint text in New any longer. It's like I am not toggling correctly between content in New vs content in Edit. I probably broke it somehow but now cannot figure out how to fix it - I've gone over and over the fields and buttons and they all seem to be set up correctly. I feel like I've messed up my Default fields, but can't figure out how. Can you help?
I would say step 1 is start with a blank app and try again. 😀 See of you can get that to work then come back to this app and fix it. Remember making an app from data will also set this up for you so you can see it in action.
Hello Shane. Thank you so much for your videos. They have been very helpful I do have a question. I work with SharePoint & PowerApps. Is there a way to make it so the user only sees the form you have created? Right now when, for instance, a user clicks a button to add a list item the for opens but it also shows the quick launch menu to the left of it. I would like to make it so all they see is the form (to prevent them from digging around the site when they do not need access). Thank you again!
Hi Shane, I have couple of buttons and I am hiding few fields based on selection of the button, two buttons are Project and Resources. When I click on project it hides resources fields. But when I open the app and click edit or new record, it navigates to the edit form but its blank only shows when I select either of the buttons. Is it possible to set Project as selected by default so edit form starts with Project fields ?
Hi from Mexico, I am just starting to learn PowerApps and working on my first project. I hope you can guide me on this, radio button controls, instead of having text as items could you have images or a colored box (different for each item), the application would be to choose a color or fabric type and I am trying to have a more visual control rather than just the color name? Thanks a lot for all your shared knowledge :)
Hi Raul - Sadly, not exactly. What you might do though is put a radio control on the screen then put image controls over top of the radio button text. The user would never know they weren't directly linked. :)
Thank you Shane! very helpful video. i have a question, what if i want an incremental ID_FORM in my list of sharepoint, and i want to increment +1 every new record using forms? or its any way to autoincrement this ID_FORM in configuration list on sharepoint? Regards Shane
SharePoint has an ID column built in you can take advantage of. SharePoint also has calculated columns you could try. Or you could do this not awesome way i built for Excel. ruclips.net/video/plKw_xfVfwY/видео.html
Hi Shane. LOVE your videos, you have helped me out so much! I used to work a lot with InfoPath and now I am trying to step into the PowerApps world. Not always an easy task. So, I'm still new to PowerApps, and I came across Fluid Grid. I can't find much about it though Mr. Google, so do you have any hints on what this is / how it works?
Good afternoon, I have got my form working nicely where the save button updates the datasource and changes are displayed in view mode but only when the item property for the form is GalleryName.Selected. However, in one of your previous videos I watched, you said to not use GalleryName.Selected but instead to set the gallery item as a variable. When the item for the form is set as that variable, SubmitForm saves the changes back to the data source but those changes are not reflected in the ViewMode of the form until the user goes back to the gallery and re-selects the item again. Is there any way to refresh the variable and/or gallery so that the user does not have to manually go back to the gallery?
I put a label on my form showing Form1.Mode & Form1.DisplayMode and was thinking that's a new record but it says "1, edit what is wrong with PowerApps!?!?!?" and then you showed there's only two modes for DisplayMode. Thanks so much!
Shane could you please expalin a little bit more about OnSuccess option and OnFaliure Options while using Forms and the Advance property Action and how to display Mesgaes by system or to Navigate a Success Screen Thank You Shane your Videos have helped me a lot !!!
Hi Shane, is there a way to be in form view mode and allow users to have a clickable url link? The URL link only displays as a text. I want it to launch into a new browser. Do I need to change the property of that data field?
@@ShanesCows Darn. Thanks for answering I’ve been struggling trying to find a way! Seems I’ll need to create a new screen with multiple buttons for each url link.
Hey Shane, how is this images on your data showing on the gallery? They are a url from image or a uploaded image? DOes the images show on mobile devices?
Thanks for doing these videos. It helps a lot to fill in the gaps in knowledge. One question I do have tho how would you suggest dealing with an app on a phone where there is too much data to fill in on one page. There is logic to how it is broken up for entry but needs to be in a single record. Not sure of best way to navigate to a second form but stay on same record. Thanks
Hello Shane, your videos are fantastic, very helpful! I have a quick question, let's say I want to edit a record but when I hit save I want to create a new record in the SP list so I can use a date picker to filter the gallery and go back to the previous record using the last modified date. What command should I use for the submit button?
Hello Shane, your vidoes are great, thank you for sharing. I am trying to use a a template in powerapps called Property Management, i am trying to understand how this templete works as i don't see any data source linked when i create it. Can you help please?
The data was imported from an Excel spreadsheet and saved into the template. I don’t recommend trying to adapt this app for use instead be inspired by it and build your own app.
Thank you for this great video! I am currently working on a form where users will input some comments and there is a date and time stamp, the date and time are incorrect. How can I fix this?
Hi Shane, really liked your work. my question was, I created a list in sharepoint and added one column in the list from sharepoint itself. now when I am going to customize option from there in PowerApps the column are not showing in the preview. that did not happen for a existing list. for a existing list it was showing all the fields in the preview, can you tell me why am I getting this? i would really appreciate if you can help me out on this thanks Projesh Paul
Excellent...The only problem I am facing is that how to get a unique link of each mode (New,edit,view) because I want to redirect to these modes directly from user's email using Flow....
You will need to use deep linking. ruclips.net/video/A5Pi5P2YKds/видео.html Set one parameter for the ID of the record you want to edit and one parameter for the mode of the form.
Hi, I love your videos. I have a question I can't seem to solve. If I wanted my power app to read an existing record, and view in edit, and then once any change in a field has been made, to then create an entire new row (as opposed to replacing the entry in the column), how can I achieve that? MANY THANKS, Jese
I am relatively new to powerapps and I wanted to know is there a way to link our app to the list so that when we go to the list, select new, it uses this form instead of the default? I know you can do something with "Customize" link, but that preloads controls and I want to do it with a blank app.
@@ShanesCows Sorry, it is a very difficult question to ask. Essentially, when you go to a list and click new, it opens the form where you input values. You can modify this form in powerapp, but only so much because it isn't a blank app like you usually make in your vids. I want to know, on my list when I click new, can I have it open an app that has been created from scratch(how you usually make them), instead of having to make a modified version of the default form. I hope this is more clear.
Hi Shane, If I edit a form and I submit it in order to save it and I stay in the same screen, the form disappears. What is the best way to save the changes in a form? Use Patch to save the record, navigate to another screen and just come back, any other? Thanks in advance.
Hi, Shane. Now I'm working in my power app but a have problem, each user can load information and it will save in Sharepoint list, and another person needs to access to this list and to do some changes or uploads, but pick the form by either way the forma not is the same that indicated in the gallery.
Hey Shane, I enjoy watching every video, thanks for this beautifully explained videos. Can you please help me the link of the video --- Onfailure, Onsucess, On Reset
Hi Shane . Struggling with viewing a display form from a Microsoft Flow Link. It defaults to Sharepoint View and not PowerApp form .Any suggestions on defaulting the Flow Link to a default view?
Thank you for having this series, I am learning so much from you! I have a question and I want to have 1 button serve 2 functions (I might be totally wrong here). My issue is this: I created a form and on it I have a save button that saves the data back to it's source, but once it saves the form doesn't display anything. (No item to display) I wanted to have the form submit and then switch the display mode to view in order to see what I just entered. I have tried SubmitForm('form1');Lastsubmit('form1') and SubmitForm('form1');;Lastsubmit('form1') and SubmitForm('form1');Displaymode.view and none of them work. What am i doing wrong?
Hi Shane - Thanks so much for these videos. How do you keep the data you've edited in your form before submitting to the data source? So that multiple forms can be edited without having to press submit each time and do it at the end? Many thanks :)
Great videos very helpful indeed. I am stuck as a newbie on the "New Form". My form works great to view through my records. When I click a new form button it sets the form mode to New but all the data fields seem to disappear (labels are still there) and I have no where to enter new data. I cant seem to find any answers to this. Can anyone please help? Any clues gratefully recieved.
Martin. What happens when you try to edit a record? View works but what about edit? I bet you have the same issue. And I would also guess that your data source might have a primary key that is why PowerApps can't edit. What is your data source?
Shane Young thanks for your reply. Good point I need to test edit. I can view ok. And you are correct I’m using an sql database with a primary key, I just added one out of habit. I will remove this and see if that helps too. Thanks again for your time much appreciated.
@@ShanesCows Hi Shane thanks for your reply found the problem I was using the wrong data source for the form. I have one other problem i just can't figure out trying to sort my gallery after making a couple of selection. First this work's SortByColumns (colItemToShow, "Title"), but I want to base the gallery on selection made by the following If (ddPM.Selected. Result = "All”, colItemToShow, ddPM.Selected.Result "All", Filter(colItemToShow, 'Project Manager'.DisplayName = ddPM.Selected.Result) ) ... note this formula works. how do i combine the 2 formulas? Thank for any helpyou can give me
This is super cool. Can we do navigation through Records using PowerApps Forms, the navigation to be smooth even if we delete Records in the middle. The data source is SharePoint
Hi Shane, thanks for the video! But I still have a problem with my new app. I would like to have the NewMode and EditMode on the same screen but with two different forms. So I would like to create a new item in Form 1, click save and then Form 2 should be updated to be in the EditMode of the created item. I am using the same screen for New and Edit Mode. So the Item property is Gallery.Selected that's the reason why the new created item can't show up. Do you have an idea?
Hi Shane I have a form which is connected to sharepoint list When i Submit the form I don't see anything in the view form mode I have kept the items property of Form1 as defaults(form1) So every time a new record is created How to show only the earlier record ?
Shane, I created a power Application with two forms that are patch together and they fill up columns with all the data in share point. Now, I need to convert either all the Data cards from the form on Power apps into a PDF or the columns in SharePoint into a nice PDF form for state regulations. Can you direct me. Please help!
Hi Shane I want to create form using power apps that will display the number of person worked on particular task And I want to use excel as a data set I want the no of hours to be display as per the date can u please tell me how to do that I am new to powerapps
Hi Shane. Thanks for your videos. They have helped me many a times. I do have a question and would appreciate your kind assistance. I'm trying to come up with and Inspection App, where history of previous inspections are a must for audit purposes. I was thinking of having the app call up data from one SP List for items that needs to be inspected and once inspection is completed, have the app submit new data to a different SP List. How would you code the Submit button for this? Thanks
Hi Shane one request..if you start some series just like this one ( PowerApps forms) please add the number to the heading of video so that we can refer back in series to learn.
Good stuff!! Thank you for the helpful video. Do you have any videos showing how to reset a DatePicker's value to a Blank() value? In the SharePoint list and in the PowerApps detail and edit forms, the datepicker entry field shows blank until a date is selected and saved. However, I don't know how to force it back to the Blank state. It always seems to revert back to the last saved value, even when I edit the date field to contain no value. A link to the any documentation would be helpful as well. I've been looking and I can't seem to find anything.
Hi Shane, when I click on the edit button I still cannot change the field values in the field card. It puts the form in edit mode,But the fields are still in view mode, no editing can be done. I appreciate your help!
Hello Shane., I am new to PowerApps Developer. Your tutorials played a great role in me being a PowerApps guy. Thank you for that. I wanted to ask something, I have a collection in which i save the Feild_ID, Now when i navigate the Update Screen, I need to load the textboxes and Dropdown controls populated based on Field_ID Primary key. The data source is Azure SQL Server database and this is completely customized app. Can you please help here? How do I load a form with pre-populated fields based on the primary key (Field_ID)?
Hi Shane, Sweden here :-) thank you! you have helped me out so much! but I have one problem. I am using your instruction to make changes in existing gallery but when I submit my record and then choosing a new one from the gallery the form appears in edit form not I view form as expected, How to change display mode to view after pressed Submit button?
Hey Shane fantastic content as always ☺️.. I have a question re forms. I have added an edit form data source SQL add fields but the form is in view mode I've checked the properties are in edit but the form is just displaying the SQL backend data and unable to edit the form. Any ideas would be much appreciated. Darren
so we got a save button, but it just saves and stays on the edit screen, which now makes the users press cancel after saving and this will likely cause some frustration. how would i save and go back to viewform with 1 press on the save button?
Hi Shane, great video presentation as always, ive been watching your videos since i started using powerapps. I have a problem with forms that i cant find my way around it, i want to save my form using SubmitForm() and in the form there is a DatePicker control which i set its DisplayMode to View and DefaultDate to Now() which gives users the current date and they cant mess with it. When a user want to save the data they entered, powerapps returns an error message saying in the Date field, it expects a string. Im guessing that the date is in numerical format. How do i correct this? Thanks in advance
I just started working with/using/developing PowerApps last week and found your videos. I am a previous developer of about 16 years but haven't programmed in over 10 years. You do a great job presenting the info quickly and applicably. Thank you!!!
Thanks Randy 😻
Just what I needed! A proper human explaining things very clearly - fantastic. I will be back for more! Thank you.
Thanks that is the nicest thing I have been called today. 😂
I wanted to let you know how much you helped me!! I was able to change the entire process at my work, from excel spreadsheet to Sharepoint with PowerApps. Thank you so much Shane!!!!
Awesome Ricardo!
Hi Shane, I just started to learn PowerApps. Your videos are more than helpful. Thanks a lot. Cheers
You are fantastic! Best videos I have found to help me - we are gov't so really behind with our software and I am just learning PowerApps after being a SharePoint Admin for years. THANK YOU THANK YOU THANK YOU!!!
Glad to help Cat. 😀
Was able to learn a lot from this video towards my own project for a job opening. Don't know if I'll be accepted, but at least my horizons are further opened now. Thanks, Shane!
Awesome 😎
I really appreciate your way of explaining things - very clear and concise. I am not used to working on a browser interface, and one trap I keep falling into is that when I'm in Preview mode, the browser Back button is just too juicy to ignore. Of course, after hitting it many of the previous changes are not saved...
Sorry William. 😬 Hopefully you get used to it.
Your Videos are awesome. It helped me develop an Inter Departmental App, which reduced lot of back and forth communication. Thank you.
Cool 😎
This video and the one before was a true break through on a project I'm currently working on. Thanks so much!
That is awesome Paul. Good news I have one or two more to go even deeper with Forms. 😀 If you have specific nooks or crannies I should cover let me know.
The form that you had, was that brought in from MS Forms Pro (Preview)? Looking to make a form using power apps, that then has automation with power automate. I.e a custom Purchase Request Form, that once a form is submitted in power apps, the form goes to the relevant parties for approval.
Sorry for the delay. The video you saw didn't use MS Forms as the base, it was all Power Apps. THis video ruclips.net/video/49O284deOAI/видео.html talks about approvals like you want to do.
You have no idea how you helped me … awesome 👏🏻
Cool. 😀
I really did not understand PowerApps until you explained it. I am still not an expert (not even close LOL) but at least I can create one that works. Thanks Shane
Awesome!
Awesome video again Shane...... what if you want a button that deletes the record from sharepoint, how would you handle that?
I have a whole video on ways to handle delete. ruclips.net/video/xKXPmK00DCA/видео.html
You are the man! Another problem solved by the power of RUclips!!
Glad it helped.
Hi Shane, good video. Quick question related to that video. I understand the Edit and View modes however if I"m in Edit mode, I edit some fields and afterward I click your button Cancel (change mode to View) what happen with the fields that I had changed? The fields will be reset to original values or not?
Dave
Yes, reset to original values.
Thanks Shane. Wouldnt the Reset button be a better option than Cancel?
Sure. What ever works best for you.
Hi Shane, have you done any videos where you have an input form with a subform. Eg. a customer order which you input data from the order table and input data into an order details table in a subform
This isn’t exactly that but same general idea I think ruclips.net/video/xgznk4XlPCo/видео.html
I've been searching for this featuring since a month ago, you save my life, thx.
Glad to help
Hi Shane! Excellent video on PowerApps. I appreciate it. Could you please show us how to make an audit application using forms?
Noted. Thanks
Hi Shane , Can we add forms inside gallery as an item like nested galleries ?
I don't believe that you can. You will need to edit the data outside the gallery or switch to a more complicated gallery. Something like this. ruclips.net/video/xgznk4XlPCo/видео.html
Hello Shane, great Video. My question is : Why are the changes made in 'Edit' or "New' mode are not reflected in a Excel sheet, which is used as a common data source. Do we have to go through some more steps to map the changes to the drive?
No. If Excel is the data source and you edit the data and then submit the changes it will work.
@@ShanesCows Thank you for the reply. I did figure it out. If excel is open when I make my changes from app, it throws an error. Please reply to my other question of work around for max limit of 2000 rows. It would solve a major issue. And no, I cannot have more than one data table/gallery.
HI Shane, I created a Form which Default Mode is View and I added the same buttons you did on this example, new, edit, save and reset, when I change the form to Edit Mode using the edit button I added everything works fine and I can change the content of the form but when I save it the form remains in Edit form, so I added an additional function to save button "SubmitForm(Form1) = ViewForm(Form1)" It works , saves the information and changes to FormMode View but I'm getting a Runtimeerror "The form you are trying to submit is in read-only (view) mode. Only editable forms can be submited. As I said it works but I do not know if this error could mean an issue in the short term. Thanks in advance for the guidance!
Hey Shane. Thanks for the video. It really helped with a project I'm working on at the moment. But quick question - once I've clicked the save button, my form is still in the 'edit/new' mode. I want to click save and have it return to the view mode once it has saved it ... can't work it out ... I've tried this: "submitform(form2);form2.mode = view" on my save button (on select) but that's not working. I've also tried a similar thing on the 'on success' message of the form but that's not working either... thanks!
Set the OnSuccess to ViewForm(form2)
@@ShanesCows The button has no OnSucces option. When I do it in the form. This is not working. So how to move on?
@@stevenned23 Steven OnSuccess is on the form, not on the button. 😀
Hey Shane, thank for the video and it does help me to understand PowerApps more and more everyday by following your video. Keep up the good job! Thanks!
Great!
Great to learn something new with the difference between Form Mode and Display Mode. I think in a few of my projects I have been using Display mode. Great stuff
Yeah. Crazy so many little details on these boogers.
hi sir, may i know what is your function on the "Arrow" which you click on the browse screen that will direct you to the respective form?
Navigate(ScreenName)
Excellent video. Is it possible to keep the data inside the text and drop down fields after you submit? This would keep the end user from having to refill out the fields if they are needing to add just a few new details and submit a new entry to a Sharepoint list.
You could set the fields to default to a variable. Then have the submit form update those variables so you see those values after the form resets.
Hi Shane, I have enjoyed so many of your videos. I have spent 2 days on a problem and need solving. My primary table contains rows of data with ID numbers and names of other tables with the linking ID numbers. I'm using a form to display the data of the primary table but need to display some values from the other tables by using one of the fields from the primary table that has been selected. I have tried 'Search' and 'Filter' but cannot seem to get to the info. Can you help with this even if it is a video you can point me in the direction of. Please ask if you need further info.Thanks.
Phil try this video series. It shows relationships ruclips.net/video/xgznk4XlPCo/видео.html I think Part 2 is exactly what you want.
@@ShanesCows Hi Shane, thank you for your reply. I went through the part 2 video but it referenced two specific tables. Apologies as I had not explained it correctly. The Transaction table (Main Table) has a column that has company names for each table. When a transaction is selected it shows the company name in the gallery but in the details I want to call up the specific company (table) with it's details but cannot reference it until the transaction is selected. I hope this makes sense. Thanks again for your reply. I really enjoy your videos and humour.
@@ShanesCows I have managed to get it working using this formula:
LookUp( Ladbrokes, TransID = Gallery1.Selected.TransID, Stake )
I have used the actual table name "Ladbrokes" but when I try and use this:
LookUp( Gallery1.Selected.BackBookie, TransID = Gallery1.Selected.TransID, Stake )
It does not work. I have tried other variations but have run out of ideas. I hope this makes sense. Thanks Shane.
@@ShanesCows I have managed to find a workaround by using the Switch command which has worked. I would prefer a better solution but here is my solution with just a few of the bookies if it helps anyone.
Switch(Gallery1.Selected.BackBookie,"Ladbrokes",LookUp(Ladbrokes,TransID = Gallery1.Selected.TransID, Stake),
"Novibet",LookUp(Novibet,TransID = Gallery1.Selected.TransID, Stake),
"Bet365T",LookUp(Bet365T,TransID = Gallery1.Selected.TransID, Stake),
"Betfred",LookUp(Betfred,TransID = Gallery1.Selected.TransID, Stake),
"Coral",LookUp(Coral,TransID = Gallery1.Selected.TransID, Stake),
"Race Bets",LookUp(RaceBets,TransID = Gallery1.Selected.TransID, Stake),
"A888Sport",LookUp(A888Sport,TransID = Gallery1.Selected.TransID, Stake)
)
Hi Shane. Your videos save me so much and make me look awesome at work! I've got quick question though. With the "Submit / Save" button, what happens when you've got 2 forms on the screen, one that is being filled/edited and one that is pulling information from another list. Can the info from both forms be written back to the "parent" list which is the editable one?
You would have to submit both forms. Or maybe look at using Patch to write the data you want to the second list with the OnSuccess property of the form you are submitting.
Hi Shane, your videos are always helpful..thanks you so much..I am learning a lot thru them and implementing in my apps... :-)
Great to hear!
Hi Shane, thanks for the video ! I've got a little issue ... when I swith to view mode I can't view the selected result contained in my form's Dropdowns or ComboBox
Try making the field/card wider. That can be a challenge with Multi-select fields. You may also need to add a label with Concat function to better display when in view. Sorry, no easy answer.
Thankyou for the information. Here you have achieved the functionality to change to mode by placing the buttons into the screen. I have placed my buttons inside the Form within the datacard. Now the same EditForm(SharePointForm1) function on Onselect is not working. Need your help on this.
Button inherits the form mode if it is in the form. That is why it isn’t clickable. Need to get it out of the form b
@@ShanesCows Thank u . I have placed in the bottom of the screen for view mode . It's working now.
I have another requirement, need to disable the past dates in the calendar picker.. need your suggestion please.
Hi, Love the videos thank you. Just started last week and am taking in a lot. I have an issue that I am using two forms and you mention this. I have a form with a data grid (not a gallery) as my menu from there I can select a record, open, edit and save, however if I create a new record, I can open my form and enter details, when I hit my save button the record saves and it goes back to the previously selected item from the data grid as the form source from the grid, any ideas I want it to hold the record I've just saved,
It is possible with a gallery by using a variable to tell it what row to highlight. Not sure about a data grid. Unfortunately I haven't done a video I can point to for help. Boo me.
Hi Shane, Could you please suggest me how to reduce the size of the date picker. Awaiting for your reply
It something you can control
@@ShanesCows I heard of that ..It's the problem with the microsoft.. Bcoz whenever we open the date picker the calendar occupies most of the space
I got other questions, for example user answer A (Radio Button) , it will send email to the PIC,
May I ask how can I do it?
Use an If function to see if those chose A
@@ShanesCows if my forms is share by others, I only need the Forms ID?
Hi Shame, I enjoy your videos. I've encountered a problem while working on a customizing a PowerApps SharePoint List Form. Before I knew what I was doing (I still don't really) I removed some fields instead of making them not visible. Now I would like to use some of those fields but can't figure out how to get them back. Is there some way to do this that I am missing?
Select the form, click on Fields on the right pane, and then add Field In the menu
Thanks a lot for your videos. They help a lot. I have an issue and not sure if you can help me but I'm trying to create a form for a sharepoint list so anyone that needs to create a new iteam on it, can see the designed form made in powerapps but I added a submit button instead of using the save one on the top of sharepoint and does not work. I moved it out of the form per the suggestion you made but still I can't make it work.
Try this video ruclips.net/video/Badj3_T8zAw/видео.html
Shane Young thank you so much! It helped a lot.
Thank you for all of your videos. I have spent a ton of time creating a SharePoint Form to be used to edit SharePoint data. I would also like to create a similar Phone App based off of the same list. Is there a way to copy the Form view and create a Phone app using similar functionality to avoid creating the same app twice using two different form factors?
You can copy and paste between two apps. So maybe you could cut down on some of the rework.
Hi Shane !
Great video as always!
I have trying to create a form whose defaultmode is Edit, however the form loads only in the View Mode.
I have a primary key column also in the table ( using Apache Impala connectors to connect to my table)
Can you help me out
Use the ViewForm function to set the mode
Hi@@ShanesCows !
Thanks for the reply.
It seems that the Apache Impala(incubating) connector is the open source, native analytic database for Apache Hadoop. Connecting to your Impala database only reads data from tables. Thus we cant have a Edit Form because the connector doesn't support writing back to the database.
Could you shed some light on this ?
Impala connector official documentation - docs.microsoft.com/en-us/connectors/impala/
Hey Shane, can you direct me to the video you mention at the end of this one? The one about OnSuccess, OnFailure and OnReset. I haven't been able to find it
I can’t find it either. Hmmm. Email your question and I will try to help. Shane@ powerapps911.com
Please help can't able to find video
Hi, I am from India. Such a helpful Video. I am watching the entire series and its very helpful. One help please. What if I want to show a field only if it has value in it else want to hide it if has no value. Can you please tell me the OnVisible function for it ?
Hi Shane, I'm hoping you could elaborate more on the Star Visible and Error Message.
Thanks heaps, you're a legend here in Australia!
The star shows when the required property for the card is set to true. Errors... I do need to cover those better. 😀
Hi Shane, your videos are really helpful. I am trying to create different forms for new/edit but I have a question what is a point of OnEdit, OnNew and OnView under SharePointIntergration. I wanted to add there for instance that OnEdit I get different form but it's not working. So there is no way to do this unless I add a button on my form?
See if this helps. ruclips.net/video/Badj3_T8zAw/видео.html
Dear Shane, Thank you so such, really I gained a lot. By the by I am new to PowerApps. Initally I failed to view Excel table data in display form of PowerApps. When I select display form and mapped data source from OneDrive, it shows nothing. After adding the fileds from the data source, it shows only filed names. But when I select edit form it dispays all table data. Would pls suggest how may I view all data from a table.
Maybe you had the excel file open? Also galleries are used to show all rows in a table not forms.
Thank you, you have helped me twice. Good job.
Glad to help
Hi Shane, I have a question regarding the drop-down box and radio button in the custom form.The question is , the value which I select in radio button the same value should reflect in the drop-down box I am unable to fix it. Could you please guide me in it.
Set the default of the Dropdown to be the radio.selected
We tried doing that Shane but it's throwing an red error under radio.selected
Could you please help us
Hi Shane, thanks for this.
I just have a new scenario. I save a new form data, all good. I want to edit a record, all good but here, I want the form to be auto populated which is happening but post making changes the record must be saved as new record in the SharePoint list and not update the existing. How to achieve this?
Takes a lot of work. This might give you some ideas ruclips.net/video/mbKovagC7As/видео.html
Awesome videos. Have 2 questions. Is it possible to turn a data card in the form to a drop down or one of the other controls?. I also have multiple screens that I want the data to connect to. I would like the name that is entered to auto fill in other screens, is that possible?
Yes and yes. I think in my SharePoint customize forms video I cover changing to a dropdown. Then on other screens you can reference the control that has the value. Watch the video on PowerApps variables for 2 different options.
Hi Shane! Thank you for your direct, clear, plain language explanations of how to do all things PowerApps! I do have a question about this process. So, I have an app with a Browse, Details and Edit screen, where an icon on Browse allows for the Edit screen to go into New Mode and an icon on the Details screen puts it in Edit Mode. The Add mode works fine - puts in my Hint text or blank fields. The Edit mode however does not show the contents from the Details screen, but the blank fields and/or Hint text! Now, I can play with the Default field of each card and make it display the actual contents of the field, but then that field doesn't show Hint text in New any longer. It's like I am not toggling correctly between content in New vs content in Edit. I probably broke it somehow but now cannot figure out how to fix it - I've gone over and over the fields and buttons and they all seem to be set up correctly. I feel like I've messed up my Default fields, but can't figure out how. Can you help?
I would say step 1 is start with a blank app and try again. 😀 See of you can get that to work then come back to this app and fix it. Remember making an app from data will also set this up for you so you can see it in action.
Hello Shane. Thank you so much for your videos. They have been very helpful I do have a question. I work with SharePoint & PowerApps. Is there a way to make it so the user only sees the form you have created? Right now when, for instance, a user clicks a button to add a list item the for opens but it also shows the quick launch menu to the left of it. I would like to make it so all they see is the form (to prevent them from digging around the site when they do not need access). Thank you again!
Hi Shane, I have couple of buttons and I am hiding few fields based on selection of the button, two buttons are Project and Resources. When I click on project it hides resources fields. But when I open the app and click edit or new record, it navigates to the edit form but its blank only shows when I select either of the buttons. Is it possible to set Project as selected by default so edit form starts with Project fields ?
Set a variable with the record and use that. This video shows the concept ruclips.net/video/A5Pi5P2YKds/видео.html
Shane Young thanks a lot Shane !! Really appreciate your help :)
Hi from Mexico, I am just starting to learn PowerApps and working on my first project. I hope you can guide me on this, radio button controls, instead of having text as items could you have images or a colored box (different for each item), the application would be to choose a color or fabric type and I am trying to have a more visual control rather than just the color name? Thanks a lot for all your shared knowledge :)
Hi Raul - Sadly, not exactly. What you might do though is put a radio control on the screen then put image controls over top of the radio button text. The user would never know they weren't directly linked. :)
Sounds easy and exactly the effect we want, thank you!
Really good work, Shane never fails. What if I want to alter "Fill" property of Item selected in edit mode.
Put an If formula in the Fill property
Thank you Shane! very helpful video. i have a question, what if i want an incremental ID_FORM in my list of sharepoint, and i want to increment +1 every new record using forms? or its any way to autoincrement this ID_FORM in configuration list on sharepoint? Regards Shane
SharePoint has an ID column built in you can take advantage of. SharePoint also has calculated columns you could try. Or you could do this not awesome way i built for Excel. ruclips.net/video/plKw_xfVfwY/видео.html
@@ShanesCows Than you! i will try with ID Column on Sharepoint! best regards Shane!
Hi Shane. LOVE your videos, you have helped me out so much! I used to work a lot with InfoPath and now I am trying to step into the PowerApps world. Not always an easy task. So, I'm still new to PowerApps, and I came across Fluid Grid. I can't find much about it though Mr. Google, so do you have any hints on what this is / how it works?
I don’t know what is fluid grid. Any hints?
Good afternoon, I have got my form working nicely where the save button updates the datasource and changes are displayed in view mode but only when the item property for the form is GalleryName.Selected. However, in one of your previous videos I watched, you said to not use GalleryName.Selected but instead to set the gallery item as a variable. When the item for the form is set as that variable, SubmitForm saves the changes back to the data source but those changes are not reflected in the ViewMode of the form until the user goes back to the gallery and re-selects the item again. Is there any way to refresh the variable and/or gallery so that the user does not have to manually go back to the gallery?
Hi John - In the OnSuccess property of your form Set the variable again. SOmething like Set(varRecord, FormName.LastSubmit) will probably work. :)
awesome... if i want to place the form in another screen and open it in view mode by default how to do it plz?
Maybe this will help? ruclips.net/video/if_mFIfi5PM/видео.html
I put a label on my form showing Form1.Mode & Form1.DisplayMode and was thinking that's a new record but it says "1, edit what is wrong with PowerApps!?!?!?" and then you showed there's only two modes for DisplayMode. Thanks so much!
They changed it. Not it is easier to test If(form1.mode = formmode.edit, then do something)
Shane could you please expalin a little bit more about OnSuccess option and OnFaliure Options while using Forms and the Advance property Action and how to display Mesgaes by system or to Navigate a Success Screen
Thank You Shane your Videos have helped me a lot !!!
Sounds like i need to do another video on Forms :)
@@ShanesCows you Rock Shane Thank you for all your videos !!!
Hi Shane, is there a way to be in form view mode and allow users to have a clickable url link? The URL link only displays as a text. I want it to launch into a new browser. Do I need to change the property of that data field?
I don't think you can Sean. I have complained about it for years. You will have to get the link out of the form. :(
@@ShanesCows Darn. Thanks for answering I’ve been struggling trying to find a way! Seems I’ll need to create a new screen with multiple buttons for each url link.
Hey Shane, how is this images on your data showing on the gallery? They are a url from image or a uploaded image? DOes the images show on mobile devices?
They are from a url. I uploaded the pics to a SharePoint pic library. Then in my list I have a link to the pics.
Thanks for doing these videos. It helps a lot to fill in the gaps in knowledge. One question I do have tho how would you suggest dealing with an app on a phone where there is too much data to fill in on one page. There is logic to how it is broken up for entry but needs to be in a single record. Not sure of best way to navigate to a second form but stay on same record. Thanks
Either don't use forms and instead use Patch OR check out this for Form tabs. ruclips.net/video/if_mFIfi5PM/видео.html
Hello Shane, your videos are fantastic, very helpful! I have a quick question, let's say I want to edit a record but when I hit save I want to create a new record in the SP list so I can use a date picker to filter the gallery and go back to the previous record using the last modified date. What command should I use for the submit button?
Not sure I follow. Might be easier to use Patch than submit form to get more control
@@ShanesCows yes, patch was the way to go! Thank you for taking the time to reply back!
I laughed wholeheartedly at some point in this. Good job for bringing the humour
Hello Shane, your vidoes are great, thank you for sharing. I am trying to use a a template in powerapps called Property Management, i am trying to understand how this templete works as i don't see any data source linked when i create it. Can you help please?
The data was imported from an Excel spreadsheet and saved into the template. I don’t recommend trying to adapt this app for use instead be inspired by it and build your own app.
@@ShanesCows Thank you, i will try to build one of my own :)
Thank you for this great video! I am currently working on a form where users will input some comments and there is a date and time stamp, the date and time are incorrect. How can I fix this?
Hi Shane, really liked your work. my question was, I created a list in sharepoint and added one column in the list from sharepoint itself. now when I am going to customize option from there in PowerApps the column are not showing in the preview. that did not happen for a existing list. for a existing list it was showing all the fields in the preview, can you tell me why am I getting this?
i would really appreciate if you can help me out on this
thanks
Projesh Paul
Click add fields and you should be able to add it
Excellent...The only problem I am facing is that how to get a unique link of each mode (New,edit,view) because I want to redirect to these modes directly from user's email using Flow....
You will need to use deep linking. ruclips.net/video/A5Pi5P2YKds/видео.html Set one parameter for the ID of the record you want to edit and one parameter for the mode of the form.
@@ShanesCows followed your video already... The only problem I am facing is how to get direct link for view item and not edit one?
Hi, I love your videos. I have a question I can't seem to solve. If I wanted my power app to read an existing record, and view in edit, and then once any change in a field has been made, to then create an entire new row (as opposed to replacing the entry in the column), how can I achieve that? MANY THANKS, Jese
You would have the form in NewMode but have all the defaults be the values from the existing record. So if they hit save it creates a new record.
@@ShanesCows Essentially using Patch right? to do that. THANKS
I am relatively new to powerapps and I wanted to know is there a way to link our app to the list so that when we go to the list, select new, it uses this form instead of the default? I know you can do something with "Customize" link, but that preloads controls and I want to do it with a blank app.
I don’t follow. Sorry.
@@ShanesCows Sorry, it is a very difficult question to ask. Essentially, when you go to a list and click new, it opens the form where you input values. You can modify this form in powerapp, but only so much because it isn't a blank app like you usually make in your vids. I want to know, on my list when I click new, can I have it open an app that has been created from scratch(how you usually make them), instead of having to make a modified version of the default form. I hope this is more clear.
Hi Shane,
If I edit a form and I submit it in order to save it and I stay in the same screen, the form disappears.
What is the best way to save the changes in a form? Use Patch to save the record, navigate to another screen and just come back, any other?
Thanks in advance.
In the OnSucces our the form into view mode and make sure the items property reflects the record you want to show
Hi, Shane. Now I'm working in my power app but a have problem, each user can load information and it will save in Sharepoint list, and another person needs to access to this list and to do some changes or uploads, but pick the form by either way the forma not is the same that indicated in the gallery.
Check your forms Item property
Hi, can we add edit custom form using powerapps, apart from three basic form
Hey Shane, I enjoy watching every video, thanks for this beautifully explained videos. Can you please help me the link of the video --- Onfailure, Onsucess, On Reset
Maybe this ruclips.net/video/N8DWvS7P9lw/видео.html
Hi Shane . Struggling with viewing a display form from a Microsoft Flow Link. It defaults to Sharepoint View and not PowerApp form .Any suggestions on defaulting the Flow Link to a default view?
Not sure. I haven ran into that. Please post back if you get it sorted.
@@ShanesCows Will do
Thank you for having this series, I am learning so much from you! I have a question and I want to have 1 button serve 2 functions (I might be totally wrong here). My issue is this: I created a form and on it I have a save button that saves the data back to it's source, but once it saves the form doesn't display anything. (No item to display)
I wanted to have the form submit and then switch the display mode to view in order to see what I just entered. I have tried SubmitForm('form1');Lastsubmit('form1')
and
SubmitForm('form1');;Lastsubmit('form1')
and
SubmitForm('form1');Displaymode.view
and none of them work. What am i doing wrong?
SubmitForm(Form1) Then on the OnSuccess property of Form1 set ViewForm(Form1) 😀
Hi Shane , can you show me how edit a form in two screens? . thanks
Hi Shane - Thanks so much for these videos. How do you keep the data you've edited in your form before submitting to the data source? So that multiple forms can be edited without having to press submit each time and do it at the end?
Many thanks :)
YOu could store in a collection. I think I showed it in this fun video. ruclips.net/video/MclJ_O9HvJQ/видео.html
@@ShanesCows Thank you!! :):)
Great videos very helpful indeed. I am stuck as a newbie on the "New Form". My form works great to view through my records. When I click a new form button it sets the form mode to New but all the data fields seem to disappear (labels are still there) and I have no where to enter new data. I cant seem to find any answers to this. Can anyone please help? Any clues gratefully recieved.
Martin. What happens when you try to edit a record? View works but what about edit? I bet you have the same issue. And I would also guess that your data source might have a primary key that is why PowerApps can't edit. What is your data source?
Shane Young thanks for your reply. Good point I need to test edit. I can view ok. And you are correct I’m using an sql database with a primary key, I just added one out of habit. I will remove this and see if that helps too. Thanks again for your time much appreciated.
Hi Shane I followed the video setup gallery, form and buttons. But when I save the form it creates a new record in the SharePoint list?
That means your form's mode is in New not Edit.
@@ShanesCows Hi Shane thanks for your reply found the problem I was using the wrong data source for the form. I have one other problem i just can't figure out trying to sort my gallery after making a couple of selection. First this work's
SortByColumns (colItemToShow, "Title"), but I want to base the gallery on selection made by the following
If (ddPM.Selected. Result = "All”, colItemToShow,
ddPM.Selected.Result "All", Filter(colItemToShow, 'Project Manager'.DisplayName = ddPM.Selected.Result)
) ... note this formula works. how do i combine the 2 formulas?
Thank for any helpyou can give me
Great Video - thanks very much. I had some problems with forms and I am confident to fix them now.
Awesome
This is super cool. Can we do navigation through Records using PowerApps Forms, the navigation to be smooth even if we delete Records in the middle. The data source is SharePoint
Hi Shane,
thanks for the video!
But I still have a problem with my new app.
I would like to have the NewMode and EditMode on the same screen but with two different forms.
So I would like to create a new item in Form 1, click save and then Form 2 should be updated to be in the EditMode of the created item.
I am using the same screen for New and Edit Mode. So the Item property is Gallery.Selected that's the reason why the new created item can't show up.
Do you have an idea?
It should work if you set the mode properly and the item based on the item you just created. Try formname.lastsubmit
Hi Shane
I have a form which is connected to sharepoint list
When i Submit the form I don't see anything in the view form mode
I have kept the items property of Form1 as defaults(form1)
So every time a new record is created
How to show only the earlier record ?
Shane, I created a power Application with two forms that are patch together and they fill up columns with all the data in share point. Now, I need to convert either all the Data cards from the form on Power apps into a PDF or the columns in SharePoint into a nice PDF form for state regulations. Can you direct me. Please help!
This video should help ruclips.net/video/bfXV_GXc_JM/видео.html
Hi Shane
I want to create form using power apps that will display the number of person worked on particular task
And I want to use excel as a data set
I want the no of hours to be display as per the date can u please tell me how to do that I am new to powerapps
Start as simple as possible. It is possible just need to break it down to small problems
Hi Shane. Thanks for your videos. They have helped me many a times. I do have a question and would appreciate your kind assistance. I'm trying to come up with and Inspection App, where history of previous inspections are a must for audit purposes. I was thinking of having the app call up data from one SP List for items that needs to be inspected and once inspection is completed, have the app submit new data to a different SP List. How would you code the Submit button for this? Thanks
I would set the OnSuccess property of the form to Patch the second list.
@@ShanesCows Thank you kindly. Will give that a try.
Hi Shane Excellent video on PowerApps. I appreciate it. Thank for the video Can do a video on PowerApp and PowerAutomate or Flow.
I have a lot of power apps and flow videos.
Hi Shane one request..if you start some series just like this one ( PowerApps forms) please add the number to the heading of video so that we can refer back in series to learn.
Got it. :) I have tried in the past and I always screw it up. :) But I will try harder. :) Thanks
@@ShanesCows I think this can be done now for past videos as well ;)
Should not be that hard to but a "#1" etc in the title. ^^,
Great video though!
What's the difference between Form Mode and Display Mode (besides one is a number)?
Form mode only applies to forms. It can be new, edit, or view. DisplayMode applies to all controls and can be edit, view, or disabled. 😎
@@ShanesCows Awesome thanks
Good stuff!! Thank you for the helpful video. Do you have any videos showing how to reset a DatePicker's value to a Blank() value? In the SharePoint list and in the PowerApps detail and edit forms, the datepicker entry field shows blank until a date is selected and saved. However, I don't know how to force it back to the Blank state. It always seems to revert back to the last saved value, even when I edit the date field to contain no value. A link to the any documentation would be helpful as well. I've been looking and I can't seem to find anything.
Interesting. Email me and I will look at this Monday. Great question I don’t want to forget.
Hi Shane, when I click on the edit button I still cannot change the field values in the field card. It puts the form in edit mode,But the fields are still in view mode, no editing can be done. I appreciate your help!
What is your data source? Are you sure you used an edit form and not a display form?
OK got it! thanks Shane.
Hello Shane., I am new to PowerApps Developer. Your tutorials played a great role in me being a PowerApps guy. Thank you for that. I wanted to ask something, I have a collection in which i save the Feild_ID, Now when i navigate the Update Screen, I need to load the textboxes and Dropdown controls populated based on Field_ID Primary key. The data source is Azure SQL Server database and this is completely customized app. Can you please help here? How do I load a form with pre-populated fields based on the primary key (Field_ID)?
You need to do a lookup to get the data from sql.
Hi Shane, Sweden here :-) thank you! you have helped me out so much! but I have one problem. I am using your instruction to make changes in existing gallery but when I submit my record and then choosing a new one from the gallery the form appears in edit form not I view form as expected, How to change display mode to view after pressed Submit button?
Set the OnSuccess property of the form to ViewForm(YourFormName)
@@ShanesCows Thank you! It works! now
thank you so much, this video and the one before helped me immensely with a new project at work.
Very cool. 😀
Shane, thanks for the vid. But when i implement the SAVE button, I receive een network error...
Network error using Patch function... Do you have a solution?
What is the error you are getting? Also post your Patch formula.
@@ShanesCows Network error using Patch function...
SubmitForm(Form1) is my formula
The error is: Network error using Patch function. The requested operation is invalid
Hey Shane fantastic content as always ☺️.. I have a question re forms. I have added an edit form data source SQL add fields but the form is in view mode I've checked the properties are in edit but the form is just displaying the SQL backend data and unable to edit the form. Any ideas would be much appreciated. Darren
Is there any way to use the last selected gallery item with a new form?
I don’t understand?
so we got a save button, but it just saves and stays on the edit screen, which now makes the users press cancel after saving and this will likely cause some frustration.
how would i save and go back to viewform with 1 press on the save button?
Set the OnSuccess property of the form to navigate or change the mode to what you want.
Hi Shane, great video presentation as always, ive been watching your videos since i started using powerapps.
I have a problem with forms that i cant find my way around it, i want to save my form using SubmitForm() and in the form there is a DatePicker control which i set its DisplayMode to View and DefaultDate to Now() which gives users the current date and they cant mess with it. When a user want to save the data they entered, powerapps returns an error message saying in the Date field, it expects a string. Im guessing that the date is in numerical format. How do i correct this? Thanks in advance
Try Today() instead of Now().