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 / Gallery Display Bug wh...
Power Apps
Unanswered

Gallery Display Bug when filtering by IF formula

(0) ShareShare
ReportReport
Posted on by 44

Hello,

 

I have a Gallery that should display a list of properties dependant on what project is selected in another Gallery.

 

During day to day use it will be required to have this gallery filtered to ensure those using the app see only the outstanding properties that need to be worked on. To that end I have a Toggle that applies the relevant filter when set to false.

 

When the app displays the gallery whether or not the filter is on or off it is unable to display the details of each record in the gallery (see screenshots below). It does however display the correct number of entries in the gallery and selecting these entries does allow the form on the next screen to identify the correct selected item using a lookup of the Gallery in questions selected item.

 

CraigPezet_1-1666446791647.png

 

The curious part, however, comes when I remove the Item entry for this value (below), replace it with the true_value of the formula only.

 

Gallery Item:

If(

Toggle1.Value,

galProjects.Selected.'PSWO Project Properties',

Filter(galProjects.Selected.'PSWO Project Properties','Rectification Confirmed'='Rectification Confirmed (PSWO Project Properties)'.No && 'Issue at Property'<>'Issue at Property (PSWO Project Properties)'.No)

)

 

It then displays correctly, and even more perplexing is when I undo this change the whole thing functions correctly (see below screenshot) until I next close and open the app or attempt to manually effect a change in the Item formula.

 

CraigPezet_3-1666447477819.pngCraigPezet_4-1666447605218.png

 

For reference the item in the Gallery Label is: Concatenate(Text(ThisItem.'Property Name/Number'),", ",Text(ThisItem.'Address Name'),", ",Text(ThisItem.Postcode))

 

I would be very interested to know if there is any way of preventing this issue as at present when the App is run it is unable to display entries in the gallery correctly. Potentially they may be a way to quickly switch the Item value for the Gallery on startup to get it to display and function correctly.

 

Any help would be greatly appreciated.

 

Craig

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    A long shot, but would the following make any difference?

    If(
    Toggle1.Value = true
  • CraigPezet Profile Picture
    44 on at

    Hi @Akser ,

     

    Unfortunately it made no difference.

  • CraigPezet Profile Picture
    44 on at

    My current workaround to this issue is to load the data into a collection, rather than load the data source directly. This combined with refreshing the collection upon screen visible, and a manual refresh button. It works but is not ideal due to the maximum collection size.

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 June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 335 Most Valuable Professional

#2
11manish Profile Picture

11manish 166

#3
sannavajjala87 Profile Picture

sannavajjala87 71 Super User 2026 Season 1

Last 30 days Overall leaderboard