Get last update value based on modified date

(1) Share

Report

Posted on by Shivaandure

Hi,

I am trying to get the latest value of a column ('Update'), based on the last modified date or by recent timestamp value.

I tried below formula in Input field value and getting blank data

LookUp('Data File', 
    'Project Name' = Label1.Text && 
    'Modified' = Form1.LastSubmit.Modified,
    'Update'
)
 
Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi Shivaandure

To get the latest matching value (I have to assume here that Form1 has been submitted at least once during the session).
LookUp( Sort( 'Data File', 'Update', SortOrder.Descending ), 'Project Name' = Label1.Text && 'Modified' = Form1.LastSubmit.Modified, 'Update' )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi Shivaandure,

Like WarrenBelz assumed, for your way to work, it is required that the form is submitted at least once during the session. You can try the following code to get the value from Update column which was last stored for your project:

First( SortByColumns( Filter('Data File', 'Project Name' = Label1.Text), "Modified", SortOrder.Descending ) ).Update

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Just following up to see if you received the answer you needed, or if you require further assistance. Also to clarify another issue, by latest, do you mean the latest date in the Update field or the latest date the record was modified (it may have been changed on another field since the Update date)

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No