PowerApps Forms - Form Mode

[@LaurenceBoulter]

Just what I needed! A proper human explaining things very clearly - fantastic. I will be back for more! Thank you.

[@ShanesCows]

Thanks that is the nicest thing I have been called today. 😂

[@Bursa4k]

You have no idea how you helped me … awesome 👏🏻

[@ShanesCows]

Cool. 😀

[@paullewis2120]

This video and the one before was a true break through on a project I'm currently working on. Thanks so much!

[@ShanesCows]

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.

[@davenadine9719]

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

[@ShanesCows]

Yes, reset to original values.

[@NigelStratton]

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!

[@ShanesCows]

They changed it. Not it is easier to test If(form1.mode = formmode.edit, then do something)

[@desh_d]

isn't Greg and Shane are same person??? blue shirt ..ugly face...hahahh kidding.. You rock..thanks for uploading it.

[@ShanesCows]

Greg wishes. 😂

[@abumomen9452]

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.

[@ShanesCows]

Maybe you had the excel file open? Also galleries are used to show all rows in a table not forms.

[@florentperrin8132]

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

[@ShanesCows]

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.

[@ashimishra23]

Hi Shane, your videos are always helpful..thanks you so much..I am learning a lot thru them and implementing in my apps... :-)

[@ShanesCows]

Great to hear!

[@ricardoroiseman1857]

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

[@ShanesCows]

Awesome Ricardo!

[@HelldownOfficial]

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.

[@ShanesCows]

Sorry for the delay. The video you saw didn't use MS Forms as the base, it was all Power Apps. THis video kzbin.info/www/bejne/amqyY2tqmcqCd6s talks about approvals like you want to do.

[@rpavanshetty]

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?

[@ShanesCows]

Takes a lot of work. This might give you some ideas kzbin.info/www/bejne/o5OuoKmXnKhqd9U

[@uboy4494]

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!

[@ShanesCows]

This video should help kzbin.info/www/bejne/mJe7h5J9jciSgK8

[@mariafernandaizajimenez4537]

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.

[@ShanesCows]

Check your forms Item property

[@matheusdias3539]

I got a Button that in the TEXT, there's this information : ThisItem.FASE.VALUE, how may I a SET to do a part of the form get Invisible from a Buttom and Visible to another ? Could you give me a tip ?

[@ShanesCows]

This video about Tabs shows you how to show and hide data cards in a form. 😎 I think that is what you are lookiong for.

[@rochellenicholson6372]

Awesome video again Shane...... what if you want a button that deletes the record from sharepoint, how would you handle that?

[@ShanesCows]

I have a whole video on ways to handle delete. kzbin.info/www/bejne/rny7gaCBZZV3eaM

[@CodeBroRob]

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?

[@ShanesCows]

Set the OnSuccess property of the form to navigate or change the mode to what you want.

[@rizwansiddiqui2052]

Thxs for such detailed explanation...👍👍 u have explained ...edit... view.... new..... Plzzz.... can u advise....How can I delete a record...thxs

[@ShanesCows]

This should help PowerApps delete SharePoint list item, related items, and confirmation kzbin.info/www/bejne/rny7gaCBZZV3eaM

[@rizwansiddiqui2052]

Thanks a lot....@@ShanesCows

[@isobelsoo8723]

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?

[@ShanesCows]

Navigate(ScreenName)

[@rajarn7566]

I need only edit screen, users need to just edit and submit Users should not be able to view any other screen like detail and browse gallery screen Can you help me with that

[@ShanesCows]

Build your app with just the screens you need. You don’t have to build more

[@komalpagare961]

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

[@ShanesCows]

Start as simple as possible. It is possible just need to break it down to small problems

[@krerae]

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

[@ShanesCows]

Thanks Randy 😻

[@nagarkarsiddhi6540]

I can't find video on Onsuccess, On Reset,OnFailure,please help

[@ShanesCows]

kzbin.info/www/bejne/p2PFmZ94dtaBlac and kzbin.info/www/bejne/hGmniKmJbLVsotk

[@cheahengsoon]

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?

[@ShanesCows]

Use an If function to see if those chose A

[@cheahengsoon]

@@ShanesCows if my forms is share by others, I only need the Forms ID?

[@andrewcole5039]

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

[@ShanesCows]

This isn’t exactly that but same general idea I think kzbin.info/www/bejne/rpjdn55qjdGDedE

[@tejaskshirsagar933]

Hi Shane , Can we add forms inside gallery as an item like nested galleries ?

[@ShanesCows]

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. kzbin.info/www/bejne/rpjdn55qjdGDedE

[@imranfc]

Hi Shane i have need your help . i have to face some problem on power app

[@ShanesCows]

Feel free to post a comment and I can try to help or contact www.PowerApps911.com

[@mahalakshmi1404]

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]

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

[@mahalakshmi1404]

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

[@LAXMIKANT1992]

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

[@ShanesCows]

You will need to use deep linking. kzbin.info/www/bejne/d2azmmiGZ75-mtU Set one parameter for the ID of the record you want to edit and one parameter for the mode of the form.

[@LAXMIKANT1992]

@@ShanesCows followed your video already... The only problem I am facing is how to get direct link for view item and not edit one?

[@MSandovalPhD]

Thank you, you have helped me twice. Good job.

[@ShanesCows]

Glad to help

[@sbeerrabbit3793]

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

[@ShanesCows]

Sounds like i need to do another video on Forms :)

[@sbeerrabbit3793]

@@ShanesCows you Rock Shane Thank you for all your videos !!!

[@seanthao289]

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]

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

[@seanthao289]

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

[@hemantrathod6235]

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 ?

[@ShanesCows]

Set a variable with the record and use that. This video shows the concept kzbin.info/www/bejne/d2azmmiGZ75-mtU

[@hemantrathod6235]

Shane Young thanks a lot Shane !! Really appreciate your help :)

[@gaetanoguy4969]

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?

[@ShanesCows]

That means your form's mode is in New not Edit.

[@gaetanoguy4969]

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

[@rssir5689]

Once I press save and the form has successfully submitted I would like for the app to return into display mode as it automatically stays in the edit mode I've used to add or edit the form. I can't figure out how to do this? Any ideas?

[@ShanesCows]

Forms have an OnSuccess property. Use ViewForm(yourFormName) there to set the form back :)

[@rssir5689]

@@ShanesCows Thanks a lot, Make's it much easier then having a separate screen for edit and new which is what I've done in the past and most other youtubers teach. cheers

[@mahalakshmi1404]

Hi Shane, Could you please suggest me how to reduce the size of the date picker. Awaiting for your reply

[@ShanesCows]

It something you can control

[@mahalakshmi1404]

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

[@adieneney]

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.

[@ShanesCows]

Try this video kzbin.info/www/bejne/eJLHm2aViZ2td9k

[@adieneney]

Shane Young thank you so much! It helped a lot.

[@PhilSowden]

What's the difference between Form Mode and Display Mode (besides one is a number)?

[@ShanesCows]

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

[@PhilSowden]

@@ShanesCows Awesome thanks

[@RobHerma91]

Hi Shane, I just started to learn PowerApps. Your videos are more than helpful. Thanks a lot. Cheers

[@jacobdrewa5384]

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

[@ShanesCows]

I can’t find it either. Hmmm. Email your question and I will try to help. Shane@ powerapps911.com

[@nagarkarsiddhi6540]

Please help can't able to find video

[@mshark5455]

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?

[@rociocarrionrabanal1121]

I see a lot of videos about forms. Does anybody has videos about how to do reports and trends in this app?

[@ShanesCows]

This Build Power BI Style Reporting with Just Power Apps | Create Beautiful Reports Easily kzbin.info/www/bejne/jYepn3aOrbpjpcU

[@ShanesCows]

Or this PowerApps Charts - Plus learn to shape and summarize the data kzbin.info/www/bejne/mGnMq2SXp5Z8aqc

[@catgrudzinski5494]

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

[@ShanesCows]

Glad to help Cat. 😀

[@BeckyGribble]

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!

[@ShanesCows]

Set the OnSuccess to ViewForm(form2)

[@stevenned23]

@@ShanesCows The button has no OnSucces option. When I do it in the form. This is not working. So how to move on?

[@ShanesCows]

@@stevenned23 Steven OnSuccess is on the form, not on the button. 😀

[@vengkateshr7290]

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.

[@ShanesCows]

Set the default of the Dropdown to be the radio.selected

[@vengkateshr7290]

We tried doing that Shane but it's throwing an red error under radio.selected

[@vengkateshr7290]

Could you please help us

[@techwalaexperttalent]

Sir Need Help if SubmitForm(Form1) its Submit Data. After That whenever I submit this form again its show Empty Data Even I Change setting DefaultMode Edit TO New ? Kindly Help Me If Anyone Understand This Schenerio

[@craigschulz948]

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?

[@ShanesCows]

Select the form, click on Fields on the right pane, and then add Field In the menu

[@SmartChosk]

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?

[@ShanesCows]

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.

[@Labrie9243]

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!

[@jansandefjord]

Hi Shane! Norway here, thank you for exciting videos! this formula "If (Form1.DisplayMode = DisplayMode.Edit,true, false)" will not work on my cansel button. In the norwegian versjon of power app we have to use ; insted of comma. Problem solve :)

[@ShanesCows]

Nice work 😎

[@onalem-6810]

Hi Sir Shane just a dumb question I have created a form where US folks are submitting their inputs, if they putted a date of 5/22/2019 from the datetime picker, if I view their inputs which i am here in the Philippines; it shows 5/23/2019 from my end. I think there is something to do with datetime picker settings it only gives loc and utc option. Goal is if us folks inputted 5/22/2019 then from my end it should be 5/22/2019 also, my system cannot be change into us datetime because i am using other tools that dpends on my system datetime manila.

[@ShanesCows]

I would store the date as text that way you are no longer affected by UTC conversion.

[@_jViTTi]

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?

[@ShanesCows]

Hi John - In the OnSuccess property of your form Set the variable again. SOmething like Set(varRecord, FormName.LastSubmit) will probably work. :)

[@sergioterrazas97]

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.

[@ShanesCows]

In the OnSucces our the form into view mode and make sure the items property reflects the record you want to show

[@Nash3.0]

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

[@ShanesCows]

Awesome!

[@rajkumarrajan8059]

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

[@eminentsocialist2720]

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 ?

[@helenagerhardt4682]

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?

[@ShanesCows]

It should work if you set the mode properly and the item based on the item you just created. Try formname.lastsubmit

[@yvetteprice4098]

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?

[@ShanesCows]

SubmitForm(Form1) Then on the OnSuccess property of Form1 set ViewForm(Form1) 😀

[@manishajha8146]

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 ?

[@workaholic7880]

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

[@ShanesCows]

You need to do a lookup to get the data from sql.

[@chukkeycheese]

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

[@ShanesCows]

Click add fields and you should be able to add it

[@JoshCanahan]

Hi Shane, i followed the steps forcreate a sabe or submit buttom , but when i edit the form and tried to save it appears an error what says : powerapp existen conflictos con los cambios del servidor.etag mismatch , do you know something for fix it?

[@ShanesCows]

Not sure. 😑 I would try with a simple list and see if you have the same issue.

[@skyebabi7040]

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?

[@ShanesCows]

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.

[@wpryan02358]

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

[@ShanesCows]

Sorry William. 😬 Hopefully you get used to it.

[@uncleslapslap]

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!

[@ShanesCows]

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.

[@andrejam8939]

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?

[@ShanesCows]

See if this helps. kzbin.info/www/bejne/eJLHm2aViZ2td9k

[@carolevandenberg1474]

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?

[@ShanesCows]

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.

[@vmili8589]

Hi Shane! Excellent video on PowerApps. I appreciate it. Could you please show us how to make an audit application using forms?

[@ShanesCows]

Noted. Thanks

[@snuggles4eva]

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]

Phil try this video series. It shows relationships kzbin.info/www/bejne/rpjdn55qjdGDedE I think Part 2 is exactly what you want.

[@snuggles4eva]

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

[@snuggles4eva]

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

[@snuggles4eva]

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

[@anthonytheriot6272]

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?

[@ShanesCows]

You can copy and paste between two apps. So maybe you could cut down on some of the rework.

[@raz763]

Hi Shane Excellent video on PowerApps. I appreciate it. Thank for the video Can do a video on PowerApp and PowerAutomate or Flow.

[@ShanesCows]

I have a lot of power apps and flow videos.

[@ToMonkey]

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,

[@ShanesCows]

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.

[@carlad3969]

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

[@srvdhar]

Your Videos are awesome. It helped me develop an Inter Departmental App, which reduced lot of back and forth communication. Thank you.

[@ShanesCows]

Cool 😎

[@q.d.3.143]

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.

[@ShanesCows]

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

[@gerrion25]

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!

[@ShanesCows]

Awesome 😎

[@leanneellis4058]

I laughed wholeheartedly at some point in this. Good job for bringing the humour

[@breloli]

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!

[@ShanesCows]

The star shows when the required property for the card is set to true. Errors... I do need to cover those better. 😀

[@TheRawalsagar]

Really good work, Shane never fails. What if I want to alter "Fill" property of Item selected in edit mode.

[@ShanesCows]

Put an If formula in the Fill property

[@bluebirdbussales2196]

You are the man! Another problem solved by the power of KZbin!!

[@ShanesCows]

Glad it helped.

[@trashgolfer]

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.

[@ShanesCows]

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.

[@caseysmith2518]

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?

[@ShanesCows]

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.

[@JeseNavar]

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

[@ShanesCows]

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.

[@JeseNavar]

@@ShanesCows Essentially using Patch right? to do that. THANKS

[@gabrielramos3174]

Good morning, I'm from Brazil and I'm developing an application that when taking a photo appears the date and time in the photo, but I can not do it in the powerapps, please help me!

[@ShanesCows]

You would have to overlay the label with the info on the image. Powerapps doesn’t have a way to merge the image.

[@andreschato]

Man, you have to stop bullying poor Greg.

[@ShanesCows]

He agrees. 😂 He has been my friend for 20 years and isn’t in tech at all. He tells his friends he is KZbin famous. 😊

[@ShanesCows]

I texted Greg a screenshot of what you wrote and he wrote back. “Thanks for making me you tube famous” 😂

[@thristanvasquez4882]

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

[@ShanesCows]

It is on the list for sure. 😀 Specific things or questions?

[@ericschmitt5772]

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.

[@ShanesCows]

Interesting. Email me and I will look at this Monday. Great question I don’t want to forget.

[@monikamahajan997]

Hi, can we add edit custom form using powerapps, apart from three basic form

[@jimmysteele1966]

Chewy. As in Chewbacca?

[@ShanesCows]

He does make Wookie like sounds. 🐶

[@kanishkaroychowdhury4050]

awesome... if i want to place the form in another screen and open it in view mode by default how to do it plz?

[@ShanesCows]

Maybe this will help? kzbin.info/www/bejne/n5fCnnl_m85ohq8

[@johanynavarro8065]

YOU ARE A LEGEND..... YOU ARE A FU**** LEGEND many thanks

[@akbarmahfuzalam]

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

[@ShanesCows]

Maybe this kzbin.info/www/bejne/hGmniKmJbLVsotk

[@nickchapman7562]

Hi Shane, Not sure where i am going wrong but the first time the form loads its in view mode, if i then click my edit icon, the form enters edit mode, as expected :-) But.... when i then re load the form it stays in edit mode?? Any suggestions Thanks Nick

[@ShanesCows]

Have your reload button set it back to View.

[@nickchapman7562]

Thank you, I did sort this, I think the issue was only in the powerapps preview??

[@hedegaard82]

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?

[@ShanesCows]

I don’t know what is fluid grid. Any hints?

[@joelpumarola2556]

Hi Shane, great vídeo presentation, i’ve been watching your vídeos since a few months, and they always help me. But I have a problema, that I can’t solve and I don’t find it in your vídeos. I have a Form connect it with 2 SharePoint Lists. One of this List is the “Employees” List, and the other is the “Production” of this employees. I would to Save the registers of the Production, therefore the DataSource of this Form is “Production”. But for the dropdown of the “Employeer’s Name” have to consult the “Employees” list, because I can have a new employee today, and I can’t to show de distincts employees of the Production List. Can you understand my problem? How can I solve it? Thanks !!!!,

[@ShanesCows]

I think I replied to your other comment

[@niitajay6]

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

[@ShanesCows]

Glad it helped. Build your app in baby pieces to make it easier.

[@ankurrai434]

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

[@ShanesCows]

Use the ViewForm function to set the mode

[@ankurrai434]

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/

[@andrewbulle4420]

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?

[@ShanesCows]

Not sure. I haven ran into that. Please post back if you get it sorted.

[@andrewbulle4420]

@@ShanesCows Will do

[@YoonWhayChong]

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!

[@ShanesCows]

Great!

[@jaggyjut]

Thanks Shane. Wouldnt the Reset button be a better option than Cancel?

[@ShanesCows]

Sure. What ever works best for you.