Custom text when field is blank

[sr12]

Hello everyone,

I would like to display "Pending Approval" in PowerApps when the status column in SharePoint is empty. How can I do that?

Thanks in advance.

[PG_WorXz10]

Hi @sr12 ,

Please see below 

1. If you want it in gallery 

Label property Text : If(IsBlank(Thisitem.Status),"Pending Approval")


2. If the you want it in label 

Label property Text : If(IsBlank(DataSource.StatusColumn),"Pending Approval")

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[sr12]

@PG_WorXz10 ,

Thank you for your reply, but now the filled values in the SharePoint are appearing blank in the app when i used your code.

[PG_WorXz10 · Accepted solution]

Hi @sr12,

In case of filled values you have mention else part in the if.

May be something like below.

1. If you want it in gallery 

Label property Text : If(IsBlank(Thisitem.Status),"Pending Approval",Thisitem.Status)


2. If the you want it in label 

Label property Text : If(IsBlank(DataSource.StatusColumn),"Pending Approval",Thisitem.Status)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.