Answered

How do I indicate that a data entry is not complete

(0) Share

Report

Posted on by peter_Ch

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

peter_Ch 26 on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!

@peter_Ch ,

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

Len(ThisItem.Address)=0….

hope it helps !

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
peter_Ch 26 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No