Export dropdown value to excel

(0) Share

Report

Posted on by raindance

I want to export my data from a dropdown to Excel.

This is a snippet of my export to Excel formula:

Clear(CollectionCSV);

ForAll(
 Gallery1.AllItems As colCSV,
 Collect(
 CollectionCSV,
 {
 Dropdown: colCSV.Dropdown,
 }
 )
);

Set(varFileLink, ExporttoExcel.Run(JSON(CollectionCSV)).filelink);
Launch(varFileLink);

This exports successfully, but the value in the spreadsheet is the ID of the dropdown value I think, not the dropdown value itself.

Dropdown: colCSV.Dropdown.Selected.Value

shows the error

Name isn't valid. The identifier isn't recognized.

so I'm stuck on how to fix this. Is there any way to fix this?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

WarrenBelz 156,421 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@raindance ,

What are the Items of the dropdown?

Was this reply helpful? Yes No
raindance 15 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
The Items are values from a Dataverse Table column.

Was this reply helpful? Yes No
WarrenBelz 156,421 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@raindance ,

I need the actual Items code.

Was this reply helpful? Yes No
raindance 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you mean the ComboBox's Items value? Its just the name of my Table.

Was this reply helpful? Yes No
WarrenBelz 156,421 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@raindance

What is the name of the field it is displaying - you need

colCSV.FieldName

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.

Was this reply helpful? Yes No
raindance 15 on at

Like
a
(0)

Report
Copy link

Link copied!
I'm still not sure what you mean, so I'll just show screenshots of what I have:

So I'm trying to export one of the values in the third screenshot. I'm unsure what you mean by the name of the field it is displaying, but I think you mean the Coating column. I tried
colCSV.Coating.Selected.Coating
but that didn't work.

Was this reply helpful? Yes No
WarrenBelz 156,421 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@raindance ,

Amended in my earlier post. Collections simply have fields - a drop-down is the control that sets it.

Was this reply helpful? Yes No