Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

How do I indicate that a data entry is not complete

Posted on by 26

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.

  • peter_Ch Profile Picture
    peter_Ch 26 on at
    Re: How do I indicate that a data entry is not complete

    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.

  • Verified answer
    Re: How do I indicate that a data entry is not complete

    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)
  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,261 on at
    Re: How do I indicate that a data entry is not complete

    @peter_Ch ,

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

    Len(ThisItem.Address)=0….

    hope it helps !

  • peter_Ch Profile Picture
    peter_Ch 26 on at
    Re: How do I indicate that a data entry is not complete

    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!

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard