Unanswered

How to keep selected dropdown list item when open the app

(0) Share

Report

Posted on by wusian1203

Hi Everyone,

I have a problem when i edit a record, the dropdown list field(called USER_NAME_SPS from Onedrive) seems will refresh and get first person name, instead of get the original record from Onedrive(Pictrue 1&2). But the problem only happen on opening the app at first, when i edit another record, the dropdown list field works normally.

My dropdown list field is searched by a textinput box, and default the textinput box:Thisitem.USER_NAME_SPS.

And set the dropdown list's item property:Office365Users.SearchUser({searchTerm:TextInput1.Text,top:999}).

I tried these ways below, but they are still unworkable. Have any other solution? Thanks.

1. Set the card's default: EditForm1_3.LastSubmit.USER_NAME_SPS(Picture 3)

2. Set the dropdown's default: EditForm1_3.LastSubmit.USER_NAME_SPS(Pictrue 4)

Pictrue 1:Edit a record

Pictrue 2:In edit form, USER NAME's dropdown list value is not correct

Pictrue 3:

Pictrue 4:

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wusian1203 ,

Your issue came from the LastSubmit property you used on Default property of the dropdown list.
The LastSubmit property keeps info from the current session of the running app.
If you check the value of LastSubmit property of your form when the app starts you will receive a empty record.
With a empty record used as default for DropDown control, you'll get in dropdown the first item from your items property.

I guess that the best way to solve it is to set the Default property of DropDown Control to:
First(Office365Users.SearchUser({searchTerm:ThisItem.USER_NAME_SPS}).value).DisplayName

Hope it helps

Was this reply helpful? Yes No
wusian1203 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gabibalaban,

Thanks for your reply.😊

I tried your solution, set the Default property of DropDown Control like this:First(Office365Users.SearchUser({searchTerm:ThisItem.USER_NAME_SPS}).DisplayName).DisplayName.
(I used DisplayName because I could not use "value", it will have an error message. (Picture 1))

But it is unworkable again, the dropdown list still get first item.

Picture 1

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@wusian1203
So sorry, I was in a rush ... It's about Version2 of searchuser:
First(Office365Users.SearchUserV2({searchTerm:ThisItem.USER_NAME_SPS}).value).DisplayName

If you still want to use SearchUser (my thoughts is that will be deprecated soon), use:
First(Office365Users.SearchUser({searchTerm:ThisItem.USER_NAME_SPS})).DisplayName

Was this reply helpful? Yes No
wusian1203 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @gabibalaban

Sorry for replying late
I tried this you suggested:First(Office365Users.SearchUserV2({searchTerm:ThisItem.USER_NAME_SPS}).value).DisplayName
But it still unworkable, the dropdown list still get first item.

So I limited the submit when USER_NAME=fisrt item temporarily, can't submit success until user choose correct item.
Thanks for your help😊

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@wusian1203
Use my formula without .DisplayName at the end.

Was this reply helpful? Yes No
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@wusian1203
Use my formula without .DisplayName at the end ...

Was this reply helpful? Yes No