Year collection run manually

(0) Share

Report

Posted on by Ghada Mehrez

257

Hi everybody

I created year collection and linked it to a drop down that contains formula when the user open the app the year will be displayed automatically on the current year.

Years Collection button on select formula:

Collect( Years, { ID: "1", Value: 2019 }, { ID: "2", Value: 2020 }, { ID: "3", Value: 2021 })

Dropdown Items "Years"

Default

LookUp(
 Years,
 Value = Year(Now())
).Value

the issue now every time I open the app I should click on the collection button to run it, please I need it automatically anyone can help?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @gme-eg ,
You can run it at App OnStart - this will run every time the app is opened

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Ghada Mehrez 257 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot for support but it is still needs to be manually also I run it from the app and I added it to the app on select formula

Was this reply helpful? Yes No
Verified answer

GarethPrisk 2,828 on at

Like (1)

Report
Copy link

Link copied!
@WarrenBelz is correct; to have the Collection automatically be set, you will want to use the app's OnStart property and load the collection there. Note, it will execute automatically the first time you edit in the Studio, but must be toggled afterwards. Normal app loads will run the function as expected.

I can't tell the exact behavior you're expecting, but here are guesses:
[Most Likely] The Dropdown has the current year selected when a User sees the control
The Dropdown should be blank until a User clicks on the control, then it sets the current year
Some other manual click from the User to create the collection, then default the Dropdown

If you're looking for the standard default, your formula looks correct. However, you need to correlate the Value property of the Dropdown to what the Default is passing. See screenshot:
The Value list on the property pane for the Dropdown shows the available fields, from the Items being passed to the Dropdown. It's not a property you can set, but you can select it here. Yours might be set to ID. Replicating the above will give you a Defaulted year value in the Dropdown.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please what @WarrenBelz is the way to go if you want it automatically done instead of manually as you want. Put it Onstart as he said

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Thanks @GarethPrisk
One small small thing to add - you can run App OnStart during development

Was this reply helpful? Yes No