web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown with a defaul...

Power Apps

Answered

Dropdown with a default value in edit form

(0) Share

Report

Report

Posted on by AldoFra

7

Hi!

I want to setup a dropdown with a default value in edit form.

I have two List with OneToMany relation:

User{ ID, Name, Surname}
Book{ID, Title, Author, ID_User}

In the edit form of book i load the dropdown value with Choices([@Book].ID_User).

In the DefaultSelectedItems i have Parent.Default (example: 201, soo this is the corespondent User) but i want to setup another correspondent User(for example the ID_User 52)

I try with a LookUp and Filter but not work.

How can i setup?

Thanks

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AldoFra :
Could you tell me what your data source is?SharePoint list or CDS entity?
I assume they are entities,and the relationship between User and book is 1:N.
I assume ID's data type is number
Please try this solution:
Set the combobox's DefaultSelectedItems to:

LookUp(Choices([@Book].ID_User),ID=52)

Or

LookUp(User,ID=52)

Best Regards,
Bof
AldoFra 7 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi. Thanks for the reply and the solution.
Yes, is a one to many relation and a SharePoint List.
I try with your first solution and it work.
LookUp(Choices([@Book].ID_User),ID=52)

Thanks!

Join the conversation