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

Getting data in the way that it is needed.

I am going to do my best to describe what I am trying to do and how I have done it. It seems like each way I try I get a little bit closer but there's one little thing that pops up that I can't seem to get around. And then try to a different way and it's looking good but then something else pops up and I can't seem to get around that either.

 

Here is what I have.  I get an email with data in it.  Duh, I know.  I have been trying for over a week to digest the data in different ways to pull the information from it that I need.  The data is below.

 

Screen Shot 2021-06-22 at 1.47.09 PM.png

 The email comes comma separated.  I use this flow to process the data.

 

Screen Shot 2021-06-22 at 1.50.08 PM.png

Screen Shot 2021-06-22 at 1.50.50 PM.png

 This is the entire expression that I use.    split(outputs('Html_to_text')?['body'], variables('delimitor'))

 

Screen Shot 2021-06-22 at 1.51.49 PM.png

Screen Shot 2021-06-22 at 1.52.34 PM.png

 This does a great job of digging out the data that I am looking for.  However......(you knew that was coming)

 

Screen Shot 2021-06-22 at 1.54.25 PM.png

 If you look at the data, you can see that the "," is missing at the end of each row.

 

Screen Shot 2021-06-22 at 1.55.38 PM.png

 Therefore I end us with double data.

 

Screen Shot 2021-06-22 at 1.57.19 PM.png

 Is there a way to account for this?

 

And lastly, Is there a way to get rid of the quotation marks?

 

Thank you for your help.

Chip

3 REPLIES 3
PrasadAthalye
Super User
Super User

Can you declare a Variable with Line break in it? Just Press enter once? Then use that to split first into an array 'A' and then split on comma for each array element of 'A' to generate array 'B'. Then use Array 'B' to write in excel?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

I added this to the top of the flow, but I don't think I have the Expression correct?

 

split(outputs('Html_to_text')?['body'], variables('delimitor2'))
 
You mentioned an array, and I am not good at those.

 

Screen Shot 2021-06-22 at 4.51.10 PM.png

I did this, but not sure if I am on the right track or not.

 

Screen Shot 2021-06-22 at 5.24.50 PM.png

 

split(outputs('Html_to_text')?['body'], variables('delimitor1'))
 
I assume that this would take the text, and split everything up by "enter".
 
Screen Shot 2021-06-22 at 5.26.00 PM.png

split(outputs('Compose_2'),variables('delimitor'))
 
I assumed this would take the output of what was written, and split it up by the ",".
 
But it doesn't work.
 
Thank you again for your help.
Chip

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,673)