Unanswered

SET GLOBAL VARIABLE FROM LATEST VALUE IN SHAREPOINT LIST

(0) Share

Report

Posted on by ICEMAN65

I have a sharepoint list that is automatically populated with a daily exchange rate (Columns: CurrencyCode, FxDate,FxRate) and am trying to set a global variable (FxR) with the OnStart property of my app.

I am using the following, but it doesn't seem to be populating the variable.

What am I doing wrong?

Set(FxR,First(
FirstN(Sort(FxRates,FxRate, Descending),
1
)
)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

HenriDesmet59 295 on at

Like (0)

Report
Hello @ICEMAN65 ,

If you want to bind the latest value to a global variable from a SharePoint List, you can write the following :
Set(LastItem,First(Sort('test liste';ID;Descending)))
The Sort by ID get you the last item in the first place.

Tell me if It's ok for you 🙂

Henri

Was this reply helpful? Yes No
ICEMAN65 on at

Like (0)

Report

That still isn't working I don't get a value in my variable. It doesn't seem to be picking up the value i need from the relevant column in my sharepoint list.

Was this reply helpful? Yes No
Verified answer

HenriDesmet59 295 on at

Like (0)

Report
How do you use your variable ?
When you put the item in the variable, to get the value of a column you need to write :
LastItem.Column

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
@ICEMAN65

I note that your formula sorts by FxRate in descending sequence. Therefore, I suspect that sorting by FxDate will produce the correct result.

Set(FxR, First( FirstN(Sort(FxRates,FxDate, Descending), 1 ) ) )

Was this reply helpful? Yes No