Some labels in Gallery don't show up

(0) Share

Report

Posted on by Khar

Hey everyone,

this is the weirdest thing that happened in powerapps for me so far.

I have a SQL-Server datasource and put it in a collection like this (in "onStart" of the App): ClearCollect(myCollection, GroupBy('[myDatasource]', "BookingID", "CustomerID", "CustomerName", "Date", "Details"))

Now I got a gallery that is connected to "myCollection". In the gallery I have labels for "BookingID", "CustomerID", "CustomerName", "Date" and populate them with ThisItem.BookingID, ThisItem.CustomerID, etc...

Everything seems to work fine here. Once I run OnStart the fields get filled up with the Data.

The issue arises when I save + publish the App and try to run it from the PowerApps Windows Store Application or from my list of apps on make.powerapps.com: The App loads, but the only labels that actually show the Data are the labels with ThisItem.BookingID and ThisItem.Date. The others are just blank for whatever reason. It seems like the collection never gets those values which is weird, because when I'm working on the App everything works fine...

Trying to figure out how to fix this is quite difficult since the problem doesn't exist while working on the app.

Does anyone have an idea what the issue could be or why I get different results depending on where I run the app?

Thanks.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Khar

Yes, very frustrating when everything works in the Designer but not during Play!

Here are a couple of steps that I would take to troubleshoot:

1) Skip the collection - Put your formula directly on the Gallery Items property:

GroupBy('[myDatasource]', "BookingID", "CustomerID", "CustomerName", "Date", "Details")

See if that is any different.

2) Put a test label on the screen and set the Text property to:

First('[myDatasource]').CustomerID

See if there is a value displayed in the label at Play time.

3) Consider refining your GroupBy. It seems that you are Grouping on BookingID and Customer - yet, you are actually grouping on CustomerID and CustomerName. Ultimately, the columns you group by will be distinct values from the datasource. It would seem that CustomerName and CustomerID would be unique and tied together, so consider perhaps this formula instead:

GroupBy('[myDatasource]', "BookingID", "CustomerID", "Date", "Details")

And even then, possibly consider dropping the other level of grouping on the Date and handling that within your app differently.

Just some thoughts....I hope it is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Maybe there is an access restriction on some of the tables within your database. Had that issue a few times with different sharepoint list where some data did not display due to certian access restrictions.
Khar 20 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for the suggestions.

1) I originally did it without the collection and it used to work. The collection was just a way of trying something different and comparing the performance while using different actions.
However, when I change it back now, it still doesn't work.

2) The label works and shows the correct value. Interestingly enough the labels in the gallery now also work.

3) So far, changing up the GroupBy() the way you suggested didn't change the outcome.

I'll see if I can figure something out based on this, thank you.

Edit: I changed it to GroupBy("BookingID", "Date", "Details") now and I'm using CustomerID and Customer through a second gallery inside my main gallery which seems to work fine. I'll probably end up changing up a couple more things and taking a different approach to the problem so I suppose I could close this topic since I will probably populate the labels in a different way than I originally thought.

That being said I'm still wondering what the reason for the issue I experienced is.
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Khar

Sometimes PowerApps exhibits some strange behaviour. Many times it boils down to some way that things were put together. The real unfortunate part is that some of those times the problem only surfaces at Play-time, not at Design-time...those are the worse.

The only course of action is to tear down parts of your app into separate sections or into separate apps in order to try and diagnose the real cause.

I feel your pain!
Khar 20 on at

Like
a
(1)

Report
Copy link

Link copied!

I see, thanks for the info! I'm accepting this as a solution for the time being. If I happen to find out something worth sharing I will add it later.

Thanks for the assistance!