web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How can I change an it...

Power Apps

Answered

How can I change an item to a different text when displayed in gallery if there is no entry

(0) Share

Report

Report

Posted on by PowerAppNoob247

5

I currently have a app that pulls from a SharePoint List. I have a % complete column that displays on the gallery. Below is the code I am using to display the percentage. Is it possible, if there is no entry given in the column, the text "N/A" appears in the gallery rather than just a % symbol?

Text(ThisItem.'% Complete'*100, "#%")

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PowerAppNoob247 ,

Using an If function, this is easy to implement:

If( IsBlank(ThisIte.'% Complete'), "N/A", Text(ThisItem.'% Complete'*100, "#%") )

Was this reply helpful? Yes No
PowerAppNoob247 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome, thank you.

Was this reply helpful? Yes No

Join the conversation