PowerApps Forms - Form Mode
Vložit
- čas přidán 28. 06. 2024
- In this video, you will learn about PowerApps Forms and their Form Modes. This is the second in a series of videos on forms to explore all of the nooks and crannies involved with this key PowerApps control.
Part 1 - PowerApps forms • PowerApps Forms - Intr...
Getting started with PowerApps and Excel • Learn to connect: Powe...
For adddtional help please check out PowerApps911 www.PowerApps911.com - Věda a technologie
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.
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. 😂
Hi Shane, I just started to learn PowerApps. Your videos are more than helpful. Thanks a lot. Cheers
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 😻
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. 😀
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!
I've been searching for this featuring since a month ago, you save my life, thx.
Glad to help
You have no idea how you helped me … awesome 👏🏻
Cool. 😀
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.
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!
thank you so much, this video and the one before helped me immensely with a new project at work.
Very cool. 😀
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 😎
Finally worked this out, thank you heaps!
Awesome!
Great Video - thanks very much. I had some problems with forms and I am confident to fix them now.
Awesome
You are the man! Another problem solved by the power of CZcams!!
Glad it helped.
Your Videos are awesome. It helped me develop an Inter Departmental App, which reduced lot of back and forth communication. Thank you.
Cool 😎
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!
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!
Thank you, you have helped me twice. Good job.
Glad to help
Very thankful for these great videos. I am learning alot! :o)
Awesome
God Bless you this video made my day.
Thanks Sarah 🦄
Hi Shane young! Great tutorial as Always. Working my first project. Thanks and GodBless.. Never stop learning.
Hope you inlcude charts and graphs tutorial in your list. Like Dashboard kind of thing. :)
Been a common request lately and is on the list for sure. 😀 Do you have specific questions you want to see me cover?
Thanks Shane :)
Yes I have one question, how to send the screenshot of the Charts in Email or the Form Details in E-mail ?
I laughed wholeheartedly at some point in this. Good job for bringing the humour
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. 😀
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.
Thank you! You are really good explaining!
You're very welcome!
I LOVE YOUR VIDEOS!!!
Excellent! It helped me a lot!
Thanks 😊
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 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. 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?
Hi Shane! Excellent video on PowerApps. I appreciate it. Could you please show us how to make an audit application using forms?
Noted. Thanks
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 czcams.com/video/N8DWvS7P9lw/video.html
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. 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.
Great video
Thank you! So many little things to cover. 😀
Hey Shane, Very good tutorial you made my day. Same i would like to develop some Inventory tool for my organization can you please help me out of this
Glad it helped. Build your app in baby pieces to make it easier.
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
Thank you for all your vidéos, they were very helpfull. However, I was developping an app and since this morning, the ViewForm function ceased to work. Can you help me with that ?
Hi Shane can you please do a video about tables and graphs some tips and tricks..ive never seen a tuitorial video on that here in youtube..thank you..more power
It is on the list for sure. 😀 Specific things or questions?
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. czcams.com/video/if_mFIfi5PM/video.html
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!
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
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, 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!
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
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, 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 ?
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 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!
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().
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, 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
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 czcams.com/video/49O284deOAI/video.html talks about approvals like you want to do.
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, 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. czcams.com/video/Badj3_T8zAw/video.html
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. czcams.com/video/MclJ_O9HvJQ/video.html
@@ShanesCows Thank you!! :):)
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.
Thanks!! Great video Shane!!, I made some buttons and one of them i need to control the form (
visible through if statement), but i still don't get it (it shows "there is no item to display").
The button is under "infinite scroll" canvas. Please ur help!!
Not sure. Sorry
I figured it out myself, but I prefer to learn from you. Perhaps a video on How to filter data by date (I use Excel and OneDrive Business). Also how to have a navigate screen to filter the data on page where the gallery is stored, then filter that second page by date. As I said, I figured it out, but I was disappointed to have to find several different (more difficult to understand) sources for that info. What I have is an app where I manage my student's assignments. (I'm a homeschool teacher). On page 1 I choose the student, then navigate to page two where my gallery is stored. On that page, I have a "today" button which is the default. So after a student picks their name on page 1, page two automatically shows their assignments for that day. I added a "yesterday" and "Tomorrow" "button" (icons) as well. I'd also like to figure out a print function (if that's even possible), but you may have that in one of these videos. I have a few more to watch today.
Hi Maria. On the print function there is no real way today. Good news is the product team is actively working on it. Today people are selecting text and then using the browser print function.
Sorting by dates is tough. Glad you got it. If you send me some screenshots happy to take a look and see if I have suggestions or ideas. Shane at PowerApps911.com
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.
Hi Shane, I'm facing something weird in my form. Whenever I edit a selected item from the gallery and save it on the next "Edit-screen" created by me (containing an edit form), and after editing when I press the save button (which does a simple SubmitForm()), on the "Edit-Screen", it shows me the details of the first element from the gallery. Have you seen anything like these ever before?
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. czcams.com/video/xKXPmK00DCA/video.html
Hi thank for ur valuable information and pls tell how to validate the email in power apps.
Look at my video on conditional formatting for more tips.
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.
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 czcams.com/video/xgznk4XlPCo/video.html
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. 😀
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.
If you add all these buttons, now there are duplicative buttons when editing a form. The default submit button and the submit button you made
1million thanks
Glad to help. 😀
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!
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 czcams.com/video/Badj3_T8zAw/video.html
Shane Young thank you so much! It helped a lot.
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.
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.
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 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
Hi, can we add edit custom form using powerapps, apart from three basic form
Hi Shane. How would you allow folks to only edit certain fields after the form is initially created. Example: someone fills in a request a new job code form for an accounting system. Once filled out and approved, another person comes back and updates the form with the code but can ONLY edit that field and not be able to change any other fields. I’ve been trying to figure out how to do this with the modes.
Hope that makes sense.
Your vids are super duper helpful! Can’t thank you enough.
I figured it out. Everyone should read this article on the modes. You can have different screens for view, create and edit!
powerapps.microsoft.com/en-us/blog/separate-custom-forms/
Perhaps a show idea Shane. This was a groundbreaking find for me.
Cool. Glad you got it.
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.
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!
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.
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. :)
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.
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. czcams.com/video/plKw_xfVfwY/video.html
@@ShanesCows Than you! i will try with ID Column on Sharepoint! best regards Shane!
Hey Shane, I've got a form without the Display Mode property? I've tried changing one field on the form to DisplayMode:Edit but then the SubmitForm( gives an error saying that the entire form needs to be in Edit mode. I'm trying to allow a single field to be edited by only certain users based upon an if(user().Email formula. I'd prefer to not add a second form to the canvas as the first one is setup as a nice scrolling page and that would mess it up. Any advice would be great!
The form has to be in edit mode. Then you can change all the other fields to not edit. Is my guess without recreating it.
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
Thxs for such detailed explanation...👍👍 u have explained ...edit... view.... new..... Plzzz.... can u advise....How can I delete a record...thxs
This should help PowerApps delete SharePoint list item, related items, and confirmation
czcams.com/video/xKXPmK00DCA/video.html
Thanks a lot....@@ShanesCows
Thanks Shane. Wouldnt the Reset button be a better option than Cancel?
Sure. What ever works best for you.
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
Great Vid! But can I make a "delete" button from view mode?
I think so. Just need to use the remove function.
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
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? czcams.com/video/if_mFIfi5PM/video.html
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 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)
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 ?
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 czcams.com/video/mbKovagC7As/video.html
Hi Shane, nice video, but you know, How can i share the app? if other person are not members from my company
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
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/