web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Splitting excel column...

Power Apps

Answered

Splitting excel column value in dropdown

(0) Share

Report

Report

Posted on by Nida_Sayedi

90

I Have an Excel with Column Numbers

I need to pull this column in a dropdown and only fetch the number excluding "Tel : +"

Example : I should fetch only 123456788, 1223456789,123456790,.....so on

I am able to split one value using Split( dropdown1.SelectedText.Value , " +") , But not all

I want all Numbers values of table to be Split at a time and displayed in a dropdown ,

how do I use split function for this , if I use split function its expecting first parameter to be text , but for me its table

Split( Table1," +") is not working

how can I do this ?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Nida_Sayedi ,

Please try this:

AddColumns(LIST7,"temp",TrimEnds( Last(Split(Title,"+")).Value)).temp

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation