web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Adding data from a Flo...
Power Apps
Unanswered

Adding data from a Flow to a ComboBox.

(0) ShareShare
ReportReport
Posted on by stapes 894

I am having problems getting my ComboBox to display any data.

I have built a Flow that returns a table of two columns using an SQL Stored Procedure. This has been run & tested successfully.

I have added the following to the OnVisible Property of my Screen:

 

ClearCollect(lookupYears, LookupAllYears.Run())

 

In my ComboBox Properties, I have added lookupYears as my Data source, Layout Double, and set Primary text, Secondary Text & SearchField.

 

In Items I have lookupYears.

 

When I run this - there is no data in my ComboBox. What am I missing?

 

Update:

 

This is the first form in a series. When I returned to the form, the data loaded correctly. It would be appear that OnVisible does not work first time!

 

 

Categories:
Building Power Apps
  • v-siky-msft Profile Picture
    v-siky-msft Microsoft Employee on at

    Hi @stapes ,

     

    How do you open your form screen at the first time?

    Have you ever tried to close the app and restart it again to check if the OnVisible property works?

    If you just the click the Play button in the web studio when editing, the codes in OnVisible property won't run,  they need to run after the screen appears, in another word, they need to go through a screen transition.

    You also can put the codes to OnStart property, and click Run OnStart button to debug your codes conveniently.

    Annotation 2019-11-25 114004.png

    In addition, you can check the Runs status of Flow to check if your flow has ran?

    Best regards,

    Sik

     

  • AnneZC Profile Picture
    AnneZC 65 on at

    Hi @stapes 

    In the app editor, if you start your app and transition to this screen, have you tried using View/Collections to see whether your collection has successfully populated at this point? I find this really useful.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 394 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 324 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans