Answered

OnStartup Variables

(0) Share

Report

Posted on by CU06081315-1

Hello,

I'm attempting to set a variable OnStartup. Essentially, I want to pull the largest ID from my Sharepoint table and set it as a variable so that it is immediately usable as the largest ID to create a more custom ID.

OnStartup:

Set(varTXSOEntry,Value(SeqID.Selected.ID));

Where SeqID is the dropdown that I'm refencing the ID from.

I'm attempting to put varTXSOEntry into a text label with the formula:

"TX" & Text(varTXSOEntry,"01000")

The problem I'm running into is that even though my startup function is showing a SeqID = 85, my output to my text label is showing a value of 0.

Any advice?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cborde3

Go to settings and turn on Named Formulas

Then go to Apps.Formula and put in

wTXSOEntry=First(Sort(splist,ID,Descending)).ID;

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Do you mean the OnStart property? If so, referencing a controls selected variable in the app is always going to return 0, the app just started, there is no selected control states yet.

If you are just looking to set a variable for msot recent splist in the onstart do somethign like this

Set(varStart, "TX" & Text(Last(SPLISTNAME).ID&"01000"))

Was this reply helpful? Yes No
CU06081315-1 on at

Like (1)

Report
Copy link

Link copied!

Thank you. This worked.

Was this reply helpful? Yes No