cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeanshak
Level: Powered On

How can I load data from a table into a collection?

I tried the following:
Tabelle1_1 is a table from a connection:
LocBVGewerke is the collection.


ClearCollect(LocBVGewerke; Defaults(Tabelle1_1));;

SaveData(LocBVGewerke; "LocBVGewerke");;

best would be also to filter the data before load into the collection - for example:  ForAll(Tabelle1_1, If( condition on table, .... )

ANY IDEA ???? 

 

 

Jens Rogge
1 ACCEPTED SOLUTION

Accepted Solutions
jeanshak
Level: Powered On

Re: How can I load data from a table into a collection?

Found Solution ! 

inkl. store on the device! 


Clear(LocBVGewerke);;
ClearCollect(LocBVGewerke; Filter( Tabelle1_1; Value(blnr)=Value(BLDropDown.Selected.BLNR) ));;
SaveData(LocBVGewerke; "LocBVGewerke");;

Yeah!

Jens Rogge

View solution in original post

3 REPLIES 3
jeanshak
Level: Powered On

Re: How can I load data from a table into a collection?

Found Solution ! 

inkl. store on the device! 


Clear(LocBVGewerke);;
ClearCollect(LocBVGewerke; Filter( Tabelle1_1; Value(blnr)=Value(BLDropDown.Selected.BLNR) ));;
SaveData(LocBVGewerke; "LocBVGewerke");;

Yeah!

Jens Rogge

View solution in original post

rgparisoto
Level: Powered On

Re: How can I load data from a table into a collection?

Hi Jens!

 

I have the same problem here, but I want to input only four columns at the collection. 

 

Do you have some idea about how to to it?

 

Best regards from Brazil.

 

Robson.

Highlighted
JacorA
Level: Powered On

Re: How can I load data from a table into a collection?

Use DropColumns(Filter('your source';'your filter');"first column name to drop";"second column name to drop")

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Demo Extravaganza Championship Voting Open

Voting Ends: October 30, 2019!

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 180 members 4,557 guests
Please welcome our newest community members: