Power Apps Advanced Forms

[@oluwatobiyusuf]

Thank you, Shane. Previously, I delete the text input and bring a dropdown. Thank you for the tips

[@ShanesCows]

Glad that it helped you.

[@michelhegeraat5430]

There is also Form.Valid function to render you update button active when the form can be submitted

[@ShanesCows]

I had no idea 😳 I learned somethign new today. Thanks 🥇

[@brucem4508]

Are you saying that there’s a way to control the display mode of a button without writing the individual requirements in a formula like at either that for a switch or something?

[@michelhegeraat5430]

@@brucem4508 Yes, YourSubmitButton.DisplayMode = If(YourForm.Valid, DisplayMode.Edit, DisplayMode.Disabled) Something like this. Of course it would be so much better, if an array of field names was given of those fields where the requirements were not met.

[@varUser01]

I'm guessing this means I wasn't the only one to harass you about this at the Power Platform conference for the last couple years. 😉 Thank you very much, sir! Having this to share with new builders will make life a little easier!

[@ShanesCows]

Yeah, it was a good idea. Thanks for the nudge. 😎

[@Bekesam]

Thanks Shane!! I am torn between both methods, but I prefer Patch(). I have a more appreciation for Forms now having made custom form with Patch(). One advantage to Forms is that data cards act like containers, housing the elements for a particular field. To do the same in a Patch form, isn't too bad, but there is clearly more upfront design time. One advantage I like about Patch Forms, is not having to deal with Forms syntax. I am still torn, and sometimes the Patch form I make ends up resembling the Form feature, which for obvious reasons, I should have just used the Firm feature. I do think that this is a fundamental subject for app designers. In one sense, I wish there was no Form feature, then it makes the decision much easier. Hmmm I do think that Powerapps could invest more into the Form feature so that it would make it a clear winner. I would be up for that.

[@ShanesCows]

I like it. 🥇

[@darthxellaa912]

Thanks for all the tips! I still have alot of customers that just aren't on the Patch bandwagon yet, and still prefer forms. They have their place in Power Apps. ;)

[@ShanesCows]

I agree. I love me some Patch but Forms in the grand scheme of things are WAY more popular.

[@ytshaag]

This is awesome! Appreciate your content! I know how to do most everything shown but the validation of "am I doing this right" and alternative/better ways, is fantastic.

[@ShanesCows]

Love that!

[@dougydoe]

Great Stuff although I'm in the Patch camp. 🤣. Having said that, its good to know there are ways you can upgrade the Form control and still use it in applications. I do find using Patch with custom controls very flexible so that tends to be my default. Thanks for sharing.

[@geralddahl9159]

Great free content, much appreciated, thank you. If it is possible to insert links to related videos (either in description or via reposted video) we all are helped even more. Stay well, Shane and team.

[@ShanesCows]

There is several videos linked in this one. While watching if you look in the top right corner when I mention a video the link pops up there. Also, if you expand the description below you should see them all. 🤩

[@geralddahl9159]

Weird, I see them now on my phone, but not when I first watched on computer earlier this morning

[@ericmild4050]

Very nice video. Thanks!

[@ShanesCows]

Thank you!

[@DomiVersaix]

Hi Shane, your videos have really helped me. For some reason when I click the datacard on my form the "Items" property isn't available, can you think of a reason? Without it, I can't change the control type...

[@ShanesCows]

Forms don't have an Items property. They have an Item property, is that what you are looking for?

[@DomiVersaix]

@@ShanesCows yes! I spent hours yesterday, trying to figure it out. So if I use the modern (pink) form, I can’t change my text fields to “allowed values”?

[@golfnutt8]

Love it, thanks Shane!

[@ShanesCows]

You are welcome. Have a good day.

[@stevenned23]

Hello Shane. I learn a lot from your video. Great Work. Thanks. But I've a question. In the first 5 minute of your video you discuss how to handle a drop down with a different data source (by me a SP List) But your video is about the classic dropdon and I"m looking desperately for video how to handle this action in a Modern Form and modern dropdown. I searching for good video for two days now. What re tour ideas on this? Will there come a video with that information? Kind regards Steven from the Netherlands

[@ShanesCows]

Steven what isn't working for you? It works as I would expect. Add the SP List to the modern dropdown Items property.

[@stevenned23]

@@ShanesCows Wow that's a quit respons. More than one thing give me troubles The Update command is not working like i would expect. drpSoort (name of my dropdown) depSoort.Selectedtext. And then I expect Value.But is niet there. And all the other options I tried but don't work...... Also the default setting in the viewmode (the selected from the gallery so Parent .default) is not working. So, I think it would be time for a video where this is explained correctly. Regards Steven

[@stevenned23]

@@ShanesCows I've also the problem that when i changed it from text input to drop down. De default of the dropdown is not listed. So I tried 'DefaultSelectedItems' but that doen't work either. What or where must I fill something out to see the items in the column of the SP List connected with the Gallery and Form? Regards Steven

[@stevenned23]

@@ShanesCows Also i your video you update 'DataCartValue5' In my form it is DatcardValue1. But is missing and I can't use it in the update................. So, again tried two hours on thi sbut I really can't pass this problem. Which in my opinion should be made easy because a lot of users use this. So, Plaees please. Create a video with this using modern inputs. Regards Steven

[@rachaelarsenault7394]

Hi Shane! I just started working with Power Apps a couple of months ago as a citizen developer and frequently stumble upon your videos and they've been extremely helpful! I have a question! Regarding formatting currencies, how do you get the formatting to work on a NEW form (not just edit and view)? It doesn't seem this formula works for a NEW form: Text(Value(Parent.Default), "$#,##0.00"). Thank you!

[@rachaelarsenault7394]

So I think I've figured out a workaround. I added a label to the data card and set the X, Y, Width, and Height to match the datacardvalue text input control and set the text to Text(Value(datacardvalue.text),"$#,##0.00") and set it behind the datacardvalue text input. Next, on the OnChange property of the datacardvalue text input, I set a variable - Set(varFormat,true). Then I set the fill and text color of the datacardvalue text input to transparent if varFormat=true :D

[@bencraker]

Hi Shane. I have built a few apps that I think are pretty impressive in terms of functionality. What do you think is the best way to capture that fact and demonstrate how useful they can be? Documentation? Video tours? Other? Thanks

[@ShanesCows]

Ben it depends where you are most comfortable. Video is my style but if writing is more yours than creating a blog of them is the way to go. :) Maybe look at posting it in the Community samples? powerusers.microsoft.com/t5/Community-App-Samples/bd-p/AppFeedbackGallery

[@ubezmusic]

just about to start a brand new project next week and looking for some ways to up my form game for the client

[@ShanesCows]

Awesome! Build something cool for them. 😍

[@Deathtory]

I am looking for some help, I have 2 forms on my power app, but not each form needs to have information, but sometimes it will. Do I have to have a separate submit button for both forms or can one button work to submit both forms?

[@ShanesCows]

SubmitForm(Form1);SubmitForm(Form2) You could put that code on one button's OnSelect property. But you might want to add logic not to submit the empty form? Form.UnSaved can tell you if there are changes to save or not kzbin.info/www/bejne/hGmniKmJbLVsotk

[@ashokpershad]

Wonderful Video Shane. One question, is there any way we can make Error message in datacard show matching name of Datacardkey text? Right now the error messages are showing text as per our column names in database which is weird for users.

[@ZeyaulHoda]

Hi Shane, Can you make a form for uploading new candidate details while applying for a Job by using this all Required field which is taken from 2-3 tables with Attached resume, Image, State ID name and number, Total exp, relevant exp, last working days, Name , Number, Email, Location, Preferred location, Job Role, Job ID(lookup col), Skill ID(lookup col), Skill Name, Role Name, Current Organization, Current CTC, Expected CTC

[@mbaker82]

thank you for the video. question, can i make my power app form available to everyone without assigning them a PowerApps license? by default we provide our users a G5 license but it doesn't come with power app license. is this going to be required if we do power app form?

[@ShanesCows]

Everyone that uses a Power Apps app has to have a license. A g5 license does include a Power Apps license, did someone take it away in your configuration? But to your question, yes they all need a license assigned tot hem

[@laididee]

Have you talked about Enterprise Keywords on your channel before? I'm currently trying to figure out why the simple canvas app I created from a Sharepoint list won't let me add new keywords, even though it works just fine on Sharepoint itself.

[@ShanesCows]

I haven’t. Sorry. They have never came up with a customer so I haven’t been down that rabbit hole.

[@mike-williams]

How do I change a text field to Rich Text if the DataCard is custom?

[@ShanesCows]

Rename the Text Input to inpMike, delete the text input, ignore the errors, add Rich Text, rename it inpMike. All should be well. 🤩

[@jrvidotti]

Hey Shane, thank you very much for this video! Very helpful information. How can I do input masks in PowerApps? Lets say a phone number input or a brazilian SSN (like: 000.000.000-00).

[@ryukaizen.4561]

Hi shane where is the initial video? the one with basic forms? 😂

[@maanalshraky1]

Hi Can you please help me and show me how we con connect MySQL db ( on server not local machine) to power apps Thx

[@ShanesCows]

This video is really old but conceptually it is the same. kzbin.info/www/bejne/q6LbkJtqjtJrpMk You need to install the On premises data gateway, then add a MYSQL connection and choose Gateway, then you use the local name. Hope that helps.

[@getmighty8619]

5:51 😆😆

[@ShanesCows]

🤩