Answered

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)

Sort by

HenriDesmet59 295 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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
Copy link

Link copied!
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 37,112 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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