cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Split a variable to multiple lines

Hi, 

 

I have the information that I get from Flow and I set it as a variable varFlow. varFlow returns a string flowapprovers from Flow.

 

so the information can be retreived using varFlow.flowapprovers. It returns {"a":"apple","b":"banana","o":"orange"}.

 

Now I want to split this so it is more readable., like this:

 

a: apple

b: banana

o: orange

 

When I try to use Split(Text(varFlow.flowapprovers),","), it gave me an error saying Expected Text Value.

How to fix this? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Split a variable to multiple lines

Hi @lavint 

If you want to display the result in a label, something like this should work better for you.

 

Concat(Split(Text(varFlow.flowapprovers),","), 
Result & Char(13)
)

View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Split a variable to multiple lines

Hi @lavint 

If you want to display the result in a label, something like this should work better for you.

 

Concat(Split(Text(varFlow.flowapprovers),","), 
Result & Char(13)
)

View solution in original post

Helper I
Helper I

Re: Split a variable to multiple lines

Hi @timl ,

 

It works perfectly! Thank you!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,019)