cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wendy1
Frequent Visitor

Datasource Blank - Formula Error

Hi, I need help with my PowerApps.

 

I have a dropdown control with this code below linked to the onchange property of the dropdown control. I reference a datasource called Program Metrics. The formula doesn't pull up the datasource. 

 

wendy1_0-1656421839246.png

-dropdown datasource (which doesn't work)


I know the datasource works because when I highlight my form's datasource (which is the same as the dropdown) it works. I checked the dropdown and highlighted the datasource again and it says "We didn't find any data". I don't know what happened because it worked a few days ago.

 

 

wendy1_1-1656422126922.png

-form datasource (which works and the same as the dropdown)

1 ACCEPTED SOLUTION

Accepted Solutions
phipps0218
Super User
Super User

Where is this collection being set? On App start or on visible property?

View solution in original post

6 REPLIES 6
phipps0218
Super User
Super User

Does it actually appear in the collection? Go to File > Collections.

I just checked and it doesn't

phipps0218
Super User
Super User

Where is this collection being set? On App start or on visible property?

wendy1
Frequent Visitor

I use the collect function on the Screen's onvisible property. The formula creates a new collection based on my datasource. My datasource isn't being read on that formula and I don't know why. It works on other formulas.

wendy1
Frequent Visitor

Sorry! I figured it out. It ended up being a noob mistake on my end. One of my variable in my formula was not pointing to the right place.

phipps0218
Super User
Super User

At least you have it sorted!
Please accept the solution for this to be marked as completed.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (3,152)