Get variable when an app loads

(1) Share

Report

Posted on by Frac

194

Hello, i have an app that is connected to a sharepoint list, and i need to get the ID for the record that loads by default when my app starts. Basically, i am using the patch command to update my list when a i click on the save icon.

Patch(
    PooledPromotions,
    LookUp(
        PooledPromotions,
        ID = varID
    ),
    Candidate.Updates,
    Manager_1.Updates,
    Manager_2.Updates,
    Interview.Updates,
    Onboard.Updates
);
 
everytime i choose a new record from my gallery, i am updating varID with that records ID, so this is only a problem affecting what ever record is displayed for the first time when my app loads.  if i try to save that record with out first selecting it in the gallery, varID is blank and nothing happens. 
 
 
i have tried to set varID on both the OnStart property of my app, and in the OnVisible property of my screen, but with no success using; Set(varID,Gallery1_1.Selected.ID);
 
how can i get my variable to populate when my app starts, or if that isnt possible, how can i keep my form from filling in with the first record before 
 

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (2)

Report
Hi Frac

What do you mean by "loads by default" ? If you are loading into a gallery or for, it will be the first item of whatever list you are referencing.
Set( varID, First(ListName).ID )

If you are filtering the gallery, it will be
Set( varID, First( YourGalleryFilterHere ).ID
)

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Frac 194 on at

Like (1)

Report

@WarrenBelz would this go under the items property of my gallery?

Set(

varID,

First(

Sort(

Filter(PooledPromotions,'Promotion Cycle' =Pool.Selected.Value

),

Candidate.DisplayName

).ID)

)

Was this reply helpful? Yes No
Wee Teck 45 on at

Like (1)

Report

you can set it with the screen where the gallery is located where In the properties pane, find OnVisible.

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (2)

Report
Hi Frac,

A simple solution to this would be Disabling your Save button if no item is selected in your gallery and if nothing is selected, you can also display a message "Select an item before making updates" something like this. This is the ideal way, cause the user should first select the item they wish to update.

DisplayMode of your Save button:

If(IsBlank(VarID), DisplayMode.Disabled, DisplayMode.Edit)

Visible property of the Text label:

IsBlank(VarID)

This way you can make the users avoid pressing Save without selecting a record.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (1)

Report

Hi Frac

Yes - that will get the first record - alsoNandit's idea will work, but that was not the question you asked.

Was this reply helpful? Yes No