Export to Excel Gallery items using Power Automate

(0) Share

Report

Posted on by AdityaDani

I was following this awesome YouTube Guide for this requirement.

https://youtu.be/tQCBWMR7T64

But after following everything I am having these issues:

1- The exported file table headers are not reflecting the actual column names.

Rather they are showing Field_1...2...3...4..etc.

My data Source is SharePoint List. WhatsApp Image 2022-07-31 at 11.01.08 PM.jpeg

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

Just wondering did you make this list in an excel then import it into a sharepoint list as there is a known issue that makes them into field names like this behind the scences or did you make the list in sharepoint directly?

Was this reply helpful? Yes No
Kimii 134 on at

Like (0)

Report

Hi @AdityaDani
In PowerApps could you show your OnSelect which is used for Flow Content input data (collection) ?
Also, how did the result appear in Create csv table after you run the flow?

Like this

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (1)

Report

Yes sir,

I've created the SharePoint List by importing it from an Excel file.

Also, I read in the community that it has something to do with Large column size (My column name is avg 20 Characters long. Except for the "Group" column which you can see printed correctly.

If that is the case, do you advice me to create that List manually?
I have 200+ Rows and 15 Columns.
Any way I can do this manual task more easily?

Regards.

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like (1)

Report

Yes I would create it manually as that is likely the cause of the problem. try and test this process with a columns or list you manually added.

I would then try to import the data in sometimes I use Power automate to help upload if there are a lot of rows but there are a few ways.

I would confirm what i described, is the issue by trying the export method you used on a manually created list 🙂

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (0)

Report

Please check out the video Guide on my initial post. I have followed everything there.
I did add things out of my own as the Video was using a Collection as Gallery data source.
But i am using sharepoint List as a data source for the same.

Let me know what do you need after going through the video

Was this reply helpful? Yes No
Kimii 134 on at

Like (0)

Report

As the video, get all list item and change its rows name as you want:

Clear(collection);
ForAll(DataSource.AllItem, Collect(collection, {Group: ThisRecord.Group.Value, <RowName1>: ThisRecord.field_11.Value, <RowName2>: ThisRecord.field_3, <RowName3>: ....... });
Flow.Run(JSON(collection, JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes))

Hope it can help,

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (0)

Report

Yes, i've done that . If you see AJ_Z reply he knows about this bug for the column names.

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (0)

Report

Thanks, can I have any resource to refer from for the Power automate flow to automate the list creation?

Was this reply helpful? Yes No