Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building 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

 

  • nmlsanmiguel Profile Picture
    on at
    Re: Data on Gallery showing on Editing Studio but once published, it is not showing.

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

  • MichaelFP Profile Picture
    1,831 Super User 2025 Season 1 on at
    Re: Data on Gallery showing on Editing Studio but once published, it is not showing.

    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
    Re: Data on Gallery showing on Editing Studio but once published, it is not showing.

    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,831 Super User 2025 Season 1 on at
    Re: Data on Gallery showing on Editing Studio but once published, it is not showing.

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

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard