Unanswered

Combine two values into one field

(0) Share

Report

Posted on by SoranoErring

Hi.

I'm new to the Power Apps. I need to organize some data to make my power automate work, but I have some problems and don't know how to solve it

Now I have a Sharepoint list and Apps
There is a combobox and an input box in apps

螢幕擷取畫面 2022-05-12 150035.png

I hope that the values of these two choices can be combined and stored in the same sharepoint field

for example

Apps:

Tltle
Enter "test file"
Name
Enter "Stan"
Type
ComboBox
Select "A B C"
Text box
Enter "E"
State
Enter "Done"
press SAVE

Sharepint list (Please ignore values other than "Type"):

Tltle	Name	Type	State
test file	Stan	A, B ,C ,E	Done

What should be done to achieve this function?

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Miguel Oliveira Microsoft Employee on at

Like (1)

Report

Hi @SoranoErring!

You can use the Concatenate() function in order to merge all the values that you want to store in the same field, and then save the Concatenate result into a variable so you can patch the variable result into your SharePoint, something like this:

Set(varAllValues, Concatenate(TextInput1.Text, Combobox1.Selected, TextInput2.Text,....))

Let me know if this solution fit your needs

Kind Regards,

Miguel Oliveira

Was this reply helpful? Yes No
SoranoErring 9 on at

Like (0)

Report

@MiguelOliveira
Thanks for the method
~~But I'm really unfamiliar with power apps, I don't know where to use this function and send it back to sharepoint~~
I found some places to put the function

DataCardValue4 is my Combobox
Select : A B D
DataCardValue8 is my TextInput
Enter : E

I tried to use:
Concatenate(DataCardValue4.Selected, DataCardValue8.Text)

But it doesn't work, invalid arguments

And changed it to this
Concatenate(DataCardValue4.Selected.Value, DataCardValue8.Text)
Result output : AE,
It was close to what I wanted, but only one data was output

So I found another function
Concat(DataCardValue4.SelectedItems,DataCardValue8.Text,",")
Result output : E,E,E

No matter how I modify it, there will only be a bunch of blanks

Was this reply helpful? Yes No
SoranoErring 9 on at

Like (0)

Report

@MiguelOliveira
Thank you for providing me with directions to think !

Finally!
this problem is solved

I used a simple and crude method :
Concatenate(Concat(DataCardValue4.SelectedItems,Value & ","),DataCardValue8.Text)
Result output : A,B,D,E

That's what I wanted

Was this reply helpful? Yes No