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

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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 256 members 6,854 guests
Please welcome our newest community members: