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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

scalca 243 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
NT-20121707-0 2 on at

Like (0)

Report
Copy link

Link copied!

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
WarrenBelz 153,311 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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