Custom text when field is blank

(0) Share

Report

Posted on by sr12

125

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

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

Was this reply helpful? Yes No
sr12 125 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

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

Was this reply helpful? Yes No