DropDown to Excel

[ShanP]

I want to export my data from a dropdown to Excel. This works fine for normal text, but for dropdowns its not working. It says because the dropdown value that the user selects is not text, a number or a boolean. Is there any work around for this?

[v-micsh-msft · Accepted solution]

Hi ShanP,

Could you please share the formula that you used to export the Dropdown Value to Excel (better with a screenshot)?

We could reference the Dropdown selected value by the following code:

Dropdown1.Selected.Value

Further, if you would like to access all the Dropdown values, you need to work directly with the Items value configrued under the Dropdown control.

Dropdown control in PowerApps

Post back if you have any futher questions.

Regards,

Michael