web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Split Function Help us...

Power Apps

Answered

Split Function Help using comma delimiter

(0) Share

Report

Report

Posted on by gazzo1967

1,151

Hi All

I have read the Split function documentation an tried the examples but i can't get it to work 😞

i have a Textinput with the following:

Default=BingMaps.GetLocationByPoint(Latitude1,Longitude1).name

this is hidden to be entered in to SharePoint list

But for the user i would like to show the address e.g.

70 Harvest Road, Sandwell, B67 6NH

as

70 Harvest Road,

Sandwell,

B67 6NH

In a label

I have tried
Split(Text(BingMaps.GetLocationByPoint(Latitude1,Longitude1).name, ","))

Split(Text(BingMaps.GetLocationByPoint(Latitude1,Longitude1).name), "[$-en-GB],")

It seems my issue is that he textinput is actually a table

Help Gratefully received 🙂
Gary

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

KrishnaV 5,023 on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @gazzo1967 ,

Try the below steps to address your issue:

Create an HTML Input label on the screen (instead of the regular label)
Use the below formulate to split the address and show it as a table

Concat(Split(BingMaps.GetLocationByPoint(Location.Latitude,Location.Longitude).name,","),Concatenate(Text(Result),"<br>"))

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps, then please consider Accept it as the solution and give thumbs-up to help the other members find it more.

Was this reply helpful? Yes No

Join the conversation