Answered

Why is my code not returning the last record?

(0) Share

Report

Posted on by futr_vision

831 Moderator

I have a button on the first screen of my app that, when clicked, writes a new record to a dataverse table then navigates to the next screevn. On that screen I have a lbl that is supposed to show the last Generated Placement ID. This is the code I am using for the text property of that label.

Last('Placement IDs -DEVS').'Generated Placement ID'

This used to work but now doesn't. It is stuck showing the same record which is Generated Placement ID 0005. Below is the table. As you can see the new records are successfully added but my code is not grabbing those. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Hi @futr_vision

Try this:
First( Sort( 'Placement IDs -DEVS', 'Generated Placement ID', SortOrder.Descending ) ).'Generated Placement ID'
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
futr_vision 831 Moderator on at

Like (1)

Report

This works. A little more verbose than I expected but I can't complain.

Was this reply helpful? Yes No