Default input to most recent entry for that particular user

(0) Share

Report

Posted on by ConnM

260

Hello

I am making a booking app, and to speed things up for the user I would like to have default values for car parking.

I want the value for the Make and Model datacard, let's call it DataCardValue2, to default to that of the last entry by the current user.

The current user is in ComboBox1, its default is

{ 
 DisplayName:User().FullName,
 Claims:"i:0#.f|membership|" & Lower(User().Email), 
 Department:"", 
 Email:User().Email, 
 JobTitle:"", 
 Picture:""
}

Something that prepopulates the default, or places the last entry by that user in a little box under the input like in many online forms.

Any help would be appreciated

Conn

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ConnM ,

Could you please share more details about your scenario? What data source are you using? Is it a SharePoint list?

If you are using SharePoint list as data source, please find the DataCardValue2, set default as follows:
First(Sort(Filter(SPList, User.Email = User().Email), ID, SortOrder.Descending)).'Make and Model'

Best regards,
Rimmon Li

Was this reply helpful? Yes No
ConnM 260 on at

Like (0)

Report
Copy link

Link copied!
Thanks Rimmon Li

It is indeed Sharepoint. This worked, and it is delegable!
It need a slight tweak to match the columns in my list for the user
First(Sort(Filter(SPList, 'Created By'.Email = User().Email), ID, SortOrder.Descending)).'Make and Model'

Thank You Very Much
Conn

Was this reply helpful? Yes No