cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Format String/Array with Product name and its hierarchy path

Hi all,

 

Does anybody know how to format following:

 

Hierarchy Path                                            Name

 

USA\California\Los Angeles                        Lakers

USA\California\Los Angeles                        Clippers

USA\California\Sacrament                          Kings

 

 

To:

 

USA

      Callifornia

                 Los Angeles

                         Lakers

                         Clippers

                 Sacramento

                         Kings

 

 

As you can see these are baskeball teams, right now this is easiest way to explain what I want to do.

Any suggestions on how to format these records and its Hirarchy paths in the format I want?

What is the best "variable" to use in flow (String, Array..)?

The point is that I want to create word document from a template and save it in SharePoint.

 

Any ideas are appreciated

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Actually not quite understand your purpose.

For populating a Word template, you could use below connector.

SteveYao_0-1598953662043.png

 

Highlighted

Thank you for answering,

 

The purpose is to format all Quote Products like I demostrated in description. 

 

In flow I get all data I need, Name of the Product and the Hirarchy Path that i save in an Array. I am having trouble with formating the data in array so it looks like example in my description and create Word document from a template as you described in you post.

Highlighted

I think you could do that, please refer to below tutorials

https://youtu.be/Zzm965PlYl0

https://youtu.be/VYs-SnflUpQ

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (8,687)