Adding a different separator to the final value in a ComboBox?

(0) Share

Report

Posted on by garrettswett

Hey all,

Is there any way to add a different separator to the final selection of ComboBox items?

Like having 1, 2 and 3.

Instead of 1, 2, 3?

I can't seem to figure it out, I've looked everywhere.

Office365Outlook.SendEmailV2(
TrimEnds(TextInput1),
"LLC: Service Estimate",
"Hey " & TrimEnds(Proper(TextInput1_1)) & ",<br/><br/> Your service estimate for " & Concat(
ComboBox1.SelectedItems,
Value & ", "
) & " is $" & RoundUp(
((Gas / 15) * (Distance * 2) + (2 * 40 * Time) + Waste) * 1.025,
0
) & "."
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

BCLS776 8,994 Moderator on at

Like (0)

Report
For a table of string values, such as: ComboBox1.SelectedItems, with a string field named "Value" try this:

With({ aLength: CountRows(ComboBox1.SelectedItems)}, If(aLength > 1, Concat( FirstN(ComboBox1.SelectedItems, aLength - 1), Value, ", " ) & "and " & Last(ComboBox1.SelectedItems).Value , First(ComboBox1.SelectedItems).Value ) )

Hope that helps,

Bryan

Was this reply helpful? Yes No
Cat Schneider 488 Most Valuable Professional on at

Like (0)

Report

Another option you could try is the following:

With({i: Last(Combobox1.SelectedItems)},
Concat(ComboBox1.SelectedItems,
If(i.Value = ThisRecord.Value, "and ") & Value,
", "
)
) & " is $" & RoundUp(
((Gas / 15) * (Distance * 2) + (2 * 40 * Time) + Waste) * 1.025,
0
) & "."

Was this reply helpful? Yes No