From Combobox to Sharepoint List

(0) Share

Report

Posted on by Charline_74

Hi everyone,

I have a combobox that contains data from a global variable.

It's a code list :

And I'd like to add the items selected in my combobox to a sharepoint list.

Here is my current formula and I would like to add my combobox.

Does anyone have any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Charline_74 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik
Thanks it's work now !!

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Charline_74 -

Please read my first response to your post again, paying particular attention to the bold section:

"assuming that the "Entity Code" field is a Single Line Text data type in your data source"

I take it then, that the "Entity Code" field is not a Single Line Text data type?

Was this reply helpful? Yes No
Charline_74 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik,

I get this error when I use your formula:
the type of this argument 'SSP' does not match the expected table type. Type found Text

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Charline_74 - and the solution I suggested does not work for you because...?

Was this reply helpful? Yes No
Charline_74 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik
Basically, I have a combobox in which I have a list of SSP code that comes from a global variable.
And I'd like it so that when a user selects one or more SSP codes, and clicks on a button, the code or codes are written to a SharePoint list.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Charline_74 -

Sorry I have no idea what your response means...

Was this reply helpful? Yes No
Charline_74 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik,

In my basic formula I just want to add my combobox, I have an SSP column in my SharePoint List

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Charline_74 - assuming that the "Entity Code" field is a Single Line Text data type in your data source, is this what you're trying to do?

Patch( Entity, Defaults(Entity), { Entity: TextInput1.Text, Country: TextInput1_1.Text, 'Entity Code': Concat( 'Your ComboBox'.SelectedItems, ssp, ";" ) } )

Was this reply helpful? Yes No