Autofill (pre-populate) form data from dropdown selection

Like (0) Share

Report

Posted on 8 Nov 2021 10:32:09 by acolyter

Hi,

I have a problem with autofilling (pre-populating) information based on Microsoft Lists record. First, I created a Canvas app in PowerApps. I then created a dropdown and other form attributes. Based on selected value in dropdown, PowerApps form is automatically looking up Microsoft list record and auto fill the other form attributes.

The problem is, when there is only one record in that dropdown, it doesn't work. Even if I click on it, still nothing, it stays empty. Every time I load the app I need to select different value so it starts working.

Any solution for this?

Thanks!!

Categories:

General Questions

All responses (4)

Answers (1)

acolyter 92 on 08 Nov 2021 at 12:16:02

Like (0)

Report

Re: Autofill (pre-populate) form data from dropdown selection

Perfect, that works, thank you!
Verified answer

PTBBSolutions 691 on 08 Nov 2021 at 11:57:26

Like (1)

Report

Re: Autofill (pre-populate) form data from dropdown selection

@acolyter ,

Have you set-up the AllowEmptySelection of the dropdown to true? If no, if you have only 1 value in the dropdown, it will always be displayed by default and there is no way to change it so you can trigger the OnChange event.
acolyter 92 on 08 Nov 2021 at 10:57:35

Like (0)

Report
Re: Autofill (pre-populate) form data from dropdown selection

@PTBBSolutions

Hi,

thank you for your reply.

The source is Sharepoint List and the column is a single line text called 'Name'.

The dropdown has 2 settings - Items is set to:

Distinct(Filter(Catering, StartDate > Now() And Organizer.Email = User().Email), Name)

On change is set to:

Set(UdalostVar,LookUp(Catering, Name = UdalostDDL.Selected.Result))

When there's 2 or more items in the list (so there's 2 or more in the dropdown menu), everything works just fine. When I select the name, it automatically pre-populates other fields. But when there's only 1 record in the dropdown menu, even if I click on that event, nothing happens (the fields that should become pre-populated stay blank).

Thanks!
PTBBSolutions 691 on 08 Nov 2021 at 10:49:30

Like (0)

Report

Re: Autofill (pre-populate) form data from dropdown selection

Hi @acolyter ,

Can you please provide some code examples and some screenshots of your set-up to better understand what the issue is?

What is the source of the dropdown?