web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Displaying "No data" i...
Power Apps
Unanswered

Displaying "No data" if SharePoint Datasource Item is Empty

(0) ShareShare
ReportReport
Posted on by 21

Hello Power Apps Wizards

I am still working on the power apps indicated on my thread here: Re: Putting Gallery Text Content into a Tooltip Fo... - Power Platform Community (microsoft.com)

 

For the most part, I have addressed the accessibility issue on the app discussed on that thread, however I had come to my attention the data source is not very clean, as some cells are empty and some cells contain a dash ( - ), I tried to change the output of the Inventory Gallery calls from:

 

 

ThisItem.Inventory

 

 

to:

 

If(IsBlank(ThisItem.Inventory,
 "No Data Found", 
 ThisItem.Inventory
)

 

This formula works on the editing canvas, however, the cell goes completely blank when I play it, so not sure what I did wrong.

The other thing I want to address in the same formula is something along the lines of "if data source is showing "-" display no data found", not sure how I can do that?

Categories:
I have the same question (0)
  • zuurg Profile Picture
    546 Super User 2024 Season 1 on at

    I would probably use the Coalesce function here instead of the If(IsBlank...

  • Joyce23 Profile Picture
    21 on at

    Thank you for the suggestion, I tried it out, and the result still disappears when I play the app... not sure if it's glitch or something? The formula works on editing canvas.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 356 Most Valuable Professional

#2
11manish Profile Picture

11manish 225 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 211

Last 30 days Overall leaderboard