cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Dropdown field is initially blank

Hello, I have been a software developer for 20 years but I am brand new to PowerApps.

 

I have a Sharepoint Online list with a Lookup column in it that gets data from another Sharepoint list. I have no problems with the list or lookup column when using Sharepoint Online.

 

But, PowerApps does not populate the dropdown field the first time the screen is accessed, it is blank, the other fields (Textboxes) are populated as expected. I have to manually click the dropdown to get the lookup data to populate, then the dropdown functions as expected for each record (the lookup value is in the dropdown).

 

I can put a Label on the datacard and it populates every time with the list data, but the dropdown is blank (on the first record). The dropdown requires a manual click to open the connection to Sharepoint Online the first time the Edit screen is accessed.

 

What am I doing wrong?

 

Is there a way to force the dropdown to get the Sharepoint lookup data before the dropdown populates so that the dropdown will have the lookup data the first time I access the Edit screen?

 

Thanks in advance for your help.

--Chris

13 REPLIES 13

@AlexN,

I have created a custom connection to get data from a web API

Which is working good and when i test I'm able to get data.

But when i try to create a collection and get data into collection, it shows nothing on collection.

Can someone help me how to get data into collections from custom connector.

Thanks,

MK

@Shanescows

I have created a custom connection to get data from a web API

Which is working good and when i test I'm able to get data.

But when i try to create a collection and get data into collection, it shows nothing on collection.

Can someone help me how to get data into collections from custom connector.

Thanks,

MK

ultimasoft
New Member

If(Form1.Mode = FormMode.New,First(Choices([@List].Field)),ThisItem.Field)

Hi @JRaasumaa 

 

I have created a tabbed form where different cards are visible depending on which tab (button) is selected. To achieve this I already have a formula for OnVisible.

GraemeNZ_0-1636323045565.png

 

Can you please advise the correct syntax to combine this OnVisible formula with the one you have proposed in your solution?

 

Cheers, GraemeNZ

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,398)