![]() ![]() When the email with the body which I provided above arrives, the flow would run successfully to insert those value to excel rows as below: The expression in the "Drop Off" field of "Insert row" action as below: first(skip(split(body('Html_to_text'),'Drop Off:'),1)) The expression in the "Pick Up" field of "Insert row" action as below: first(skip(split(first(split(body('Html_to_text'),'Drop Off')),'Pick Up:'),1)) The expression in the "Run Number " field of "Insert row" action as below: first(skip(split(first(split(body('Html_to_text'),'Pick Up')),'Run Number:'),1)) The expression in the "Unit Number" field of "Insert row" action as below: first(skip(split(first(split(body('Html_to_text'),'Run Number')),'Unit Number:'),1)) The expression in the "Date" field of "Insert row" action as below: first(skip(split(first(split(body('Html_to_text'),'Unit Number')),':'),1)) You could refer to screenshot below to create the flow: (Plus I have regulations I have to follow, HIPAA, etc.) One would think this should be a fairly easy process using microsoft's own tools, but seeing as how someone else has built a better mousetrap, I'm wondering if it even IS possible to do so without a third party. ![]() Parserr will work for what I need it to do.in fact it's perfect, but I'll need to run ~ 200 emails a month through this process and Parserr is just waaay to expensive for that. ![]() How can I get individual items from the body previously extracted using the HTML-to-text and insert each item into its own column in the new row? I've used the 'HTML to text' to get the info, but when I go to push it to the spreadsheet, all of the data goes into one column (in the new row). As the title says, I'm trying to extract text from body of an email and create new rows in excel spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |