Unanswered

Writing table values to a text field

(1) Share

Report

Posted on by DevPower

I'm devloping an IT ticket system to practice making PowerApps. I've ran into an issue when saving ticket details.

Amongst the textboxes which the user populates before submitting their ticket, they are given the option to 'log on behalf of other user', they do this by searching and selecting the usersname from a combo box.

When they click submit the data is patched to an Excel table - this table will then be used to populate the ticketing system main screen with case details, the email address of the user who the ticket is being logged for, will also be needed to send out automated emails.

However I can't store the users email. It comes from the Office365Users connection, and is stored as a table.

Here is what I have so far:

If(CheckPhone.Value=true, Set(VarMobile, TextPhone.Text), Set(VarMobile, ""));
If(CheckPhone.Value=true, Set(VarAdditional, ComboUserSearch.SelectedItems.Mail));
Patch(Table1_1, {
	user_name: User().FullName,
	user_email: User().Email,
	ticket_title:TextTitle.Text,
	issue_description:TextDesc.Text,
	mobile_number:VarMobile
 proxy_user:VarAdditional
})

This results in the following error message:

The type of this argument 'proxy_user' does not match the expected type 'Text'. Found type 'Table'.

So clearly it is expecting text, and can't store the value as it's type is table. But I can't convert this field to text no matter what I try. I have added '.Value', .'Text'.

How do you store these table values?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (2)

Report
Hi @DevPower

Do you need to be able to store multiple users if your proxy_user field? If not, you can select the first selected item in your combo box by referencing the Selected property, rather than the SelectedItems property.

If(CheckPhone.Value=true, Set(VarAdditional, ComboUserSearch.Selected.Mail));

Was this reply helpful? Yes No
DevPower 37 on at

Like (0)

Report

This is exactly what I was looking for thank you!!! I thought that 'Combobox.SelectedItems' served that purpose and didn't realise there was a single alternative.

I thought as some point I may be getting more than one result, but couldn't find a way of viewing the variable to debug it? Anyway, thank you very much.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @DevPower

Glad that solves your problem!

For debug purposes, you can go to File > Variables to view your variable. Or alternatively, another simple way is to add a temporary data table somewhere on your screen and to set the Items property to your variable.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @timl

What if I had to store multiple values? My combobox has multiple values and I have to store it as a text/multiline text field in my CDS.

I would appreciate if you can help me with this!

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Anonymous

Say that your combobox includes a field called Surname, you can combine the values with the concat function like so:

Concat(cboCombo.SelectedItems, Surname)

Was this reply helpful? Yes No