Answered

Update excel datas from Combobox

(0) Share

Report

Posted on by PierreJeanjot

Hi everyone, it is the first that I use PowerApps.

I would like to know to fill the box Update of the datacard with a Combobox with multiple selection. Datas are in an Excel file and the name of the column that I want to fill is Cadre

I tried to fill it with :

Combobox1.Selected.Value

Combobox1.SelectedItems

Concat(ComboBox1.SelectedItems;Cadre;";")

Every time the SelectedItems didn't work.

If you can help me thank you !

Categories:

Power Platform Build Tools

All responses (6)

Answers (1)

PierreJeanjot 12 on at

Like (1)

Report

Re: Update excel datas from Combobox

Thank you so much, it's working !
Verified answer

HenWang Microsoft Employee on at

Like (0)

Report

Re: Update excel datas from Combobox

Hi @PierreJeanjot ,

Please use this formula:
Concat(ComboBox1.SelectedItems;Cadre1;";")

You can directly copy and paste it in Update property.

Best Regards,
Hen Wang
PierreJeanjot 12 on at

Like (1)

Report

Re: Update excel datas from Combobox

Here it is the screenshot.

May be it doesn't work because I'm using a form ? Because your formula doesn't work too.
HenWang Microsoft Employee on at

Like (0)

Report

Re: Update excel datas from Combobox

Hi @PierreJeanjot ,

Can you send me the screenshot like this? Just edit your canvas app and check the combobox control and expand the data inside like this:

Actually you just need to change this formula:
Concat(ComboBox1.SelectedItems;Cadre;";")

you need to delete the cadre column and select one column directly from the above screenshot.

BR,
Hen Wang
PierreJeanjot 12 on at

Like (0)

Report

Re: Update excel datas from Combobox

Thank for your help @HenWang !

Items inside this combobox are "Défaut peinture","Mauvais composant".

I want to write into the following data base :

And values that I want into my comboBox are these values :
I don't know if I'm clear in my explanations.
HenWang Microsoft Employee on at

Like (0)

Report

Re: Update excel datas from Combobox

Hi @PierreJeanjot ,

We need to know the columns names inside the items property of your combobox control. Please refer to my below test:
In my combobox control, I used the sample value of "ComboBoxSample", and it is a table with column: "Value1","Value2","Value3".

Let's say I need to use the value hold in the "Value1" column, the Update property should use below formula:
Concat(ComboBox1.SelectedItems,Value1,",")

The column should be from the combobox items table instead of column Cadre from your excel file, unless they share the same name value.

Hope this helps.

Best Regards,
Hen Wang