cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
79
New Member

Data items is not supported

Hello all,

 

Could you please help me to solve this issue. Currently I'm having gallery items which are showing all ok. Then I'm trying to export my gallery to excel I use function:

Set(
varFileLink,
ExcelExport.Run(
JSON(
BrowseGallery1.AllItems,
JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes & JSONFormat.Compact
)
).filelink
);
Launch(varFileLink)

 

Everything is working all find. The problem is that my data is bad for fields which has this error. Basically in gallery information looks like that:

79_0-1634123432227.png

When I check Gallery.AllItems it show me that:

79_1-1634123454468.png

But when it is exported to excel file it appears as number values:

936980005
936980005

I would like to have it as text values as in first image. Maybe you could advise me what to do?

2 REPLIES 2
StalinPonnusamy
Community Champion
Community Champion

Hi @79 

 

To get the value, you may need to collect the data in the collection and export it to excel like

 

Clear(ColExportToExcel);

ForAll(Gallery1.AllItems, Collect(ColExportToExcel, {Status: Dropdrop1.Selected.Value, Name: Test}));
ExcelExport.Run(ColExportToExcel..

 

Refer to this video for more details

StalinPonnusamy
Community Champion
Community Champion

Hi @79 

 


Please let us know if anything needs on your post. We can help with this.

Please do not forget to give kudos if you find the suggestion helpful or Accept it as a solution if works fine to help other users to find it useful.

Thanks,
Stalin - Learn To Illuminate

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

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