Making collection properly

[RobGas]

Hello!

I have ran into an issue where I'm trying to collect information from a gallery into a collection so I can export it to CSV/Excel. And I'm using LOOKUP() to find product name, but in collection it shows it as a table rather than a text value. Any advice on how I could export this gallery to Excel (doesn't have to be a collection if there is an easier way). I've also tried a different method of using Power automate flow and it worked to get the data, but I couldn't get the ProductName and barcode since it doesn't get saved in the table.

Any tips/help/ideas will be greatly appreciated.

[v-qiaqi-msft · Accepted solution]

Hi @RobGas,

Could you please tell me that how you set the Items property of the Gallery and what is the column type of the Product Name in your data source?

Actually, if you want to access to values within a nested table from a collection, you should reference to the nested column within the table, like if you have a Choice column within your gallery, a nested column named Value will display like a nested table within the collection. You could create a new collection by AddColumns() function so that you could save the nested table value by reference to ProductName.Value

ClearCollect(colsss,AddColumns(colppp,"Nested",'Record Type'.Value))

[RobGas]

Hi @v-qiaqi-msft ,

Thank you for responding. I will do my best to give you all the information you asked for so if I have misunderstood something please let me know.

This is how I make the collection

Then I have the Name column and the barcode column as lookups like so:

And as the source for the Pname which lookup is working 'Product' dataverse table it is a single line of text same for the barcode column.

But since we use lookup for the column to get the current information it makes the column in collection a table rather than a value like so 

But the problem is that I'm not sure how to export all this data to an excel/csv file. Since it doesn't recognize it as a column text but a table itself. I have made a very shady workaround currently which works, but its very very shady.  If you know how I can turn a csv file into an excel in power automate that could also help me resolve this issue. But I rather do it the proper way.