cancel
Showing results for 
Search instead for 
Did you mean: 

PowerApps: Get and save multiple selection values to Excel

Introduction

Getting combo box values from an Excel spreadsheet stored in OneDrive is easy, however, saving multiple selected values to Excel does require a formula. This blog describes how you build that formula.

 

Excel spreadsheet

The Excel spreadsheet is stored in OneDrive. 

 

Capture3.PNG

 

The spreadsheet contains two sheets,Selections and Misc

 

Capture4.PNG

 

Misc is where the values for lookup are stored. Drink, Meal and Desert are the three columns which are used as lookup for mulitple selection in the PowerApp

 

Capture5.PNG

 

Multiple selected values in PowerApps are stored as semi-column separated values in the select sheet

 

Capture6.PNG

 

PowerApps

This video provides a step-by-step process on how the formula needs to be applied to save the multiple selections to the Excel spreadsheet. Here are the screenshots of the two formulas that are used.

 

Capture.PNGCapture2.PNG

Comments

Hi,

I triyed combobox values to be saved into Dynamics crm multipicklist option set but not working.

 

Meet Our Blog Authors
Labels