Reference, in a text box, the first value in the first row of the first column of a collection?

(0) Share

Report

Posted on by Brian-M

437 Super User 2024 Season 1

I have a collection (colMaxDate) that just has a single value. The maximum (most recent) date from a sql table column. After I submit new data to that table, I clearCollect to get the latest date. So, how do I reference that single value (column name is just "Value") in a text box?

I tried to do this with just some code in the text field but after I submit data to the table, the text field doesn't update itself. So this is my attempt at getting that field to update. For reference, the field reads, "Last Seat Creation Date: 12/11/2024".

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (1)

Report
You can use the First() function to get the record and then access the field by name.

first(colMaxDate).Value

That will give you the full String. YOu'll probably then need to wrap that in a Last(Split()) of that value to get the actual date if that's all you want.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

AndrianaO 213 Moderator on at

Like (1)

Report

Hi, can you try to set Text property of your label as follows:

"Last Seat Creation Date: " & LookUp(colMaxDate,!IsBlank(Value), Value)

Let me know if this works!

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

Thank You, both solutions worked!

Was this reply helpful? Yes No