Intro to the PowerApps If Statement 

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.

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!

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!

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.

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

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.

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

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!

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

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

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!

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

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

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

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

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

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.

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

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?

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.

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

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!

Thanks Shane, exactly what I was looking

Perfect. Just what I needed.

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

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!

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.

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.

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?

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.

Great video for beginners with PowerApps!

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

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

brilliant lecture, enjoyed it as a beginner

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

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

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?

Thanks Shane, was having problems with multiple true functions.

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?

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

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

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

Man u help me alot thank you ur the best

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?

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.

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

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?

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.

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

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

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?

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

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.

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

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!

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)

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.

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!

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

Wish I could Thumb ^ 50 times. Excellent stuff

Great Video!

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

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

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.

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.

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

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?

thank so much - excelent video

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

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

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.

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

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?

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 (,)

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

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

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

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

Awesome vdo, thx shane😊

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

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

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

"ampersandwich" got me laughing loud :D

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

why doesn't if function work with Patch function

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

You sound like Miles Teller :)

Easy for me to say

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

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

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

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