Answered

sorting a lookup column

(0) Share

Report

Posted on by maschrag

So I have a gallery that populates correctly. Within the gallery I have a column for “STATUS” … that column does a lookup to another table … and gets a last scheduled date. I want to compare that date against today’s date to return an “ACTIVE” or “INACTIVE”.

If (

LookUp(‘lookuptable’, CUST_NUM = ThisItem.CUST_NUM && LAST_UPDATE_LOC = ThisItem.LAST_UPDATE_LOC, SCHEDULE_DATE) >= Today()

"ACTIVE",

"INACTVE"

)

The lookup might have more than one row to return, but will only return one row. How can I sort the SCHEDULE_DATE to return the most recent? Currently it is pulling just the customer's first date.

Tried many ways without success. Even tried to put ‘ && SCHEDULE_DATE >= Today()’ in the formula … but that didn’t work either.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @maschrag ,

The latest date should work with this

If( LookUp( Sort( ‘lookuptable’, SCHEDULE_DATE, Descending ), CUST_NUM = ThisItem.CUST_NUM && LAST_UPDATE_LOC = ThisItem.LAST_UPDATE_LOC ).SCHEDULE_DATE >= Today(), "ACTIVE", "INACTVE" )

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.

Visit my blog Practical Power Apps
maschrag 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the solutions!!! Got another question if I may ....
Since I am using an IF function ... before the lookup completes ... the default values is false ... so INACTIVE is initially displayed ... than flips to ACTIVE mid load. Is there a way to not display the status until the entire lookup completes? So the end user doesn't see INACTIVE and than a flip to ACTIVE before their eyes?
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @maschrag ,

Not unless you want to hide the field on a timer and display it a period after you have change the affected field.