Answered

Lookup the latest from Sharepoint based on 2 conditions.

(0) Share

Report

Posted on by Linmuel

Im trying to get the latest entry of a particular station in a particular cell(line)

I plan to do this in a pop-up box and repeat the process in 3 separate text boxes.

So Im getting my lookup data from "Daily Data" and basing my condition on the last entry of that station in that cell

Here's my code for the comment box:

LookUp(Sort('Daily Data',Date,SortOrder.Descending),stn_drp.Selected.Value && Cell_drp.Selected.Value,Comment)

I dont get any error but I also get blank on those text boxes. Is there anything I'm missing?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Linmuel ,

I am assuming the two field names here and also that they are Text fields.

LookUp( Sort( 'Daily Data', Date, SortOrder.Descending ), stn = stn_drp.Selected.Value && Cell = Cell_drp.Selected.Value ).Comment

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Linmuel 14 on at

Like
a
(0)

Report
Copy link

Link copied!

You are so wonderful! It worked like a charm! Thank you very much!

I'm learning a lot as I go as well ^_^

Was this reply helpful? Yes No