Default Dropdown control to current user's last selection

[AppNewbie]

I have a desk booking canvas power app that works perfectly (yey).  Then I was asked if the office location dropdown selection could just default to the current user's last selection?  So, if the current user selected Denver when they used the app a month ago, when they go to use the app again (in a browser or on a cell phone), it recognizes them and displays the office location they last selected.  I've been researching, testing, failing, repeat for weeks and am exhausting all resources.  Any help is greatly appreciated!  All the data is stored in Sharepoint, every completed desk reservation is recorded to a reservation list, and the Locations are in their own Sharepoint list as Choices (allowing only one selection).  Thank you!  

[rpersad]

What you can do is lookup in the sharepoint list the last record submitted by the user and get the Location and set it as the Default value.

[Devvj]

Hi @AppNewbie 

You could probably use something with this or similar logic

FirstN(Sort(Filter('Reservation Table', Owner = User().Email), Created, Descending), 1).Locations.Value

You ofc need to tweak some of the names 🙂
But hopefully you can get some idea out of the example above

[AppNewbie]

Thank you, however I don't know how to write a lookup nor do I know where that should go in the app.  Can you please assist further?

[AppNewbie]

Thank you.  I tried your solution, placing it in the Default control for that field and it didn't work.  I really don't know how to customize this to my data.  The table is called Desk Reservations, the office locations are in a list called Locations (which is populating the drop down), the column in the table is also named Locations.  The user's name goes in a column called ReservedBy, and when I try to sort the Modified column (as you have) the whole thing creates an error.

[rpersad · Accepted solution]

Try

Last(Filter('Desk Reservations', ReservedBy.Email = User().Email)).Locations

• The Last function gets the last record in the List.
• The filter function searches for all records where the ReservedBy email is equal to the active user's email. NOTE: This is assuming the ReservedBy column is a people picker column. If it is a Text field you would have to compare the column with the value User().FullName. Though I would suggest to use a people picker and compare using emails given that their emails would always be unique but there can have multiple people with the same name.
• The .Locations will return the value in the Locations column.

[AppNewbie]

rpersad, you are a LIFE SAVER!  This worked perfectly!  Thank you so much for the code and the great explanation, you made my day...and more!

[rpersad]

No problem glad I could help 👍