Auto-fill choice field based on users last selection

[b1t1]

Hi!

I have a customized form and trying to speed up the item creation process as much as possible for the users. I have a problem with a choice column in which they specify a location. They need to be able to choose location of course but 95% of the time while entering a new item the location will be the same for that given user that given day.

So I tried setting a variable on startup to save logged in users email and then, on DefaultSelectedItems property of choice column (datacardvalue), I tried finding that specific users last selection (on previous item/row) and put it as default. I can't get it to work properly.

App -> OnStartup (Does this work on customized form?)

Set(varUserEmail, User().Email)

datacardvalue6 -> DefaultSelectedItems

First(SortByColumns(Filter('TEST Temporary badges | Admission', 'Created By'.Email=varUserEmail),"ID", Descending)).Location

  

Notes:

- About 8-15 people will be editing the same list at the same time, creating their own items and editing items created by others. They all use different locations and sometimes the same location.

- The list will probably go way above 2000 items, so functions need to be delegatable

- Location data (the choices) are not available through office365user catalogue

 

 

Follow-up question: On Default property on hour and minute fields I have the Now()-function, but it only works if you refresh the webpage. It doesn't refresh when I click new item. How do I fix that? So time sets accordingly when pressing new item.

[WarrenBelz]

Hi @b1t1 ,

Assuming Location is a Choice field - this should be Delegable

{
   Value:
   LookUp(
      Sort(
         'TEST Temporary badges | Admission',
         ID,
         Descending
      ),
      'Created By'.Email = varUserEmail
   ).Location
}

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

[Louicha]

Hey @b1t, 

have you already tried to save the last location data via SaveData? SaveData, LoadData, and ClearData functions in Power Apps - Power Platform | Microsoft Learn

[b1t1]

I thought Lookup wasnt delegable?

(and why does it start with "{"? Doesn't look like a normal function, can I just put it in DefaultSelected property?)

[b1t1]

No, will try.

"These functions depend on the collection being implicitly defined with Collect or ClearCollect."

Does this mean i have to create a collection somewhere before I save? What's the point of it's already saved in collection? 🧐

[WarrenBelz]

Hi @b1t1 ,

There are two issues here - firstly are you wanting the user's last choice in this session (not what they did the last time they logged in). Note that SaveData/LoadData does not work in Power Apps when run in a browser (so you cannot get the last session). If it is the last selection (in the current session) you are wanting, then the DefaultSelectedItems can certainly reflect this as I posted. Two things - LookUp is certainly Delegable as a function providing the query within it is also Delegable (the item I posted is). Secondly a Combo Box content is a Table and assuming the Items are a Choice column, then you need to stipulate {Value: DefaultValueRequired}. If the Items are something else, Value may be different, but {} is still required.

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

[b1t1]

  Hmm.. Didn't work. See screenshots. I tried entering several new items but default location was always blank.

[WarrenBelz]

@b1t1 ,

Put this on a Label and see if you get the last Location you created

LookUp(
   Sort(
      'TEST Temporary badges | Admission',
      ID,
      Descending
   ),
   'Created By'.Email = varUserEmail
).Location

The DefaultSelectedItems syntax is correct - just ensure you have a value to put in there. I assume this is a single choice Combo Box.

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

[b1t1]

Ehm, I don't know how. Label (Text) expects text, not a function, so I'm just getting an error.

But yea, I also suspect that I'm not getting a value from the 'created by' column, or something wrong with creating a variable OnStart (App) - does this work on customized forms? I also tried showing/hiding the created by column in the list and it does contain my user info.

[WarrenBelz]

@b1t1 ,

What type of field is Location ? If it is Text (as I assumed from your posts), then that is valid code. If it is a Choice column (which is what I think the issue is)

LookUp(
   Sort(
      'TEST Temporary badges | Admission',
      ID,
      Descending
   ),
   'Created By'.Email = varUserEmail
).Location.Value

If this works. include it in your DefaultSelectedItems code as well.

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