PowerApps Conditional Formatting and Popups
HTML-код
- Опубликовано: 2 авг 2024
- In this video, we customize our consent form App by adding conditional formatting, variables, toggles, and even popups. Lots of cool little tricks to learn here so enjoy.
Video on creating the Consent Form and using Pen Input
• Build a consent form w...
Video on sending an email with PowerApps
• PowerApps send email w...
Video on working with PowerApps variables
• Intro to PowerApps Var...
PowerApps color codes
docs.microsoft.com/en-us/powe...
For support, training, or more information about PowerApps check out www.boldzebras.com 
Наука
Great video, lots of useful bits of info.
Thanks. What else can I cover to help you?
Shane Young I looked at trying to save pen input images into a SharePoint list in the past and it didn’t look like it could be done at the time. If that can be done now, a video on how to do it would be incredibly useful.
There is not a pretty way. This is the most recent way I came across but I have not tried. If you do let me know how it goes. community.powerapps.com/t5/General-Discussion/Pen-input-save-image-to-SharePoint/td-p/81575
Is it possible to create training video about an app for tracking activities by week for a period of four weeks?
hey Shane can u do a video to add address details dynamically & with maps to visualise the address too. #awesomeshane @boldzebras 😉
I just started working with PowerApps on Monday of this week, and I have two weeks to build a full scale app alone, and the primary reason I'm having success (and that I'm able to sleep at night instead of just going into panic mode!!) is because of all your amazing, helpful videos. Thank you so much for these!
Awesome and good luck
Dido here
Accidentally found your channel yesterday and I’m addicted. Excellent content. Thank you very much!!
Awesome! 😻 Glad it is helping and thanks for the feedback. If you have ideas for future videos let me know. -Shane
Hey Shane - I've never commented on a youtube video before, but I wanted to thank you for the work you put into each video to make them easy to follow. About a week ago I had never even seen a powerapps. Since then, I have watched every video and have built a fully customized app that is going to change the way we work in my company. Thank you again.
Thanks Taylor! That is so awesome to hear and the type of thing that keeps me making content. Be sure to let us know how things go as you build awesome apps! :)
Self explanatory video. Thank you for this.
OMG! Powerapps Teacher and Rock Star all in 1..............Thanks Shane!
Glad to help. (You made me blush)
For resetting the values once you hit the button on the popup, instead of copying the whole formula in the refresh icon, you can use the select function which can invoke the function of another button (select (refreshbutton)). Worked for me.
Yup. :) Thanks for sharing!
Very informative and useful tutorials. Thank you so much Shane.
Happy to help.
Great Videos Shane. Simple, useful and to the point.
Thanks! I use these concepts in just about every app.
Your videos are very helpful, Thank you Shane, you are the BEST!!!
Glad to help. 😀
Hello Shane. Thank you very much for your videos!
For the formula at 5:00, I preferred to use:
If(IsMatch(txtMailAdress.Text, Email), false, true) &&
If(IsBlank(txtMailAdress),false, true)
Just sharing!
Thanks for sharing. Lots of different ways to do the same stuff. 😊
amazing
Great training video. Thank you.
Hi Shane, the way you explain is awesome. Thanks
Shane you are the Power Star ! Great videos and thank you so much
Glad to help. 😀
I have enjoyed your entire series on the Consent form
Awesome!
Awesome stuff Shane, thank you
Glad it helped.
Cool :) Thanks a lot Shane. Your videos rock
Late to the party but excellent training, thanks Shane! and also to the contributors below!
Never too late. 😎
Awesome video!! I am new to Powerapps and learned a lot. Much better than Microsoft tutorials.
Thanks
Very, very nice! Thank you!
Glad to help. 😀
For the visible, I think we can define 3 virables, virable A=if(isblank(emailadress.text),0,1), Virable B=if(Ismatch(emailadress.text,email),1,0) Virable C=A*B ; then for the visible we can just use if(c=0,true,false)
I haven't watched following videos so I don't know if there're other solutions.But this is just simple enoughfor me to understand.
And thanks for your videos Shane, I'm one learning this from China, it's really hard to find something that I can follow, but hanks god you're there!
Glad to help. :)
Thanks Shane for this intuitive video. As far as logic goes, I'm just missing out one functionality. And that is to disable the email-copy if a valid email is not being entered. =) Keep the great videos coming. Greetings from Sweden.
Thank you.
Great video Shane. Thank you very much!
For the formula at 5:00, I preferred to use:
If(And(!IsBlank(EmailAddress); !IsMatch(EmailAddress.Text;Email));true;false)
It got the same results! Just sharing!
Awesome. Love it. Thank you.
Very Helpful and easy to understand
Cool. Glad it helped
Nice video. Very usefull.
I used the 'show controls' option to hide the controls on the signature box. Looks way better and you won't use colors for signatures anyway.
Thanks. And I agree Tom, hiding the controls is the way to go.
Awesome vid - LOTS of useful stuff.
Thanks 🙏
Great video brother thank you
Happy to help
Hi Shane, I was following along with you. But this Image check solution is not working anymore.
Here is the workaround which works for me (may be it helps some other viewers)
Instead of OnVisible property of screen what I did is OnSelect property of Signature input I used your formula i.e. UpdateContext({BlankImage: Signature.Image})
and then for consent button's.DisplayMode property I updated the condition
i.e. If(And(BlankImage = Signature.Image, Age >= 18, !IsBlank(Name), !IsBlank(EmailAddress)), DisplayMode.Edit, DisplayMode.Disabled)
And now it is working perfectly for my app.
great videos chief. keep up the work. I am a data engineer and they threw me on this mini app building project where I have ZILCH experience. Allowed me to make a sexy interactive form.
Awesome !
Yes! It worked for me!!
Cool
you explained concepts nice and clean. on top of it you have creative sense of humor.. Can't stop laughing at some video instances.. LOL
Glad you liked it! 😁 I try to make it not boring.
I enjoy your videos Shane! Great work. Just a comment regarding the "Visible" property of the label "* Please check your email"; I think you can simplify the formula by dropping the if() function, especially since your outcomes are 'true' or 'false'. Your And() and Or() functions should be sufficient because they return 'true' or 'false' based on the conditions; so the if(x, true, false) is overkill since x will yield either true or false by itself. Hope that helps :) And keep up the videos!
Good call Wayne. I do it and teach this more correct way these days
You can also work with "OnChange" on the PenInput field. Just set a status variable and set it to "" by reset.
I have been through about 10 ways to do this. The darn pen input control kept changing underneath me. So this is what I came up with to get through it on this video. Sadly RUclips doesn’t let me edit videos after the fact.
You rock! Thanks
Thanks 😎
Thanks
you are the best, no question :)
Thanks
You're welcome!
Brilliant :)
Thanks. :)
Thanks Shane!
Happy to help!
Shane, thank you for your tutorial(s) !!! Really helps me understand how to get forward with Powerapps. at the end of this video you ask your viewers for any ideas. Is it possible to use data in a form to fill variables in a powershell script and to run a powershell script? A little context I'm working on an app for our HR department for enrolling new empoyees. Again, Keep it UP! your video's are clear, and easy to follow!
Someone asked something similar the other day. I think you would have PowerApps write the data to a SharePoint list. Then have Flow collect the info and send it to PowerShell. I haven’t done it but in my head it is possible. This will be a video sooner than later. 😀
Thanks again!
Glad to help. 😀
Shane 谢谢
🙏
Thank you
Happy to help
For the expression at 5:00, I was able to do the same using something like this:
If(And(!IsBlank(InputEmail), !IsMatch(InputEmail_2.Text, Email)), true, false)
Not sure if it is more or less confusing than your approach. Just sharing :)
Thanks for this pair of videos, lots of useful tips.
Thank you @Kyle Drumm, your expression worked great for me.
It worked very well
Thanks Shane for this great video.Can you please make a video on filtering the datasourse on the button click.Lets say I have two buttons with text "Inprogress" and "Completed". It should filter the gallery items based upon toggling the above buttons.
I will add it to the list. Thanks!
Brilliant !
Love the avatar. What else can I cover to help you with PowerApps?
It would be great if you can do an app that can take photos and allow user to add information about it, then click submit to move them into a SharePoint list.
I've done it but it got a bit messy having to change the image into binary, and even then i couldn't get it to display properly in the list.
Thanks!!
😻
Thank you for the great Video!
I used “ If(!IsBlank(Email.Text) && !IsMatch(Email.text,Email) , true , false )” on visible property of the Error message . Error will only show if there is an entry that doesn’t match Email pattern.
Nice job! Glad you got it.
Thanks for your video Shane, Learning a lot. Thanks a ton. I have a question, where does the data from this form get stored? how to retrieve that data?
Power Apps has 300+ data sources so you can store it almost anywhere you want. Maybe this video will help ruclips.net/video/MclJ_O9HvJQ/видео.html
@Shane , great video thanks .Have been struggling with a way to close the app once the a user has submitted the form .We want to exit the PowerApp completely and close the browser tab / windows . Any ideas ?
There is an exit function but that will only close out o powerapps. Or close the browser
Hi Shane thanks for the tutorial and can you make video for for color changes as per the expiry date
Color = if(date > expiredate, red, green)
Your videos are amazing!!! Thanks for all the help!
Happy to help
Great stuff, Shane, the whole playlist is a gem!
Quick question: am I right in thinking that the Consent button will become visible even if the email address is not correctly typed in? As in the app does not check if the address is in the right form, just checks if the field is populated. If yes, how do we add that in the nested If Or/And formula, please? If no, please disregard the message except the first paragraph, the videos are awesome!
I will have to go back and look. If I didn’t show you how then for the consent button you just need to add the IfMatch function like we did for the red text. Thank you for the kind words. Shane
perfect
Awe shucks. Thanks!
Shane, First off, thank you for sharing so many great tutorials. I've watched quite a few of them while hacking away at some apps for my company. One thing which would be awesome for you to cover is how to perform a join function on SQL tables within PowerApps. This would be great. Also, are you coming to the Microsoft Business App summit in July? Thanks.
Hi Don - What are you trying to accomplish with the join? I wonder if this video would help you. Ignore that I talk about SharePoint in the video. I think the concept would be exactly the same with SQL. SharePoint was just the data source I chose. ruclips.net/video/43ekj5MlNJU/видео.html Does it help?
I'll check it out and let you know. I found an example on how to do it but your way will probably explain it more clearly. Again, appreciate the videos, keep them coming.
For Email Validation is used this formula,
If(IsBlank(EmailAddress), false, If(!IsMatch(EmailAddress.Text, Email), true, false))
Thanks for sharing
Hey Shane! awesome work mate, thank you since you've saved me from frustration many times! One quick question, my BlankImage variable equals the Signature.Image address but changes the last digit by one. Any idea why is this happening and a workaround??
Thank you again!
Signature is weird for sure. Every time I play with it I shake my head. Check and see if the Signatures Control doesn’t have any new properties for checking if it changed.
I am facing the same issue ! this is so weird, did you find a solution for it ?
I had the same issue when I added this to my already built screen, I added a new screen and just had the pen input and a couple of labels and it worked fine. I went back and added labels to show both the variable value and the pen input, the first time I navigated to the page the variable was blank but the pen input gave the image value. I navigated away and back i could see both labels showing values but variables last 2 digits was always 2 less. I added a button to run the UpdateContext manually and both values matched. Seemed like the pen input didn’t provide an image value quick enough for the variable to be updated on the first navigation, I had many other things going on the page so could be why, to fix I added a timer control to run the UpdateContext command after a few milliseconds and the values match every time I navigate to the screen and when the pen input was updated they didn’t match, which was the desired result.
Hi Shane! Great video! I wrote below condition for the "Please check your email" text's Visible attribute, which I think is a bit easier to read/write. Let me know what you think?
If(IsBlank(EmailInput), false, If(IsMatch(EmailInput.Text, Email), false, true))
Hi Shane, thanks for your video first of all, it is really helping to understand Power Apps more and more by using your guides!
I have a question about the Consent button being available when input is given into required fields. I am trying to set something up in one of my own apps, but I struggle with 1 thing.
Is it correct that you cannot use a into the IF function to check wheter this gallery is blank or has input?
I have created a gallery, like you showed in one of your video's, which will be storing different scanned items.
In my app it seems that it always has input, however I will only see the input when I play the app and scan multiple items after eachother.
Keep up the good video's !
Sorry for the delay. This video shows how you can use IsEmpty to check a gallery. ruclips.net/video/vbRdFfq5tB8/видео.html
Thank you for another great video! I made the form with this video, however, the delay is not working for me. I followed all the steps, but as soon as I get to the point to @ in my email the alert will show up.
Does anyone else has this issue?
Thank you again for all you do.
It is a goofy little setting. It works but the delay isn't long enough. You have to type pretty quick for it not to work. I would also test it not in preview and see if it works better for you.Thanks for watching!
Shane, love your videos. I have a SharePoint list that has client info. I want to count the number of days from signing until moving to the next phase. I have that down how to count the number of days from signing until today. When the status changes I want to end that and count the days in the next phase until that ends. Maybe a short video on how to do that.
David you need to add logic at each step that counts and saves days before you change the status. I would use patch function
Thanks for this! I have a 6 screen app, each team populates and saves their own page. do you have a suggestion on a popup or save confirmation to use? the streaming dots along the top do not seem to cut it? Thanks!
Katie I show a loading spinner in the video. ruclips.net/video/UWy5I_MuIgU/видео.html
Hi Shane, Thank you for sharing the videos.
Have a question regarding the context variable "BlankImage" set here to use Signature.Image value. In my case, both BlankImage and Signature.Image are having different values always, especially when loading the form for the first time. After adding values to other fields (Name, Email and Age), the consent button gets enabled even when PenInput field is not touched. Is that the expected behavior? My understanding is when the form loads for the first time, both BlankImage and Signature.Image should have same values.
I have the same issue.
Old question, but thought I'd take a crack at this for anyone new to learning Power Apps like me and going through Shane's old videos. I was running into your exact situation and was banging my head trying to figure it out. Whenever my form loads and even when I reset the form, the values for both BlankImage and Signature.Image were always different. Here was my way around this:
I set the OnSelect property of Signature to:
UpdateContext({BlankImage: Signature.Image})
By doing this, I was at least able to get both BlankImage and Signature.Image values to match.
Then I made the Consent button become available if both values matched instead. I changed the DisplayMode property of Button_Consent to:
If(And(BlankImage = Signature.Image, Age.Value>= 18, !IsBlank(Name), !IsBlank(EmailAdress.Text)),DisplayMode.Edit,DisplayMode.Disabled)
If you reset the form, BlankImage and Signature.Image values will be different. Then once you draw in the peninput area, their values will match.
I always watch your videos with pleasure and learn many things. Thanks Shane. But I think this solution is not work with PenInput in Forms. Right? I applied all you did in video but it doesnt work in my app.
Hi Shane. Your videos are awesome. How do I display a drop-down selection in Browse Gallery Section? Thanks in advance!
Do you want a drop down outside the gallery to be displayed in the gallery or have is so the gallery has drop downs.
Shane, great videos!!! I have a question, how could I show a warning pop up in power apps? I have the following scenario:
i have the following drop down field:
- Policy (PO)
- Procedures (PR)
- Work Instruction (WI)
Then I have another text field where the users enter the ID of the document which consist of XX-XX-###, the first two characters is the type of document from the drop down, so basically I want to make sure the user is entering the right information.
Ex: if the user selects Policy (PO) from the drop down and then types PR-XX-001 it will show the warning because the user should write "PO" instead of "PR"
I have tried IsMatch but it does not allow me to compare a field to another field using contain in the formula.
What is your code? You should be able to compare the two fields?
hi thanks you so much for your work great job if its possible would you mind make a serie about a sharepoint list to select a customer populate all the field when you select a customer then add the form in another sharepoint list it's an idea
what do you think about this?
Yikes that is a lot. I did do a video on SharePoint lookups that might help get you going.
Hey Shane, great video, I'm your Chinese fan, sorry for my break English, I spend 1 day to fix a powerapps problem in this video, about "If(And(blankimage= sign.Image,Age.Value >=18,IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled)" doesn't worked(variables last 2 digits was always 2 less), the correct steps should be 1.Click signature box, 2.select "Onselect" and enter "Set(blankimage, sign.Image)" then the above conditional statement can be used, In this video, it is wrong to enter Updatetext(blankimage:signature) in Screen1-Visable.😀
Your tutorials help a lot though this one still cannot implement yet to test. Can I know is this still validate correctly when user click 'cross' button on pen input control after scratching something on it and make it blank again?
I think so but it is has been a long time since i tried.
Hey Shane. For the refresh on the pop-up couldn't you just call something like button_Refresh.OnSelect that way you only have to define refresh once and call it several times.
Yes sir. You are exactly right. I figured it out a couple days too late. 😀
Hi, Shane! Thank you for the video - always helpful!
I don't know if this question contextually belongs here or if this is an idea for a future video. What I am trying to do is have a notification for when someone is trying to remove a record from the parent table (in SQL back end) and it has child records attached to it. When the back end child table FK has Delete Rule set to "No Action", it won't delete the parent record, but Power Apps doesn't really treat this event as an error, therefore my IfError(RemoveIf(Source, Notification(...))) does not work. Any ideas on how to best handle this?
Yikes! I don't. :( Sorry
Hello Shane, Thanks for such a detailed PowerApps tutorial. i have doubt if i would like to pass parameters in web URL (not in app url) and grab that in POwerapps. Is it possible? its requirement in my project. Any help would be great.
powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/
Thank you Shane for this wonderful Video, just one question. Instead of hiding the buttons for certain users who don't have the access, how can i grey out a button ? so a user cant click a button (its greyed out) if they don't have access to it instead of hiding it?
Hello Shane! Another great video! One question -> when I open my saved app on mobile, "send" button is always on edit mode (on web is working fine). And another question -> if we click on X to clean our signature, we still can send form without any signature. Can we somehow reset our variable when we click on this X button? Or do you have some workaround to workaround? :) Thank you!
You can set your variable to Blank() to clear it out. :)
Thanks for the awesome video! How can you get a popup when you are trying to delete an item in the gallery? I am unable to use "ThisItem" in the popup's button since its outside of the gallery's item
Use Gallery.Selected for the logic in the popup button :)
Appreciate the video. Our form is fairly complex, different fields depending on selection from two different dropdowns, but some fields are present on all iterations, So I just used those fields for the DisplayMode Property of our Submit button.
While I have you, I have a quick question. We have a SP form we are customizing in PowerApps. In the OnCancel Property of SP Integration, is there a way to redirect them to another SP page or maybe even another screen in PowerApps? Currently it just takes them back to the all items view of the sp list. I've tried using the Launch function, but it didn't work. Next I was going to try the Navigate function.
Any advice you can provide would be greatly appreciated!
Hey Jeremy. I haven't tried anythign clever here but I don't think I have any good guesses. Sorry
Another great video Shane. I came here looking for something else and learned 2 or 3 other things. What I was looking for is how to identify when a Patch function errors out. In my case, when users enter duplicate values in a field where I'm requiring Unique Values via a SharePoint List setting. Have you done anything on that yet? Any thoughts or suggestions? Again the scenario is, Users Click Submit (activating patch) and the patch doesn't go through because of a duplicate record. Since I'm not using SubmitForm, there's not feedback whatsoever to let them know it failed. I want a popup to tell them what the Patch error-text was and have them go fix it before re-submission
Use the Errors function. If it is empty all went well if not the error will be in the table.
Bonus I also talk about duplicates here ruclips.net/video/Ap3_Ea9H8b0/видео.html
@@ShanesCows Thank you sir
Shane Great Video... I'm going through them 1 by 1 one... my ultimate goal is to create a form that employees can enter data - that data then goes to a sharepoint list, the addition of the data to that list triggers an approval flow, and then when approved, all the info gets populated in another 'completed' list... ;-) think i'm on the right track?
Sounds perfect! I also think I have all of those pieces or close in video.
Hi Shane, your videos have been incredibly useful! I have an app that has signature boxes your method for hiding the submit box seemed to work although I had to have the variable set by an invisible timer after 1 millisecond as the onvisible didn't seem to work. Now, it doesn't work at all. When the variable is set, the blank peninput image link also changes by one or two digits so that the variable and the blank image are never the same. Any ideas what I can do?!
Sorry haven’t ran into that Sam
@@ShanesCows no worries, I think it's a fault so I should probably try and speak to Microsoft. Thanks though, my entire app is based off your videos, you've been a live saver!
Hi Shane, I love your videos, keep up the good work!
About the formula for the "Check your email" label, isn't the following good enough?
Visible = And(!IsBlank(EmailAddress), !IsMatch(EmailAddress.Text, Email))
as we only want to show the label when the user entered something that does not match the format of an email address.
Thanks again for all your videos!
Looks like that would work. :)
Hey Shane, this is another excellent video but I'm having a problem. Rather than a consent button I have a submit button. Everything works great with the popup except once I hit the Close button the app gets stuck on "Getting your data" rather than returning to a blank form. Any ideas?
Hi Shane, what a great video!! I have one little question: how could I show a banner pop up (like what's app message and others apps, who drops from the screen) in my power apps? Just for explain, I want to every time I'm near from a store, my power apps show me a pop up "You're near from Store X, do you want to visit?", even if i'm not using the app on the moment. Can i do that? Thanks for your support!
No, sorry.
I tried using this for a checkbox and an image. Tried visible, onselect, uncheck, check in both the checkbox and the popup. So if the box is checked then popup(image), if the box is uncheck then no popup(image). So far I check and it pops up so halfway there. When I uncheck popup stays. Still working on that. BTW I love the videos!
Thanks let me know if you get it figured out or need a nudge in the right direction.
Great tutorial brother. On the topic of dialogs, I've been trying to come up with a way to create a popup in a gallery, to no avail, I have a column in SharePoint for "LineNotes" that I'm using in a repeating table gallery for receiving products. The text input is too small for a multiline mode and I don't want the end users to have to squint to see the text. so I thought a popup would do nicely. Any pointers would be awesome. Thanks again.
Hmmm. You could show the gallery.selected.field in a label outside the gallery. I am not sure. Never thought about this one. 🤔
@@ShanesCows Yeah, it's a real head scratcher for me too. I'm trying another approach, I'm gonna have the visible on the Gallery set from a varible to show hide based on a dropdown from a form on the same screen as you explained in "PowerApps Hide Button Based on User and other fun" around "23:00".
@@ShanesCows My solution was to make the gallery row size kinda dynamic, I put an icon in the row with "UpdateContext" onSelect and set the text input visible to varShowNotes.
hey hey, i just did for the invisible red email textbox: If(txt_email.Color=Red;true;false) works fine for me :D
Nice job
Hey Shane! thanks for another cool video!... I have a question... In the pop up box, instead of a fixed message, can I show information from the objected selected?? For example, if I select purchase order xyz, when i click it, it shows me the information from the Comments column listed in Sharepoint?
Yes you can! Do a LookUp to get the record you want to show.
@@ShanesCows 😍 thank you so much!!
Hi shane i am navigating screen after submit.. in this case when i return the form sreen the button show edit mode ...how to do this on case
Need to use ViewForm function to set it back. Try using OnSuccess to set it
Hey Shane, I love your videos and have learned a lot. I'm definitely a novice to all of this. Anyway, dumb question. I'm trying to create an app that won't let a person in unless they've been approved. I followed your approval vid and everything works great. Now in the app I'm trying to create a condition that says they can enter IF they have been approved on the sharepoint list. How do I create a statement that refers to the sharepoint list? It seems like it should be simple but right now I want to punch my screen. Thanks, guy and keep up the generous work! You help us lost souls!
Try this video ruclips.net/video/0MB-z9cyFCQ/видео.html
@@ShanesCows Thanks dude!
Hey @@ShanesCows I ended up finding the solution in another video of yours :) ruclips.net/video/Ap3_Ea9H8b0/видео.html. Thanks again!
Hi Shane, has something changed recently with the peninput control? After resetting the input control and updating the context (to store the empty image value as JSON), for some reason the peninput image value changes (slightly), making it hard to keep track. Can you re-visit the app you demoed to see if it still works?
I will try Roy. I don’t have a lot of customer apps with pen so don’t get much practice
Hi Shane,
I'm creating a questionnaire app (data source/s are SPO lists. Multiple screens to multiple lists) with a combo box for Yes; No; or Don't Know answer choices.
Can you explain how to create a pop up for a "No" answer please?
i.e. "No" needs to have a warning pop up alongside. The message within the warning will also vary, so is just another lookup to the related SPO list. If answer is "Yes", "Don't Know" or warning message remains blank/invisible,
The questionnaire is a compliance checker where "No" = bad, therefore need to warn user.
Regards
PMD75
Hmm. I don't have the answer off the top of my head for you because I am mostly confused. :) Do you want the popup when they select no or when the hit submit if they have selected no?
The former. If the answer to question 1 is No, a box appears nearby to provide a warning.
If question 2 is Yes, it’s warning box remains invisible etc.
I guess what I need is an IF statement along the lines of:
If selected option is No, show warning box, but selected option is Yes or Don’t know, do not show.
I’ve tried using/modifying some of the statements in your videos but no joy.
Additional problem is choosing the right sort of “control selector”.
Checkbox/ radio buttons/ combo or list box.
The way I did it real quick.
* I made a dropdown control.
* Set Items to ["yes", "no", "maybe"]
* Added a popup box
* Set OnVisible to If(Dropdown1.Selected.Value = "no",true, false)
Boom! That works. Does that take care of you?
You Sir.....are a legend!
I've watched your videos on this over and over again, and I finally cracked it. (Sorry i didn't see your last reply sooner.)
I've now opted for Check Boxes for the Yes/ No/ Don't know choices and added a simple OnCheck/ OnUncheck command to show the message popup(s)....Phew!
I'd have preferred the drop down control as you have explained above, but once i've got v1 working, perhaps i'll go back and improve it.
The next challenge is to gather all the responses and display them (and a recommendation to any of the "No" answers,) on a chart/PowerBi on the final screen of this app.
For example:
Q1: Do you have any ice cream?
A: "No" (popup appears to show this is a high priority issue)
Dashboard shows pie chart(s) with responses, and alongside this "No" a recommendation ("Go buy ice cream!"). Recommendations will lookup from a sharepoint list too.
(The purpose of this app is to assess/ advise managers on legal compliance of handling personal data. Any "no's" are non compliant, and app will recommend a remedy)
I've noticed this morning that you have just posted a new video on PowerApps with a PowerBi visualisation...... Just what i need!!! ruclips.net/video/H9yYzPg0LwM/видео.html
See you over there......
Thanks for all your help.
PMD75
Shane Is there a way to have different height/width settings when using multiple screens in PowerApps?
Give this a look docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-responsive-layout
Awesome video Shane. I am trying to create a popup based on a radio button selection that gets its choices from a SharePoint list. Is this possible?
Yes. Use the OnChange of the Radio control to trigger the variable to show the pop up.
Shane,
I have a new request screen with three popups where I collect info ( when you click on popup button he open popup, user populate fields and on that page save button just hide popup ) and on same page I have one button where I patch all info from popups. I patch all forms collected though popups and I reset forms after that and navigate on requests. Problem is when I have multiple users logged and when they try to submit new request, I got info mixed from their requests and most likely overwrite data from one to other request.
do you have any recommendations where to learn more about "if" statements. I have a Power App I am working on an need to right so logic based on if the answer is "no". In my case if "no" is selected I want a some blank spaces to appear to capture text input the user needs to provide.
I have a video on If. Intro to the PowerApps If Statement ruclips.net/video/9aXP48XECDc/видео.html
In your case you want to add the inputs to the screen and only make them visible if they select No
Hi shane, one quick quest: If I put non standard email format and click form default save button then i guess form get saved, though there is error warning "invalid email format". How do i fix this?
Set the button to be disabled if the email is not valid.
can we disable default save button in share-point, how? plz see the image: ibb.co/g6NOD9 ( I dont want form to get saved if validation failed)
I figured out: for others who facing problem like me: click the data card, go to advance option and put IF condition in required validation field.
You don't need to copy the whole formula at 23:28 you can use Select to select the reset button to reduce redundancy in code.
Yeah. The Select function made it into later videos but not this one. Whoops.
Hi Shane,
when i am going to open my published apps in my phone using powerapps apps, in every app buttons are not showing in mobile. plz let me know how to resolve this issue.
Confirm you published the latest version.
Hey Shane,
While formatting our consent button it shouldnt light up when the email address entered is not valid, so here is a quick update
If(And(Blank Image Signature.Image, Age >= 18, !IsBlank(Name), IsMatch(EmailAddress.Text, Match.Email)), DisplayMode.Edit, DisplayMode.Disabled)
Keep up the good work
Hi Sean great video . I used the pop up message example when a form is submitted. Minor setback I have a unique field (checks for duplicate entries) that doesn’t work now any idea? It appears the pop up is initiating before the form data is being checked for errors. Thanks
Put the pop up formula in the OnSuccess property of the form not the button
Shane Young Thanks Shane
Hi Shane, Thanks for sharing your video, when I used powerapps form convert to pdf the form has a dynamic change logo based on the department and on HTML format how to set this variable image(logo) based on the department, means if departmen=A, image=img1, else if department =B, imgage=img2, else if deparment=C, image=img3....if you have an Idea if the condition on powerapp html develop share with me. Thanks a lot!
When you create the HTML in POwerApps you are just making text. So you could have an if statement in the middle of your HTML to send different values.
I need to create a form for user with few fields to select . they must check if the selection (of all those 4 fields ) are according to some conditions. can you advise how to start?
You need to write an if statement that checks they all match the values you want.
Great video! Save button working great, but in my app there is required fields so need to add an error handler if one or more fields not filled in as found out that with this pop up the data won't save at all if one or more of these fields is empty, but won't inform the user. It appears as though it saved as expected. Any advice on this? Thanks
Maybe disable the button till all the fields are filled in?
@@ShanesCowsthanks Shane, will try that. Would that likely mean making an if error handler to cover each of the fields, which would make a very long piece of code or is there an easier way?