cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alexjunior25
Regular Visitor

Extract tables from a collection

I'm having trouble extracting data from each table in this collection. I've looked for functions like ungrouping and not obitive success. The idea is to create a collection to save the data to a sharepoint list, but each item on a line.

 

alexjunior25_0-1610069391089.pngalexjunior25_1-1610069417079.png

alexjunior25_2-1610069550491.png

This is the form that feeds the collection

3 ACCEPTED SOLUTIONS

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @alexjunior25 ,

You have a table (complex field type) in the field you want to collect and want all the values in a field in a table, try this syntax

Clear(colYourCollection);
ForAll(
   YourListName,
   Collect(
      colYourCollection,
      YourFieldName
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

Hi @alexjunior25 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Sorry for the delay ... It worked! Thank you for your help. And it was great to have found this community here.

View solution in original post

5 REPLIES 5
WarrenBelz
Super User
Super User

Hi @alexjunior25 ,

You have a table (complex field type) in the field you want to collect and want all the values in a field in a table, try this syntax

Clear(colYourCollection);
ForAll(
   YourListName,
   Collect(
      colYourCollection,
      YourFieldName
   )
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

 

View solution in original post

thanks! however, I still have a doubt: apply this solution to all fields? sku, brand, route ...? I confess that I didn't understand the code very well.

@alexjunior25 ,

Yes, you would need to repeat it for each fields with a different Collection Name.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi @alexjunior25 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Sorry for the delay ... It worked! Thank you for your help. And it was great to have found this community here.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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