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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,151)