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.
The email comes comma separated. I use this flow to process the data.
This is the entire expression that I use. split(outputs('Html_to_text')?['body'], variables('delimitor'))
This does a great job of digging out the data that I am looking for. However......(you knew that was coming)
If you look at the data, you can see that the "," is missing at the end of each row.
Therefore I end us with double data.
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.
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?
I added this to the top of the flow, but I don't think I have the Expression correct?
I did this, but not sure if I am on the right track or not.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.