Answered

Default Dropdown control to current user's last selection

(0) Share

Report

Posted on by 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!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Devvj 1,132 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
AppNewbie 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
AppNewbie 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

rpersad 831 on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
AppNewbie 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
rpersad 831 on at

Like
a
(0)

Report
Copy link

Link copied!

No problem glad I could help 👍

Was this reply helpful? Yes No