Intro to the PowerApps If Statement

[@AdiCristea]

Wow! When I saw there's a video about "IF" thought it's going to take like 5-7 minutes. Boom, 28! Then I was thinking "let's just watch it, but it's going to be a waste of time as I know my IFs". Wrooong, blown away by the "nested ifs". And I'm just at the 13th minute. Who knows what comes next. Apologies, master Young, doubt you again never I will... Edit: And I've also learnt about PowerApps being mad when a variable is defined differently somewhere else. Answers some of my questions I had in the past... Thank you!

[@ShanesCows]

Thank you for sharing the journey. These videos are scary to make because I don’t want to be boring but sometimes back to the basics pays off.

[@magnificoting8591]

Hi Shane, I really appreciate your videos. I found myself enjoying while learning. I love the tone, the mood and the energy you gave through all of your videos. You are awesome, good job!

[@ShanesCows]

Thank you for the kind message. :)

[@myronhodge2806]

Shane, thanks for the video. Your video on developing a simple quiz helped me solve a problem I've been working on for weeks.

[@ShanesCows]

Glad it helped!

[@vmarr0y0]

Shane, you sir are a rockstar! Your explanations are always easily understood. Hat's off to you!

[@ShanesCows]

☺️ Thanks

[@wytv6201]

Shane, I just want to say thanks that first 13 minutes completely set my validation issues in order your videos are awesome, every time I see you are doing a segment on an MS webinar I am there (provided I can make it) keep them coming.

[@ShanesCows]

Awesome. Glad to help. 😀

[@jeanpierreragequit1726]

Shane...u know what ? U r the best. I am a new beginner in powerapp and i have to digitalise some works. U saved me

[@ShanesCows]

Awesome, thanks for the kind words.

[@popsathena1981]

To your last question; "should I do more videos like this where a specific function is the subject" ... I'd say "yes". I knew all about "if" prior to this but would love to see your take on other functions as well. Great Job & Thanks Again!

[@ShanesCows]

Great feedback. What function you got in mind? 😀

[@popsathena1981]

Honestly ... you do such a great job that it almost doesn't matter. The only thing that's still bugging me about Flow & Power-Apps is the Date-Diff thing because most of our RFI/RFW apps show a column for "Days Til Due" that needs to update daily. I'm pretty sure that's a scheduled Flow thing ... but it's pretty sketchy (I haven't looked in the last few weeks but haven't seen a Date-Diff function in Flow yet.) ... cont.->

[@popsathena1981]

The PowerApps thing that I'd like to see more of is graphs and charts ... (and I'll be dead-honest; I'm being super-lazy in suggesting this because I've barely looked at the "Budget Tracker" sample app but it looks cool and I want to see more. I'm going to try to do this with a SharePoint list as a data source. I'm also going to try to manipulate the graph to show information in different ways (it's a pie chart showing individual expenses ... but I would want to look at a chart that goes by expense type as well.

[@sallyjjdavis]

This video is very helpful. I have been able to create an 'If' to make a field visible when 'Yes' is selected. A big win for my client! Thank you!

[@ShanesCows]

Awesome!

[@jonnydrake8445]

I need this!! Help please!! :)

[@lizettebeard1757]

Hi Shane, I'm all new on O365 and love your videos as you make it so easy to understand. Keep it going you are making my life so much easier.

[@ShanesCows]

Glad to help.

[@kamilj]

love this, first helpfull video I stumbled upon in this matter. Keep it up!

[@ShanesCows]

Glad it helped. :) I have over 500 videos so I am sure I have plenty more that will help.

[@billkuhn9886]

Great content. Great comic relief spread throughout as well. Most SharePoint tutorials are as dry as cardboard, but not yours - I love that about your videos. I get a huge 2 for 1 bonus (good content and a bit of humor as well) when watching which seriously helps break up the monotony that can come from a life in IT, which ultimately helps me stay interested and learn more.

[@ShanesCows]

Awe shucks. ☺️

[@swapnabendi234]

Thanks Shane for a simple yet effective "If Statement" Video. I would request you for some more Powerapps Functions videos.

[@ShanesCows]

Sure thing! I have 97 Power Apps videos and counting. If you are looking for it there is a good chance I have covered it. 😁

[@karenshortridge1143]

This is extremely helpful! Please do more in-depth training like this!

[@ShanesCows]

Almost 100 power apps videos to help your or full classes at training.powerapps911.com

[@dannielleszuba5699]

Hey Shane, love the vid definitely like the function deep dives. Would love to see more

[@ShanesCows]

Glad to hear it. I just launched another one this week. :) kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@Killernougat]

hey mate! for me, you are basically the god of power apps. Very good videos!! one thing, what would be really nice: 2/3 minute videos on functions, in addition to the long lasting once. Best regards Manu

[@ShanesCows]

I agree. One day I am going to figure out to make this idea work. 😀

[@KartikChainani]

Hey Shane! Question for you... I have a data card that I only want visible if certain values in another data card are selected. I was able to do this with one: If(FormsNeededValue.Selected.Value="Form 5471", true, false) But I have 5 other forms ("Form 5472," etc.) that should also make this visible when selected. Is there a way to make this rule for multiple values? I tried: If(FormsNeededValue.Selected.Value="Form 5471", "Form 5472", true, false) but it won't work. I appreciate your videos!

[@janicemendoza376]

Thanks Shane for your videos! Super helpful! Can you also show how to remove a choice from a dropdown depending on a text field value for example? Thanks in advance!

[@ShanesCows]

Your dropdown has an Items property that wants a table. That table could be Filtered to remove the items. This video on dropdowns and cascading should help kzbin.info/www/bejne/iXywqJSvm8SWq68

[@pipcampbell6274]

Thanks Shane- great video. Learning heaps from you at the moment!

[@ShanesCows]

Awesome 😎

[@innovationteam7029]

Thanks Shane! This is EXACTLY what I've been looking for.

[@ShanesCows]

Cool! 😎

[@AussieRiz91]

Thanks Shane, exactly what I was looking

[@ShanesCows]

Awesome 🤩

[@KyleZiber]

Great video for beginners with PowerApps!

[@ShanesCows]

Appreciate that Kyle 😎

[@RickSmythe]

Shane, Your videos are awesome. I am trying to set up a nested if where I am selecting values from a combo box and which would then filter results in a separate dropdown. is this possible? For example in the combobox if 1 or 2 or 3 is selected then the dropdown box would only display X, Y, and Z. also if the combo box selected values are 3,4,5 then the dropdown would display only A,B, and C I have been trying to figure this out for days and have made no progress.

[@ShanesCows]

Use Or if(Dropdown.selected.field = 1 Or Dropdown.selected.field = 2 Or Dropdown.selected.field = 3, filter(datasource, logic), filter(datasource, other logic))

[@tobietravis5142]

Shane, muchas gracias! I've been trying to figure out how to link a parent list item to one of its child list items and this video has given me some great ideas on ways to make that happen.

[@ShanesCows]

You are welcome Mary Lou - You might also check this video out. Even if you aren't using SharePoint it gets into the parent/child relationships deeper. kzbin.info/www/bejne/amTInJ1rgtGBgLc

[@AndrewMcDonald123]

Awesome videos Shane! I notice many of your videos are a year or 2 old now. Are you planning to do more showing some of the newest features? I like your style. You make developing a Power App fun.

[@ShanesCows]

I make one almost every week. It sure if I will go back and redo the older ones. The ui has changed but for the most part the fundamentals haven’t. 🤔 Thanks for the kind words. 😻

[@fernandokhounphithach3551]

Is there anyway to get the if statement to navigate to a different screen depending on the gallery.selected column?

[@ShanesCows]

Yes. If(gallery.selected.value = “chewy”, navigate(dog screen), navigate(cat screen))

[@fernandokhounphithach3551]

@@ShanesCows i figured it out already, but still need to figure out a way to print qr code. Any printer advice? Thanks

[@Pewwxx]

Hi shane, i need a little help, i'm starting to work with powerapps and "programming". I need help for a problem: i make a text input(lets consider "a" input), and a text label (the "b"). I want to make that "a" input be verify by the "b" label, and if the user put, for example, Box 01, i want the "b" label show a pre-definided string, like the max value that box could have. Example: User put Box 01 on text input ("a"). Then the text label with virify if user put Box 01, and than will show, of a predeterminated text string, 1.900,00. ("a")Box 01 ("b")1.900,00 Can you help me with that?

[@ShanesCows]

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

[@Pewwxx]

@@ShanesCows tnkx

[@MikeDobson2680]

Thanks Shane, was having problems with multiple true functions.

[@ShanesCows]

Glad to help Mike. 😀

[@nihar4713]

brilliant lecture, enjoyed it as a beginner

[@ShanesCows]

Glad you enjoyed it!

[@Rahulkoundalvlogs]

Hey, Thanks for the video. I am developing an app wherein I have 4 questions on a screen, with Yes or No dropdown option for answers. I wish to activate navigation button to next screen only when ALL 4 questions have "Yes" as an answer. I am able to enable control for one question with command "If(DataCardValue13.Selected.Value="Yes",DisplayMode.Edit,Disabled)" but unable to add balance 3 question validation to it. Can you help on it?

[@marcoschade352]

Hi, What if you have multiple values and you want the all to be true for something to appen? So let's say you have 4 toggles and you want the last one to automatically turn true when the first three are true. How would you do that?

[@ShanesCows]

You have to set the default for the fourth to toggle to be an if. Something like: if(toggle1. Value And toggle2.value And toggle3.value, true, false)

[@amzaralif57]

Hi mr Young, i want to ask. If i have many checklist. How do i navigate into different screen?

[@ShanesCows]

You can have a button with Navigate(ScreenName) and let them use that button to move to the next screen.

[@sidneyerickson5951]

Very nice, easy to follow video. Keep it up!

[@ShanesCows]

Thank you.

[@geraldinethuet5231]

Hi Shane,What if you have a Dropdown Menu with Multi Select Option, and you want a Little Smiley to be Green if every items of the Dropdown menu are Selected... What would be the formula, or trick to do this? Thank you so much!!

[@ShanesCows]

I think you have to do an if that checked that all the possible values were selected.

[@geraldinethuet5231]

Thank you so much! and thank you for your Videos, that help so much! Have a nice day.

[@aronclarke7230]

Hi Shane, really useful video. I am a bit of a novice when using Powerapps and your videos have really helped. I do have a question, I have a form which has 20 dropdowns to say in "progress", "complete", "cancelled". I also have an overall status dropdown. I tried using the "IF" formula in the video where if "cancelled" is selected in the overall status dropdown, it automatically then puts all the other dropdowns to "cancelled" option. My formula does not do anything and when I tried creating rules when doing the action part, I can not select a dropdown to select the "cancelled" option? what are your thoughts or recommendations?

[@ShanesCows]

Your first idea of Cancelled was correct. Maybe you just missed some owing your syntax?

[@bethlyannecastro4989]

thank you for your explanation. would like to ask, is this a valid syntax? if (child is not empty, patch(child); if(child no error); patch(parent);, patch(only parent))

[@ShanesCows]

In my head that makes sense.

[@bethlyannecastro4989]

@@ShanesCows thanks!

[@bethlyannecastro4989]

@@ShanesCows do you have any videos regarding how to prevent duplicates in submit button?

[@peterspencer7317]

Hi Shane, I am new to this Power App concept. I don't have a computer background, but i am learning by watching your training videos (heaps of thanks to these) I have a question. I have an app linked to a SharePoint list. what i am trying to do is on the dropdown if you select "NO" you can mover to the next section, if you select "YES" it goes to and series of questions. Formula is If( DataCardValue10.Selected.Value = "NO", false, Navigate(EditScreen2,ScreenTransition.None); DataCardValue10.Selected.Value = "YES", true, Navigate(EditScreen_2,ScreenTransition.None)) The trouble I have when tested I cannot select either YES or NO and it defaults to the NO value, any suggestions

[@kamozzi1]

HI Shane, nice video. Can you please advise on multiple if statements. I have 15 toggle controls and if user selects any toggle to No, display a input control. I can do one but need your advise on how to collate them so if there are multiple Nos, it only shows one inputtext control. please advise? If( Toggle1.Value = false,true,false) works for one toggle.

[@aivyvitanzos]

How to validate if value in table column is empty? IsBlank is used for expression but not on the table itself. I tried to use the IsEmpty but nothing happens. For example, if table.column for a certain record is empty or null, the result is error message.

[@ShanesCows]

I think you need to lookup the record and check if that field IsBlank.

[@brianbarnetteastbaytechnol8028]

How would you create an if statement for a submit button to be disabled when then current time is outside of a M-F 8am-5pm timeframe?

[@ShanesCows]

kzbin.info/www/bejne/f6fEoXypd8eAY7c That video should get you moving in the right direction.

[@hiattech]

I have an app I'm building for parts inventory. there's an "In stock" with a plus and minus button with the quantity showing in the middle and "in exchange" with a plus and minus button with the quantity amount showing in the middle. I'm trying to set it up so if there is, for example, 1 part in stock but it needs to go in for exchange, I can click the plus on "In exchange" and it will subtract one from in stock and add one to in exchange. If there are 0 in stock, it will simply add one to exchange (or possibly provide an error instead saying they have none to exchange). Same goes for the other way around. When an item comes back from exchange, we can hit the plus for in stock and it subtracts one from in exchange. If there are none in exchange, it will still add one. I can't seem to get it to work right. It doesn't like how I'm selecting the field to look at. I simply want it to look at the field and, if the amount is greater than or equal to 1, it will subtract one from stock and add one to exchange. Here's what I'm putting in. Thoughts? It throws an error about the colon on the 2nd line. if I remove it and put a semicolon it says DtlsInStockAmount is supposed to be a number. What am I missing? If( Description: DtlsInStockAmount

[@ShanesCows]

Try Value(DtIsInStockAmount.Text) every where you use the field.

[@hiattech]

@@ShanesCows Sweet! that did the trick. thanks! Side note, I sent you an email a few weeks back in regards to your response to another video but I haven't heard back. Figured you were busy with the holidays and class you were teaching but wondered if you had time to check it?

[@Pingki512]

Hi Shane, great video. I was wondering if you could provide guidance on how you can do an if statement for if XXX value in drop down is selected, update a string into a textbox field. Simulating the concept of an email template or a document template.

[@ShanesCows]

Use the OnChange property of the dropdown to set a variable. Have the text box display the variable.

[@chadhastie2598]

Hi Shane, First I want to thank you for all your videos! They have helped me many times! I have an IF statement that I'm working on that I'm struggling with a bit. I have approximately 30 different "checkboxes" that if one or more is checked, then I want to navigate to a specific screen if none are checked, then it needs to navigate to a completely different screen. Should I group those checkboxes or should I list each one individually?

[@ShanesCows]

Probably individual and then write a big if.

[@jonnydrake8445]

Hi Shane, Thanks for the videos they are great. I have a question about this... so in my App I have a dropdown list of contracts that start between A-O and another list underneath that has contracts starting with P-Z. I want to add something in, maybe a label that says does your contract fall between A-O or P-Z.. then have an A-O button & a P-Z button underneath. If the user selects the A-O button, only the A-O Dropdown list will show and vice versa if the P-Z button is selected. Can this be done and if so is it through using the IF function? Please help :)

[@thandarlanehappybar4051]

Thank You Shane. It is very useful for me. :)

[@ShanesCows]

Glad to hear that!

[@hossam7761]

Thank you for thet its give me an idea.. Is it possible to ues if statement on 2 drop down list it depends on what you choose at the first and show limit data on thee other dropdown ? (connecting to data source). I hope you got what I meant am new

[@ShanesCows]

Look for my video on cascading Dropdowns 😀

[@chubbydawme]

I have a custom app where a person is required to type their name in a text input field that is blank. I have a Continue button that will navigate to the next screen only if the person types their name in the name text input field (that is, the input field is not blank). When pressed, the Continue button will check if the text input field is empty. If it's not, the form navigates to the next screen. If the name text input field is blank, then the form does not navigate to the next screen and a hidden label with the warning "Please enter your name" is displayed. I've read up about the UpdateContext but I'm not successful :-( Help!

[@ShanesCows]

This video should help PowerApps Conditional Formatting and Popups kzbin.info/www/bejne/f6fEoXypd8eAY7c

[@chairattangthong]

Thank you so much Teacher, you are the best...

[@ShanesCows]

You are welcome!

[@vvaassaanntthh]

Hi Shane, I just subscribed to your channel, as I find this useful. I did have one question though. Hi, iam struggling to connect my power app to an excel file that resides in a folder inside a SharePoint document Library. When choosing data source, i can only connect to a list, but NOT a folder inside a document library. Any pointers would be appreciated.

[@ShanesCows]

Thanks for the subscribe. I answered this question in your other post. :)

[@vvaassaanntthh]

@@ShanesCows I also have another issue I am stuck with, and this is regarding a "If" Statement that controls visiblity of a checkbox. in my SharePoint list (named "Reps for FLSMs"), I have a column called "HOS BUH Email" that is basically a column containing second level Approver email addresses. I have a checkbox "Select All" which should ONLY display when the logged in user is the same as one of the users in that "HOS" column above. so in the "visible" property of the checkbox, I provide this formula (which I think is correct), but it doesn't seem to work. I ve tried so much but no luck. can you help me identify what's wrong with this statement below? If('Reps for FLSMs'.'HOS BUH Email'=User().Email,true,false)

[@butterz5876]

Hi Shane, really useful videos! I'm currently developing the Shoutouts app for my organisation, however it's coming up with an error for not finding user's ID photos. I think it needs some kind of IsBlank statement but can't work out how to implement it?

[@ShanesCows]

What is your code for the images and what control are you using it in?

[@steventurnbull9925]

Thanks Shane, great video, but can you exaplin how you would have multiple conditions like, If(Colour=Red And Shape=Square And House=Mine Or House=Yours, Do something on true, do something on false); How do you construct an If like this?

[@ShanesCows]

That looks correct at first glance actually

[@erangaaw2542]

Hi nice video. I have a question based on VBA. I created an email sender through VBA to send emails via outlook by clicking a command button. Is there anyway I can make this program like an installer so others can use it ? Or any other idea with power apps for this ? Thanks

[@ShanesCows]

So do you want to create a button in Outlook that opens a PowerApps app? Is that the question?

[@erangaaw2542]

Shane Young hi .. Thanks . No. I have the program designed in excel so when I click command button the email is sent via outlook. So I want to make it look like a platform/ app .. Like when I click icon on desktop , that program will open kind of a thing. So basically where someone else can install it to there computer

[@ShanesCows]

PowerApps only run in the browser or the PowerApps client. So I don’t think you can do what you want.

[@erangaaw2542]

Shane Young thanks. Isnt there anything like excel IRT ? I saw a video but no idea where to get it. Its like to compile

[@ShanesCows]

What is IRT? Sorry.

[@magdeabdullah705]

Man u help me alot thank you ur the best

[@ShanesCows]

Happy to help

[@mikelomax4509]

I have SP List with Title and Acronym. I also have a ComboBox that allows selection of Title. If the ComboBox has a selected value, If(!IsEmpty('ComboBox1'),Concatenate('ComboBox1'.Selected.'Acronym',"-")), in a Text box, returns the acronym followed by dash (ie: "mpl-") which is what I want. However if Title is not selected, just a dash is returned but I want nothing returned. It seems like If is interpreting ,"-" as the else portion of the if statement in this case. I have tried putting parenthesis around the full Concatenate with same result. I have tried adding an if of Blank() with same result. I have also added both the parenthesis and else Blank() with same result. How can I get an empty value if ComboBox1 does not have a selected value? Also, YES keep doing these. They are very helpful.

[@ShanesCows]

IsBlank(Combobox1.Selected) might work better

[@alcado253]

Hi Shane, First thank you for your awesome tutorials. However I need your help to solve an issue concerning if function. I've created an app which allows an auditor to add compressed air leaks (location, description) of the factory to a collection being offline. Then, when he grab an internet connection, a button permit him to upload those leaks to an Excel database stored on the factory's buisiness drive. There are hundreds of records to upload so the process is quite long but it doesn't matter. The problem is that if during the upload, the internet connection crashes, all the leaks not uploaded are lost ! To avoid this to happen I putted the remove function in an if(Connection.Connected, remove(collection, last record uploaded). But the condition is only checked once when the upload button is actionned so when connection cut off the collect function stops while the remove function keep running. How, without using a timer, can I force the condition to be checked each time a leak is uploaded ? Thank you again. A.Cadoret

[@ShanesCows]

Yikes. A couple of things to consider. Excel is a terrible data source. Azure SQL would be my vote. Secondly, no clue on the upload processing. Sorry.

[@karthikramadurai5067]

How to use If statement with Search. I am trying to search a value in excel and make the visibility of a button if the value is present in that column.

[@ShanesCows]

Do a lookup to that column. If you LookUp IsBlank then the value is not in the column.

[@bavajijhon8737]

Hi shane, How to set value based on drop down selected value

[@ShanesCows]

Set(varChewy, Dropdown.selected.columnname)

[@patriciomartinez2047]

Hi, I have a TextInput Field called "P8_2_TextInput_CalculoVSMuestra", at another TextInput Field called "P8_4_TextInput_Recomendacion" I´ll expected that put a Green message "REPLANTE" when condition will be true but I received an error (The If statement is If(Value({P8_2_TextInput_CalculoVSMuestra

[@ShanesCows]

If(value(p8.text)

[@patriciomartinez2047]

Excellent only was the position of closing parenthesis

[@ShanesCows]

Glad you got it.

[@rajaniranganath5394]

what if we want to write if statement for two different controls on one common control.?

[@ShanesCows]

You can use the And operator to do multiple comparisons.

[@practicalpowerapps]

Hi Shane, First time watching - very well explained - looking forward to deep dive. One question - what is the syntax for an if statement to test the value of a Boolean field (or yes/no as SharePoint describes it) on the screen. I am trying to make sure another field is completed (isBlank works) if this field is switched to Yes/True. Thanks

[@ShanesCows]

If(field = true, “true”, “false”). Lower case is the key

[@marcoschade352]

Great Video. But i can't seem to get my IF formular to spit out a number value, even though all the inputs in the formular is numbers. Can you help? This is how it looks: If('Tid i alt for asfaltudlægning'>'Tid for en omgang';'Udlægningshastighed meter/min'*60*'Udlægningsbredde i meter'*('Belægningstykkelse kg/m2'/1000)/'Lastkapacitet ton/bil'*('Tid for en omgang'/60);RoundUp('Antal læs i alt'))

[@alexwilliams8347]

Great job, Not just for your technical ability but also your ease of delivery, Please keep the videos coming. I have learned so much and continue to learn from you. I have an issue with a DefaultDate I could use your help on though please? If(SharePointForm1.Mode = Formmode.Edit, Parent.default, Dropdown1.Selected.Sysdate) works fine however I want to add to this If(Value(thisitem.Sysdate)

[@ShanesCows]

If(DateValue(thisitem.Sysdate)

[@alexwilliams8347]

@@ShanesCows Thank you so much for coming back to me, I overwrote the Color field with what you have posted however I am presented with 'Invalid argument type (Date), Expecting a Text value instead. Its a data type of date so I am confused by this? format is dd/mm/yy and the info is being displayed within a label.

[@alexwilliams8347]

Hi Shane, Thanks again. The only way I can get it to accept it is to use - If(Thisitem.Sysdate >=Today(),Red,Blue) sadly the condition always goes to false no matter what date is in the Sysdate column. the Today() operator is showing me 19/08/2020 and the Field Value I have is 01/01/2020 or 01/01/2021 both are false. Have tried setting date to UTC or Local makes no difference, Removed field and re-added(Refreshed) and this makes no difference. DateTimeFormat.Shortdate and Sysdate field set to date only 'Standard'. I honestly do not know what to try next? Thanks again

[@davidgermaine1076]

More! Switch would also really Help. Thanks for the vids

[@ShanesCows]

Awesome! Thank you. These are the type of comments I can action on so perfect. Switch is now on the list. If you look at my PowerApps Quiz video I demo Switch there to get you started. kzbin.info/www/bejne/iJrWhaeKmJ6Uhbs

[@davidgermaine1076]

Thank You

[@mustafahussainmohsin320]

I am kinda stuck in my if statement, can you please help me out? @Shane Young?

[@ShanesCows]

You can try posting your formula as a comment and I will try

[@JB-pi2do]

You are awesome Shane! Thanks for the outstanding videos! How do you make a data card visible when the dropdown to validate is a multi-select dropdown? e.g. 5 Employee Types with a separate data card for the total number of employees for each type--each to be visible only when selected in the multi-select dropdown.

[@ShanesCows]

Look for my video on tabs. I think it covers what you want. 😀

[@robertz.180]

Hi Shane nice tutorial! but I would like to use the "IF function" to colorize the label for a certain range of numbers. For example 80-100% the label turns green, 50-79% the label turns orange etc. My problem is that with the "If function" only texts are recognized. Thanks Robert

[@ShanesCows]

Wrap your If function in a ColorValue function. Though I am sure you can put color values inside of If.

[@androidgeeking]

Perfect. Just what I needed.

[@ShanesCows]

Glad it helped.

[@cvkealey]

Shane, I've been thoroughly enjoying your videos and putting many of the concepts to work immediately. One aspect of PowerApps that you don't seem to have hit on yet, and something that I've been struggling with, is the deployment process. I'm coming from SharePoint 2010 (on premises) and have done a ton of work with SharePoint Designer Workflows and InfoPath forms. The deployment/permissions model of SPD WF and IP forms is very different from PowerApps and Flow, so I'm looking for guidance on the "best practice" for how to deploy a PowerApps/Flow-based solution for end-users (ie: members) in a SharePoint site. I know this is a big can of worms, but if you could share some details about how PowerApps911 deploys solutions to their clients, that would be immensely helpful!

[@ShanesCows]

Hi Chad - The nice thing is once you publish the App you can then hit share and give usage permissons to the users. Then if they have the PowerApps app the app will show up for them. Or you can publish the link via SharePoint and they have access. I don't think about the deployment process much. Maybe I should but since it is a link I haven't had issues. What kind of issues are you running into?

[@cvkealey]

Well, except for a few very rough apps for internal (IT dept) use, we haven't really deployed any PowerApps. I guess the bigger question or issue I foresee is properly setting permissions on the underlying data sources. We did a LOT of SP2010 workflows with Impersonation Steps, which allowed us to roll out the associated InfoPath applications without worrying about whether end users had permissions to the lists, or having to create safeguards around them to prevent users from directly accessing & editing them (e.g., we REALLY didn't want people able to approve their own leave requests). So, really, what we're a bit anxious about is how to roll out PowerApps and Flows without that "Impersonation" function/feature which does not (and I've heard will not) exist in either.

[@RahulKumar-xj4zo]

Hey Shane I really appreciate your video , Can you please tell me how do i write 2 logical test under if statement? For eg: If (Test1&&test2,true),It's not working like this. And how to select a value from dropdown. For eg: If( Dropdown.Selected.Value=True(Which is if any value is selected under dropdown ),Dropdown.Selected.Value(Show the Selected value from dropdown).

[@ShanesCows]

If(2+2 =4 And 3+3 =6, "Correct", "Wrong") Would produce the text Correct.

[@TheAmazeer]

Hi Shane, do you know how to test 2 different conditions, let's say if(conditions1 and condition2 = true; dothisIfTrue, do this if false)...? Can't find decent examples on the Web unfortunately.. Thanks in advance... Basically I'd like to test whether 2 ckeckboxes are ticked to define the value of a textbox... Keep going with your great vids dude..

[@ShanesCows]

If(2+2=4 And 3+3=6, "They are right", "They are wrong")

[@TheAmazeer]

@@ShanesCows yes I tried this but the And operator gives me error boolean expected.. Basically what I type in the displaymode property of my checkbox_4 is : if( checkbox_1. Value And checkbox_2. Value =true;displaymode.disabled;displaymode.edit)) it keep changing color of the formula telling me something is wrong in my formula... Debugging errors in powerapps is not always an easy job.. Also if you want to do more than one action if statement is true? Can you do if 2+2=4;dothisjob;dothisotherjob because And statement doesn't work

[@ShanesCows]

If(checkbox.value And checkbox2.value, disabled, edit) is the correct syntax

[@spitfireflame]

Hi could you do a video to show how to duplicate all the datacard values in form including the values on drop-down boxes for a new record

[@ShanesCows]

Form1.LastSubmit might help. I think if you look I have a video on it.

[@MrMIOIM]

Hi , how to do If(Dropdown1.Selected.Value = '1'& & button.pressed=true, playAudio)?

[@ShanesCows]

If(Dropdown1.Selected.Value = '1'& & button.pressed=true, Set(variableToStartAudio, true) Then set the Start propery of the audio control to variableToStartAudio

[@MrMIOIM]

​@@ShanesCows Thank you for answering my question. After I set the onSelect property of the button to If(Dropdown1.Selected.Value = '1'& & button.pressed=true, Set(variableToStartAudio, true) . Then set the Start property of the audio control to variableToStartAudio. I found two errors. One is variableToStartAudio is invalid in start property of Audio. The other one is there has an unexpected character in the button. But I do not know how to solve them. What do you think? drive.google.com/open?id=1sIHRncPMXTo7-4Jz0HCqomf3Vsfn7Ve5

[@tausifjamkhandi1597]

Awesome vdo, thx shane😊

[@ShanesCows]

🙏

[@tausifjamkhandi1597]

Sir eagerly waiting for ur new vdo🙂

[@ShanesCows]

I am trying. Next one will be on Forms. 😀

[@borismatamala4611]

Dear, amazing video! Any help on how to send an email automatically if I exceed the limit of a numeric value of a text cell?

[@ShanesCows]

That I don’t know. Sorry

[@chrispaul111]

Hey, I haven't done this myself, however, if the numeric value is being stored in a cell which belongs to a SharePoint list - I think this would be achievable. Look into PowerAutomate/Flow

[@borismatamala4611]

@@chrispaul111 THE OTHER IS HOW I CAN SEND AN AUTOMATIC EMAIL WHEN AN ELEMENT IS VISIBLE

[@chrispaul111]

@@borismatamala4611 again, not too sure on exacts, but might be possible to store a value in a variable when an element becomes visible. then in power automate you would trigger a workflow when variable is filled - something to look into

[@Angel-lz4pp]

Did someone knows how i can reset a column in SharePoint custome list that's automatically increments? I've been doing some test and now I need to reset to 0 because that column is for tickets assignment purpose.

[@ShanesCows]

There is an Excel PowerApps video where I discuss how I do auto increments

[@luiz_brito]

I am trying to find a solution (How to write the is statement) on how to use the "If condition" ... If 2 values in a row of a sharepoint list exist then Navigate to a specific screen Else Navigate to another

[@michaelshelnutt3534]

You started out slow and building up, but started roller coasting towards the end... I needed steady. So still not confident about the IFs.

[@ShanesCows]

We have paid mentoring services at www.PowerApps911.com that we can provide at the exact pace you need. Sorry this video didn’t work for you.

[@michaelshelnutt3534]

@@ShanesCows Im sorry I was not clear, the video is fine, I will just have to pause more at the end whereas in the beginning I grasped. Its all good. I think my company is about to schedule a private training class with you- Im excited.

[@ivangutowski]

Thank you for the video, however I spent SOOOO long trying to get this to work. IT turns out that when PowerApps created thea pps and dropdowns for me it put everything into folder and it was the 'Data card' part of the name that I needed to enter, not just the name of the whole card (Dropdown text, dropdown everything.)

[@ShanesCows]

Glad you got it.

[@darend9074]

Ivan, I've run into a similar issue and while following Shane's example apparently I'm doing it wrong. I'm using a label to capture a 0 or 1 IF the dropdown from a CDS Option entity equals specific text, like "N/A" or "Very Good". However, I keep getting an Incompatible type error message. Your comment seems to address this issue but I'm not really sure I follow what you mean. Can you explain a bit more? Thanks. D

[@portlandmike]

Thank you! I'm hooked on PowerApps because of you! I need to have a way to confirm ID. After selecting their account, I'd like to have them enter their birth date in a field and compare to the table "Birth Date" and if they match, navigate to the next screen. Any help would be greatly appreciated.

[@ShanesCows]

This video is similar concept PowerApps Password Screen kzbin.info/www/bejne/fZqxZWp_qMRpaZY

[@portlandmike]

Thank you. I am still struggling with being able to reference the cell value from my table. Changed from DOB to the last 4 of SSN thinking I couldn't match a date to a text column. Here is the formula I am trying to use If(InputSSN.Text = (Distinct('Flu Tracker 2000',SSN)), Reset(InputSSN); Navigate(ScreenScreening , Fade), "") but it says it's not returning a true or false.

[@portlandmike]

FIGURED IT OUT! I took your advise to use a label to test for the result I was trying to use in the formula. Ended up with: If(LookUp('Flu Tracker 2000', SearchBox.Text = Last_x0020_Name, SSN) = InputSSN.Text, UpdateContext({Popup: false}) ; Reset(InputSSN) ; Navigate(ScreenScreening , Fade), Reset(InputSSN) ; UpdateContext({MessageText: "Last 4 of SNN didn't Match, try again"}))

[@ShanesCows]

Thanks for the update😀

[@MrBoiseGuy]

Wish I could Thumb ^ 50 times. Excellent stuff

[@ShanesCows]

Thank you times 50. :)

[@bhuvaneshraju4407]

hey shane,i want to know the tutorial for duplicate entry in power app

[@bhuvaneshraju4407]

All videos are so helpful ty!

[@ShanesCows]

I will see what I can do

[@clemovic]

Great Video!

[@ShanesCows]

Thank you. I am glad you like it. I was kind of nervous this one wasn’t very good.

[@RocioLopez-zz7hm]

I am still having a little difficulty updating data to the data sources when I use an IF function with variables, I guess I will watch this until I can come up with how to tackle it haha

[@ShanesCows]

Try putting the if on the outside and have different patch statements

[@alexotoous]

why doesn't if function work with Patch function

[@ShanesCows]

It should. Leave a new comment with the formula you are struggling with and I will try to help.

[@Javierzorromorales]

thank so much - excelent video

[@ShanesCows]

You are welcome.

[@muhammadfahad3441]

Shan you are amazing, One thing that every body wanted to know how can I use more than one if statements within a control property value? Doing something in the displayMode of a toggle control. If(RuleDisableActions, DisplayMode.Disabled, DisplayMode.Edit), (User().FullName=lblProcessor.Text, DisplayMode.Edit, DisplayMode.Disabled) but getting syntax error at comma (,)

[@ShanesCows]

If(RuleDisableActions And User().FullName = Processor.Text, Edit, Disabled) something like that? The Operators And Or are your friends.

[@muhammadfahad3441]

@@ShanesCows so we can't use more than one if keyword in a same property!

[@fatdjsin]

"ampersandwich" got me laughing loud :D

[@ShanesCows]

😂🐶

[@cyberpilot717]

Great help, but can you try to make more succinct videos?

[@kieranm8581]

You sound like Miles Teller :)

[@ShanesCows]

Hopefully that is a good thing. 😀

[@franziskahansen5861]

no Audio running but in all of your other Videos are running just fine… disappointed reading Subs and watching what you do is difficult :(

[@ShanesCows]

Weird. I double checked and the audio is there.

[@franziskahansen5861]

@@ShanesCows I dont know but i checked it today again and I am very happy cause it does work today... happy easter and thanks for taking the time to check

[@hesar1975]

hello Shane, great vids, just one remark, IF is not a function, it is basic language construct

[@ShanesCows]

Thanks

[@khargos7602]

Easy for me to say

[@calexv1]

How would you use an if Statement under items where you have a data source? I am working on the service desk template and the dashboard has 2 galleries.. one for the tickets and one for the gallery filter. The ticket gallery starts with an IF statements but it does not pick up the data source information while the filter gallery breaks down multiple conditions.. here is an example of ticket gallery and this just does not work.. If( type = "Tickets older than 3 days", Filter( Tickets, DateCreated datetype && DateCreated Text(Today()), DateCreated Text( DateAdd( Today(), -2 ) ), DateCreated Text( DateAdd( Today(), -1 ) ) || DateClosed datetype && DateClosed Text(Today()), DateClosed Text( DateAdd( Today(), -2 ) ), DateClosed Text( DateAdd( Today(), -1 ) ) ), If( type = "Tickets opened today", Filter( Tickets, datetype in DateCreated ), If( type = "Tickets closed today", Filter( Tickets, datetype in DateClosed ), Filter( Tickets, type in Status ) ) ) )

[@ShanesCows]

CHris nothing looks wrong at first glance. If I was you I would take everythign out and then add one Filter at a time and test. See if you can find the one that breaks things. 1. Tickets - Does it work? 2. Filter(Tickets, ...) - Does it work? 3. If(Something, TIckets, Filter(tickets,...)) - Does it work? And then just keep adding a piece at a time. :) YOu got this.

[@calexv1]

@@ShanesCows Thank You, after careful review I notice some misspellings and i did in fact i had an incorrect line in the gallery filter. Now the only filter I have been able to work but I am not getting the correct output is where I want to get tickets older then 3 days. Filter(Tickets,DateCreated datetype && DateCreated Text(Today()), DateCreated Text(DateAdd(Today(), -2)),DateCreated Text(DateAdd(Today(), -1))|| DateClosed datetype && DateClosed Text(Today()), DateClosed Text(DateAdd(Today(), -2)),DateClosed Text(DateAdd(Today(), -1))), I think the problem is in the ticket filter above, but I also have the filter gallery //ThisItem.TicketTypes = "Tickets older than 3 days", FilterGallery.Selected.TextBox1.Text = "Tickets Older than 3 Days", UpdateContext( { datetype: Text( DateAdd( Today(), -7 ) ), type: "Tickets older than 3 days" The weird thing is that I can play with the numbers, but the output is always the same and end results is that it shows all my tickets not just the ones that are 3 days old. So I am also questioning if my entire code is incorrect. Btw thanks Shane! I am a self tough powerapps user and I got to where am out by watching your videos. They are very good and had tough me a lot!

[@scottmatson3313]

Your video helped me with my issue. Unfortunately i am getting a delegation error. I will figure it out. SortByColumns( Filter( Job0013_Holiday_Gift_List, (TextInput_Search.Text in EMail || TextInput_Search.Text in First_Name || TextInput_Search.Text in Last_Name || TextInput_Search.Text in Company) && If(Radio_VIP.Selected.Value = "Yes", Segment_VIP = Radio_VIP.Selected.Value, Radio_VIP.Selected.Value = "No", Segment_VIP = Radio_VIP.Selected.Value, Radio_VIP.Selected.Value = "Both", Segment_VIP = "Yes" || Segment_VIP = "No") ), "Company", SortOrder.Ascending, "Last_Name" )