cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DIECKBE
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

 

Benny

2 REPLIES 2
PTBBSolutions
Solution Supplier
Solution Supplier

Hi @DIECKBE ,

 

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

DIECKBE
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

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

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 (3,114)