Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

OnStart ClearCollect from SQL table - no content loaded

Hello there,

I have quite some trouble to load data from a SQL-Table to a collection.

OnStart I use the following: ClearCollect(dimLeiter;'[inspdeve].[winlineprodukteleiter]')

Issue is, that the coumnnames are loaded correctly, but the contect is not loaded.

Any idea how to solve it? Database is a MariaDB

Thanks and regards



Solution Supplier
Solution Supplier



Can you try using the Screen's OnVisible property and not the App OnStart?

Frequent Visitor

Unfortunately the same result. Labels are loaded correctly, but the content is missing.

I'm using a dropdown to test it. Items are dim_leiter.LeiterHersteller.
LeiterHersteller is underlined blue with the following message:

Warning. The columns generated by this rule are all nested tables and / or records, but the property expects at least some columns with simple values (such as text or numbers).

Do you know what it means?

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,737)