web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get a value from last ...

Power Apps

Answered

Get a value from last item from SP-List

(0) Share

Report

Report

Posted on by PMO_CH

122

Hi all,

I have a sharepoint-list with some different articles like Cleaning-Stuff, TV's, Coffee and so on....

Part or this column is also the price.

This Articles aren't just one time in this list, they are multiple there...

Now i would like to get the price from the last article, selected from a ComboBox. Is this possible?

Tried with this Syntax:

Thank you very much.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @PMO_CH ,

It looks like there is nothing wrong with your code, so what is your issue now?

Usually, to get the value from the last item, I will use formula like this(you can add a label and check if you can get a correct result using this code):

Pay attention to use "." instead of ";" outside the Last() function to get a specified value.

Last(Filter(StockDate;Title=ComboBox1.Selected.Result)).EK_x002d_Preis

If the EK_x002d_Preis is a Text column, you can add a Value() outside above code to make the result into a number format, so that you can directly use this result to do some calculations.

Value(Last(Filter(StockDate;Title=ComboBox1.Selected.Result)).EK_x002d_Preis)

Best regards,

Allen

Was this reply helpful? Yes No
PMO_CH 122 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, it works perfect 😀

Was this reply helpful? Yes No

Join the conversation