Unanswered

Help With Concat

(0) Share

Report

Posted on by NT-20121707-0

I have a Combo box that has the following Items FX "Office365Users.SearchUserV2({searchTerm:ComboboxCanvas2.SearchText,top:20}).value"
And the Fields are set to only expect MailNickname

Then on other files I'm then stuff like "ComboboxCanvas2.Selected.DisplayName" to pull Display Name and ComboboxCanvas2.Selected.Department to pull Department

When it comes to Phone number I have Concat(ComboboxCanvas2.Selected.BusinessPhones,Value," ,")

However it doesn't seem to pull a telephone number and mobile phone number at the same time. Also if a phone number doesn't exist it leaves the data card blank.

How can I get the FX to pull the required information formatted with / in between each entry and also have it output N/a into the data card if no data is found from the Office365Users.SearchUserV2 BusinessPhones value?

Categories:

Using Apps Using Formulas

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 150,345 Most Valuable Professional on at

Like (0)

Report

Help With Concat

Hi @NT-20121707-0

Assuming this is a single selection combo box, what you have should work, however Modern Combo Boxes are still in preview. As a debugging exercise, try the same code with a Classic Combo Box.

Was this reply helpful? Yes No
NT-20121707-0 2 on at

Like (0)

Report

Help With Concat

Hi @scalca

I'm trying to get the Customers Phone Number to be pulled from the combo box value which would be the 'Mail.Nickname'

It pulls through a number but I want it to be able to pull both DeskPhone and Mobile Numbers from the Office365 connector.

I also want to be able to have the Customers Phone Number DataCard to have a "N/a" or "Null" Value if not data is found, how would I go about doing that?

When I do 'SelectedItems' it errors Concat(ComboboxCanvas2.SelectedItems.BusinessPhones,Value," ,")

Was this reply helpful? Yes No
scalca 243 Moderator on at

Like (0)

Report

Help With Concat

Are you saying that the combobox allows to select multiple records ?

according to documentation Business Phones is the Phone numbers of user's company

https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/connections/connection-office365-users#output-properties

if you have multiple selections, then you have to use ComboBoxCanvas2.SelectedItems instead of Selected

Was this reply helpful? Yes No