Answered

Get field property from Gallery on App start

(1) Share

Report

Posted on by TeeroyLyon

Hi All,

I have an app with a simple screen that has a gallery and a form for details. When the app starts, I need to get the Title property from the selected item in the gallery (the first row). I know this can easily be done through the OnSelect function of the gallery, but this is not triggered on App start. I've tried to get it on the Screen.Onvisible function, but that's not working.

Hope this makes sense, and thanks for any help!

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Instead of getting it from the gallery what you need is this:
Get the datasource of the gallery (Including filter if applicable)
and then wrap it in First()
e.g. i have a datasource on my gallery and i need the first row. my gallery's datasource is Filter(Contacts, 'Created By'.domainname = User().Email) so i would do First(Filter(Contacts, 'Created By'.domainname = User().Email))

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Let me know if you need me to help you adapt this to your use case/onstart criteria.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@TeeroyLyon

Information from controls is global in PowerApps. The Title of the selected row of a gallery can be obtained from any place. yourGallery.Selected.Title is what you would need.

Keep in mind that using the data from any control in the app in OnStart may yield incorrect data as the controls might not have been completely initialized and most certainly, no user has selected anything yet.

This is another reason to avoid variables in your app and reference the controls instead as the variable will be a snapshot of the value at a time and will never change until you change it again in your formulas.

I hope this is helpful for you.

Was this reply helpful? Yes No
TeeroyLyon 71 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks @AJ_Z ...this is pretty much what I was looking for and works great!

Cheers,
Troy

Was this reply helpful? Yes No
TeeroyLyon 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this Randy...I was looking more for what @AJ_Z recommended. But maybe this will help someone else searching. And yes, the main issue is control initialization.

Cheers,
Troy

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@TeeroyLyon

Hopefully it will be avoided as using the First(Filter combination is very poor for performance.

The point however is, your Gallery already has the information in it and has gone through the cost of going to the datasource already, you can reference that then in the app as needed. Otherwise, you are making more trips to the datasource which is costly on performance.

So in your case, if you wanted the first item of that Gallery, then First(yourGallery.AllItems) will be that record. And no costly trip to the datasource again.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@TeeroyLyon I am very happy to help 🙂

Was this reply helpful? Yes No