Answered

Return of IsBlank function doesn't read properly

(0) Share

Report

Posted on by Angel5

Hello everyone!

So I have this as the Visible property for a Label that I have:

If(
 IsBlank(ProjectRecord.Project_Name),
 true,
 IsBlank(ProjectRecord.Project_Site),
 true,
 IsBlank(ProjectRecord.Project_Num),
 true,
 false
)

On the gallery that is connected to my data source, and I can see if there is a missing Project Site, however in certain records where the Project Record is blank, my Label doesn't pop up. So the IsBlank function sometimes returns true, but most of the times it returns false. I don't know if it has to do with my Data Source for the gallery then (Its an Excel btw)?
Thanks in advance!!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

AR-29081311-0 137 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Angel5 ,

If the label is inside a gallery, you can use
ThisItem.Project_Name

See here for reference:
https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators#thisitem-thisrecord-and-as-operators

Hope this helps!

Aaron

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
hey @Angel5

you can try this:
If( Or( IsBlank(ProjectRecord.Project_Name), IsBlank(ProjectRecord.Project_Site), IsBlank(ProjectRecord.Project_Num) ), true, false )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Angel5 on at

Like
a
(0)

Report
Copy link

Link copied!

It is an exterior label, not within the gallery

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Angel5 ,

Can you try the following formula:

If( !IsBlank(ProjectRecord) && ( IsBlank(ProjectRecord.Project_Name) || IsBlank(ProjectRecord.Project_Site) || IsBlank(ProjectRecord.Project_Num) ), true, false )

Hope this helps

Was this reply helpful? Yes No
AR-29081311-0 137 on at

Like
a
(0)

Report
Copy link

Link copied!

The two guys beat me to it then!

@Ethan_R and @mmbr1606 should work?

Aaron

Was this reply helpful? Yes No
Angel5 on at

Like
a
(0)

Report
Copy link

Link copied!

This should work in theory! However, when I select certain records within the gallery that I know that the project site is empty, the label doesn't appear, so I don't know if it is an issue with the data source

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Angel5 ,

Let's get your data refreshed first

1. Go to Data tab on the left (Database Icon) and find you Table name 'Projects' and click on Refresh under ellipses (3 dots). This will force refresh and show data in Label if its Blank

2. What is the relation of your Gallery Source and the Projects table? If Project is lookup, then find the project with the unique ID (GUID) or any other ID if its other Data source such as SP.

3. If you have several Projects attached to 1 record then use Filter function to get all Projects related to the record.

4. If the Project is simply a field in your existing Gallery source (single Source) then simply call the field name. (In case of Lookup, <FieldName>.<ColumnInOtherTable> example Project.Name

If you still face issue, you can send screenshot to show where is the issue and what error you get.

Hope this helps

Was this reply helpful? Yes No
Verified answer

Angel5 on at

Like
a
(0)

Report
Copy link

Link copied!
I fixed it, it seemed to be that the data source, (the excel) was returning back that it had text in it because some columns had a space in them and nothing else, fixed it by adding trim to the record created upon selecting the gallery.
If( Or( IsBlank(Trim(ProjectRecord.Project_Name)), IsBlank(Trim(ProjectRecord.Project_Site)), IsBlank(Trim(ProjectRecord.Project_Num)) ), true, false )

Was this reply helpful? Yes No
AR-29081311-0 137 on at

Like
a
(0)

Report
Copy link

Link copied!

Nice! I would also try and move away from Excel as data source as it is doom! 😅

Aaron

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yeah 😅 @ARAlmac ,

I know the struggle of handling Excel and how it deals with several things is way complex in building a simple app.

Same happens when using Excel in Power automate, but large data can be handled bit easily.

Was this reply helpful? Yes No