Use IsBlank and Trim to check for any empty or whitespace strings.
IsBlank(Trim(Column2))
Trim will remove any whitespace and IsBlank will return a true/false if the string is empty or not after the trim.
IsBlank
Trim
UPDATE: Check only for IsBlank where Column2 is evaluated, the way you wrote it it's checking if Column2 = bool which will have a type mismatch since it's checking a string vs a bool, change to this:
ClearCollect(Test,LookUp(Table1,Column1=DataCardValue6.Text && IsBlank(Trim(Column2))))
Microsoft Learn
learn.microsoft.com › en-us › power-platform › power-fx › reference › function-isblank-isempty
Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn
To test specifically for a blank value use if(Value = Blank(), ... instead of IsBlank. The IsBlank function considers empty tables as not blank, and IsEmpty should be used to test a table.
Matthew Devaney
matthewdevaney.com › home › power apps › what’s the difference between these power apps functions?
What's The Difference Between These Power Apps Functions? - Matthew Devaney
November 13, 2025 - Set(varColors, Primary1: ... HexValue)), )Code language: JavaScript (javascript) ... ISBLANK and ISEMPTY both check for the absence of any value....
IsEmpty and IsBlank functions suddenly stopped working for combo box
What is the default value of the combobox? If you try looking at combobox.selected.result, does it look blank? Maybe try isblankorerror() Maybe try result = "" More on reddit.com
5
4
December 29, 2021How to evaluate empty TextBox in PowerApps? - Stack Overflow
I have two column in my Excel Table (DataSource) and I am trying to evaluate both columns. Column 1 contains data and Column 2 is empty as shown below. The default FormMode is Edit, which contains 2 More on stackoverflow.com
Blank() isn’t the same as “”?
Blank will tell you if a column or record does not have a value. “” evaluates if a string is empty. Blank will evaluate on most types of columns. But “” works only for text columns. There are also delegation differences between the two. For example, with SharePoint IsBlank is not delegable for text fields. But using = Blank() works. More on reddit.com
11
7
December 24, 2023sharepoint online - Using IsBlank in formula for Date Time Picker field on Power Apps - SharePoint Stack Exchange
Pretty new to SharePoint and Power Apps so would like to ask if what I am trying to do is feasible. I have a Date Time Picker field in my formula in Power Apps and currently, its default value is s... More on sharepoint.stackexchange.com
Videos
Microsoft Power Platform
community.powerplatform.com › forums › thread › details
Solved: !IsBlank() and !IsEmpty() for combo box
January 19, 2019 - Hello, guys. I just don't know what to do anymore, so PLEASE, give me a hand or two, if possible · I have a job to do to my boss. I creater a powerapps screen that saves data in a Sharepoint List, but one field of this screen, a combo box, receives data from the List to charge the choices available
BytePlus
byteplus.com › en › topic › 498659
IsBlank vs IsEmpty in PowerApps: Key Differences
// Validating text input using IsBlank() If(IsBlank(TextInput1.Text), Notify("Please enter a valid input"), ProcessUserInput()) In contrast, IsEmpty() is a more specialized function focused specifically on determining whether a collection or table contains any records.
Reddit
reddit.com › r/powerapps › isempty and isblank functions suddenly stopped working for combo box
r/PowerApps on Reddit: IsEmpty and IsBlank functions suddenly stopped working for combo box
December 29, 2021 -
I’m pretty new to power apps and have been using it for about a month to make something for work. The app is a form that uses a share point list to get data for combo boxes.
I have been using IsBlank and IsEmpty to check if any boxes do not have a selection made, and if so to leave the submit button blank. When I initially set it up it worked perfectly with no problems. However when I tried to test something else today I found it had completely stopped working for the combo boxes I have made. The weird part is that I use the exact same code in another test app and it still works fine, and I tested if it works on a different combo box separate from the form on that same page and it also works. The combo boxes are formatted exactly the same so I’m confused why it is not working.
The button used an if statement like this:
If(isblank(combobox.selected.result) || isempty(combobox.selected.result), displaymode.disabled, displaymode.edit)
I have tried everything I could find on google like countRows, LEN, removing the .result part, etc.
Any possible suggestions?
Top answer 1 of 4
2
What is the default value of the combobox? If you try looking at combobox.selected.result, does it look blank? Maybe try isblankorerror() Maybe try result = ""
2 of 4
1
Try going back to the previous build of Power Apps and check if it works, if so it has to do with the current version
Ippu-biz
ippu-biz.com › ホーム › development › power platform › power apps › understanding null, blank, and empty in power apps: a comprehensive guide” because
Understanding NULL, Blank, and Empty in Power Apps: A Comprehensive Guide” because
January 24, 2025 - IsBlank() is quite sensitive and responds to both “blank” values and “empty strings”. ... Create an if statement using the Blank() function like this. The Coalesce function examines its arguments in order and returns the first value that is neither “blank” nor an “empty string”. Coalesce is strict about its arguments – they must all be of the same type. Don’t mix numbers and strings in the same function call. IsEmpty is equivalent to (CountRows() == 0)....
Code SharePoint
codesharepoint.com › PowerPlatform › check-value-is-blank-or-not
PowerApps Check if value is blank or not - Code SharePoint
The IsBlank function in Power Apps is used to determine whether a value is blank or not. This function is particularly useful for checking whether fields are empty, whether controls contain data, or for validating user input.
Microsoft Fabric Community
community.fabric.microsoft.com › t5 › Desktop › Filters-difference-between-IS-EMPTY-and-IS-BLANK › td-p › 2652886
Solved: Filters, difference between IS EMPTY and IS BLANK - Microsoft Fabric Community
July 21, 2022 - Some useful info here: https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-isblank-isempty
Reddit
reddit.com › r/powerapps › blank() isn’t the same as “”?
Blank() isn’t the same as “”? : r/PowerApps
December 24, 2023 - Blank will tell you if a column or record does not have a value. “” evaluates if a string is empty. Blank will evaluate on most types of columns. But “” works only for text columns. There are also delegation differences between the two. For example, with SharePoint IsBlank is not delegable for text fields...
SPGuides
spguides.com › power-bi-dax-isblank-vs-isempty
ISBLANK vs ISEMPTY in Power BI DAX
January 7, 2026 - ISBLANK returns TRUE when the value is blank and FALSE when data exists. It is commonly used to detect missing data in columns, handle empty measure results, or control calculations when a value is not available.
YouTube
youtube.com › watch
Power Apps IsEmpty Vs IsBlank
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Stack Exchange
sharepoint.stackexchange.com › questions › 309153 › using-isblank-in-formula-for-date-time-picker-field-on-power-apps
sharepoint online - Using IsBlank in formula for Date Time Picker field on Power Apps - SharePoint Stack Exchange
August 23, 2023 - You can check for blank values in Power Apps using IsBlank() or IsBlankOrError() functions.
YouTube
youtube.com › david soden
#10 Power Fx - Series - Blank, Coalesce, IsBlank, and IsEmpty - YouTube
Power Fx - Series - Blank, Coalesce, IsBlank, and IsEmptyACCESS THE MEMBERS DOWNLOAD HEREhttps://github.com/dtsoden/YouTubeVideos/tree/main/Power-FX-Series
Published February 18, 2024 Views 119
CRM Crate
crmcrate.com › home › how to operate with blank / empty values in power apps?
How to operate with Blank / Empty values in Power Apps? - CRM Crate
May 13, 2024 - IsBlank( “CRM Crate”) The result will be “false” as the input parameter passed to the function is not empty. IsEmpty (Table) The IsEmpty function tests whether a table contains any records. It’s equivalent to using the CountRows function ...
Code SharePoint
codesharepoint.com › PowerPlatform › check-table-is-empty
PowerApps Check if table or collection is empty and has no records - Code SharePoint
The IsEmpty function in Power Apps is used to determine whether a table or collection is empty, meaning it contains no records. This function is particularly useful for validating data, checking if results are returned from a query, or ensuring that certain actions are only taken when there is data to process.
Google Cloud Community
googlecloudcommunity.com › gc › AppSheet-Q-A › ISBLANK-vs-empty-string-list › m-p › 284567
Solved: ISBLANK() vs empty string/list - Google Cloud Community
January 8, 2022 - Hello, I’ve been using the empty string: “”, and they empty list: LIST(), in boolean expressions all around my app, such as: [value] = “” [value] LIST() Then I discovered ISBLANK(), sorry! My question is whether there are any performance/functionality reasons for which I should go back searching ...
Platformsofpower
platformsofpower.net › home › using the coalesce function in power apps
Using the Coalesce Function In Power Apps - Platforms of Power
September 29, 2024 - The Power Apps coalesce function lives in the same family as Blank, IsBlank and IsEmpty. It’s a very efficient way to evaluate controls and outputs to return the first value that’s not blank.
Dynamics Community
community.dynamics.com › blogs › post
cmty_blog_detail
Hello everyone and welcome to my blog. In today’s blog, I will show how can you check if a collection is empty in Power Apps. There are primarily two ways you can check if a collection is empty. The first is using the IsEmpty function. In the below example, the IsEmpty function will initially ...