web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Splitting Strings

Power Apps

Answered

Splitting Strings

(0) Share

Report

Report

Posted on by mayarnaldo

92

Hi,

I have a comboxbox search for Employee which I called Main Presenter and a text label to get their Department. split department.png

This is for the Department:

SearchPresenter_2.Selected.Department

How I can split the Department into Department No. (1234) and Department Name (Technical Department)?

Any help is very much appreciated! 🙂 Thank you.

Regards,

May

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

timl 37,212 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi May,

This will return 1234

First(Split(SearchPresenter_2.Selected.Department, " ")).Result

This will return the remaining words (eg, Technical Department)

Concat(LastN(Split(SearchPresenter_2.Selected.Department, " "), CountRows(Split(SearchPresenter_2.Selected.Department, " "))-1), Result & " " )

Hope that helps!

Was this reply helpful? Yes No
mayarnaldo 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect! Thank you! 🙂

Was this reply helpful? Yes No

Join the conversation