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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data on Gallery showin...
Power Apps
Unanswered

Data on Gallery showing on Editing Studio but once published, it is not showing.

(1) ShareShare
ReportReport
Posted on by

Hi Team,

 

NICE Day! 

 

Attached are the screen shots of Editing vs. Live App.

 

Showing below the codes of my Gallery. I wonder why the data are not showing on live app. But it is working well fine while editing. I turned off alreayd the New Analysis Engine and UDF function as I have seen some post with issues on those new features.

 

if the colAllList was only on the items property of my gallery, it showed the data. But if I added complex codes like below (I used this on my previous apps but working fine), it showed blank. Is there something wrong with my code? hope someone helps. Thank you! Thank you in advance!

 

With({
    repohub:
Filter(colAllList,
And(IsBlank(ComboboxCanvas1.SelectedItems) Or IsEmpty(ComboboxCanvas1.SelectedItems) Or Current_x0020_Status in ComboboxCanvas1.SelectedItems,Account_x0020_Tagging.Value = "Ropa Managed")) },

Sort(
    Filter(repohub,
    TextInputCanvas1.Value in Handling_x0020_Unit.Value Or
    TextInputCanvas1.Value in PAN Or
    TextInputCanvas1.Value in Account_x0020_Name Or
    TextInputCanvas1.Value in Account_x0020_Tagging.Value Or
    TextInputCanvas1.Value in Tct_x0020_No_x002e_ Or
    TextInputCanvas1.Value in PMS_x0020_Status.Value Or
    TextInputCanvas1.Value in Current_x0020_Status.Value Or
    TextInputCanvas1.Value in Manner_x0020_of_x0020_Acquisitio.Value Or
    TextInputCanvas1.Value in Acquisition_x0020_Date Or
    TextInputCanvas1.Value in Date_x0020_Filed Or
    TextInputCanvas1.Value in Annotation_x0020_Date Or
    TextInputCanvas1.Value in Redemption_x0020_Expiry Or
    TextInputCanvas1.Value in TCT_x0020_Conso_x0020_Date Or
    TextInputCanvas1.Value in 'TCT Conso Date' Or
    TextInputCanvas1.Value in Tax_x0020_Declaration_x0020_Cons Or
    TextInputCanvas1.Value in TAV_x0020_as_x0020_of_x0020_late

    ),IDFilter,SortOrder.Descending))

 

 

 

nmlsanmiguel_0-1720431361013.png

nmlsanmiguel_1-1720431375225.png

 

Categories:
I have the same question (0)
  • MichaelFP Profile Picture
    1,847 Super User 2025 Season 2 on at

    Did you check o monitor the query to validate if the query is returning something? or give any error?

  • nmlsanmiguel Profile Picture
    on at

    Yes Sir I tried to validate the query it is working fine. Is it some sort of a bug? or something?

  • MichaelFP Profile Picture
    1,847 Super User 2025 Season 2 on at

    you check the gallery it only has the primary key?

     

    I have some similar issue, but is using the SQL views.

  • nmlsanmiguel Profile Picture
    on at

    Is it because the Title column on my sp lists is blank? 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 711 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 319 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard