Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Help With Concat

(0) ShareShare
ReportReport
Posted on by
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?


 
  • scalca Profile Picture
    scalca 180 on at
    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
     
    if you have multiple selections, then you have to use ComboBoxCanvas2.SelectedItems instead of Selected
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard