PowerApps Conditional Formatting and Popups 

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 😉

Awesome and good luck

Dido here

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

Awesome! 😻 Glad it is helping and thanks for the feedback. If you have ideas for future videos let me know. -Shane

Yup. :) Thanks for sharing!

Glad to help. (You made me blush)

Thanks for sharing. Lots of different ways to do the same stuff. 😊

amazing

Happy to help.

Thanks! I use these concepts in just about every app.

Glad to help. 😀

Awesome!

Glad to help. 😀

Thank you.

Glad to help. :)

Thanks. And I agree Tom, hiding the controls is the way to go.

Glad it helped.

I will add it to the list. Thanks!

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

Never too late. 😎

Good call Wayne. I do it and teach this more correct way these days

Awesome. Love it. Thank you.

Awesome !

Power Apps has 300+ data sources so you can store it almost anywhere you want. Maybe this video will help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html

Nice job! Glad you got it.

Color = if(date > expiredate, red, green)

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 RU-vid doesn’t let me edit videos after the fact.

There is an exit function but that will only close out o powerapps. Or close the browser

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

Glad to help. 😀

Thanks 🙏

Sorry for the delay. This video shows how you can use IsEmpty to check a gallery. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-vbRdFfq5tB8.html

Glad you liked it! 😁 I try to make it not boring.

Yikes that is a lot. I did do a video on SharePoint lookups that might help get you going.

Katie I show a loading spinner in the video. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-UWy5I_MuIgU.html

I think so but it is has been a long time since i tried.

Happy to help

Do you want a drop down outside the gallery to be displayed in the gallery or have is so the gallery has drop downs.

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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.

Yes sir. You are exactly right. I figured it out a couple days too late. 😀

David you need to add logic at each step that counts and saves days before you change the status. I would use patch function

powerapps.microsoft.com/en-us/blog/powerapps-deep-linking/

Cool. Glad it helped

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!

Use Gallery.Selected for the logic in the popup button :)

Thank you @Kyle Drumm, your expression worked great for me.

It worked very well

What is your code? You should be able to compare the two fields?

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.

Yikes! I don't. :( Sorry

You can set your variable to Blank() to clear it out. :)

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.

Hey Jeremy. I haven't tried anythign clever here but I don't think I have any good guesses. Sorry

Sounds perfect! I also think I have all of those pieces or close in video.

Thanks 😎

Cool

No, sorry.

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!

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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ap3_Ea9H8b0.html

@@ShanesCows Thank you sir

Yes you can! Do a LookUp to get the record you want to show.

@@ShanesCows 😍 thank you so much!!

You're welcome!

Thanks let me know if you get it figured out or need a nudge in the right direction.

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.

Happy to help!

Need to use ViewForm function to set it back. Try using OnSuccess to set it

Looks like that would work. :)

Yes. Use the OnChange of the Radio control to trigger the variable to show the pop up.

I have a video on If. Intro to the PowerApps If Statement ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9aXP48XECDc.html In your case you want to add the inputs to the screen and only make them visible if they select No

I noticed that too. This video may help: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-EACk5jlQ_jU.html But it is also not perfect.

@@conaxlearn8566 thanks mate

I will try Roy. I don’t have a lot of customer apps with pen so don’t get much practice

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.

Confirm you published the latest version.

Give this a look docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-responsive-layout

Try this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0MB-z9cyFCQ.html

@@ShanesCows Thanks dude!

Hey @@ShanesCows I ended up finding the solution in another video of yours :) ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ap3_Ea9H8b0.html. Thanks again!

You need to write an if statement that checks they all match the values you want.

Put the pop up formula in the OnSuccess property of the form not the button

Shane Young Thanks Shane

Glad to help. 😀

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!!! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-H9yYzPg0LwM.html See you over there...... Thanks for all your help. PMD75

Look to use the Reset function instead.

Thanks for the reply Shane. Can you please help me how to achieve it using the reset function?

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?

Thanks. :)

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.

I haven’t seen that. Maybe the default value isn’t getting set?

Hmm, looks like the pen image is refreshed after the app has loaded and then the blank variable will differ from the image from the start. Maybe this is a browser problem. The app loads and the it is resized to fit the screen.

Interesting. I have done pen in a while. If I get a chance I will check. What if you use a timer to delay the load of the variable?

Shane Young Hmm, that was a smart tip. I will test with a timer😊👍

You never reference a whole control always .property

@@ShanesCows Yes, but how to differentiate or recognized, this command need to put the reference with their property and other command is just the control name, provided there is quick help on its selection as we typed. Thanks for prompt response, so cool. :)

Thanks for sharing

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.

They may have changed the sig piece. I haven’t tried it in a long time. If you take it out does it work?

Yes, you control has a property called ToolTip. Set the text to be blank if Edit mode and your message if disabled.

@@ShanesCows Thank you.