web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Return previous record...

Power Apps

Unanswered

Return previous records when dropdown option is selected

(0) Share

Report

Report

Posted on by TIM_F

Hi there... very new and trying to build a power app front end to capture Coaching Sessions conducted. Part of the capture content is that i'd like for historical coaching session information to become available to the Coach, as soon as the Coachee is selected from the dropdown.

COMBO_DB is the current database containing all the records and is the one i want to push the data into

COACHEE is a table with all the Coachee's in it

Dropdown.Coachee is the dropdown box where Coachee can be selected

DATE, NOTES and ACTIONS are the three columns of historical data i'd like to return.

I have tried using Lookup but got lost and also tried First(SortByColumns(Filter(Combo_DB,Coachee=Dropdown.Coachee.Selected.Result),"Created",Descending)).Notes which i took from another powerapp post... but no luck.

Any assistance would be gratefully appreciated.

Regards..TimF

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TIM_F ,

Probably something like this

LookUp( Sort( Combo_DB, Created, Descending ), Coachee='Dropdown.Coachee'.Selected.Result ).Notes

Also you should avoid using full stops . in names

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

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @TIM_F ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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

Was this reply helpful? Yes No

Join the conversation