cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
peter_Ch
Frequent Visitor

How do I indicate that a data entry is not complete

I have a Browse screen that lists peoples names. I also have an Edit Screen that lists all their details (address, DOB etc). I would like to have an indicator so that I can know on the Browse screen whether the information is incomplete. I have tried doing a series of tests with an IF statement to check if anything is not filled in and writing a

IF(ThisItem.Address = "" Or ThisItem.Suburb = "" Or ThisItem.DOB = "",ThisItem.Fname & " !",ThisItem.Fname)

which is supposed to put a ! at the end of the Surname, but it's not working. I am putting this function in the text section of FName. Any help would be much appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @peter_Ch,

Do you want to check if there is a blank item within a record?

Could you please share the error message if there exists?

Not sure the column type of the Address and Suburb and DOB and Fname, are they both Text column type in your data source?

Put a Label and set the Text property as below:

If(IsBlank(ThisItem.Address ),"NotFilled!",ThisItem.Address )

If the Label shows "NotFilled!", it means that this record has a blank value within.

So on your side, please select all the Labels and set the Text property of each to their own column name:

If(IsBlank(ThisItem.Column),"NotFilled!",ThisItem.Column)
Best Regards,
Qi

View solution in original post

4 REPLIES 4
peter_Ch
Frequent Visitor

I even tried adding an icon to the BrowseGallery and setting its visible parameter to

 

If(IsBlank(Coalesce(ThisItem.Address,ThisItem.Suburb,ThisItem.Email)),true,false)

but doesn't show for entries I know are blank!

 

gabibalaban
Super User
Super User

@peter_Ch ,

this is quite strange, try to use Len() function like:

Len(ThisItem.Address)=0….

hope it helps !

v-qiaqi-msft
Community Support
Community Support

Hi @peter_Ch,

Do you want to check if there is a blank item within a record?

Could you please share the error message if there exists?

Not sure the column type of the Address and Suburb and DOB and Fname, are they both Text column type in your data source?

Put a Label and set the Text property as below:

If(IsBlank(ThisItem.Address ),"NotFilled!",ThisItem.Address )

If the Label shows "NotFilled!", it means that this record has a blank value within.

So on your side, please select all the Labels and set the Text property of each to their own column name:

If(IsBlank(ThisItem.Column),"NotFilled!",ThisItem.Column)
Best Regards,
Qi

View solution in original post

What I actually did was a series of IsBlanks for each field.

This went into the visible property of an icon I had placed in the BrowseGallery.

If(IsBlank(ThisItem.EContactNum) Or IsBlank(ThisItem.EContactName) Or IsBlank(ThisItem.Address) Or IsBlank(ThisItem.Suburb) Or IsBlank(ThisItem.Mobile) Or IsBlank(ThisItem.Email) Or IsBlank(ThisItem.SCtype) Or IsBlank(ThisItem.DOB) Or IsBlank(ThisItem.SCReference), true , false )

I know it looks unwieldy but if anyone can find a shorter way. The coalesce function was doing an And function which is not what I wanted.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,003)