Answered

Update Sharepoint list from Excel Table when new Mail arrives

(0) Share

Report

Posted on by Cjramsey22

Hello,

I have an existing flow that allows me to erase and recreate a sharepoint list from an excel table in One Drive. It works great. What id like to do now is have another flow that updates a sharepoint list, but the table arrives in email daily. I haven't used any Outlook flows yet, and I'm not understanding how to get from "When a mail arrives" step to the "List rows present in a table" step. Not sure what dynamic content i need to get. Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report

@Cjramsey22

Hi there, so it sounds like the table is embedded in the email body, ya? If so, you'll need to do some magic to strip that out of the email. You can either use a third-party tool, like Parserr...or write an expression like the one below.

split(split(triggerBody()?['body'],'<tbody>')[1],'</tbody>')[0]

If you're not already familiar with Split(), it lets you turn a string of text (in this case, the HTML code of your email body) and then separate it on a defined delimiter (<tbody>, which indicates the start of a table) and it turns it into an array. Then, you can select the element you want and do further damage. In the one above, I've nested a couple of Splits, so I grab everything after the <tbody> and everything before the end-tag, </tbody>. Here's a really cool video on the function, but the channel is still being worked on so don't tell anyone, deal?

Once you've got the table separated from the rest of the email, the trick is going to be turning it into something usable by Sharepoint. I'll keep digging on that, but maybe @AKRogers has an idea since she's working in SP all the time?

Keep us posted.

-Ed-

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Was this reply helpful? Yes No
AKRogers 354 on at

Like (1)

Report

Hi @Cjramsey22,

I'd like to confirm whether the table comes in the body of the email or as an attachment to the email. It makes a big difference in how things are handled. If you can let us know how that information comes to you in the email then we can add in the Outlook actions you're missing to really automate your original process.

Thanks!
Ashley

Was this reply helpful? Yes No
Verified answer

Cjramsey22 48 on at

Like (1)

Report

Its an attachment to the email. Just a .xlsx spreadsheet. However, this spreadsheet does not have a Table in it, which I need for Get Rows or List rows present in a table function. Currently I just found that I can use a flow to upload that attachment to a document library in sharepoint, if not a sharepoint list. Also recently found out that PowerBI can do everything I want out of the document library, just as easily as a sharepoint list. So really, my initial problem is solved. Thanks for the response all.

Was this reply helpful? Yes No
AKRogers 354 on at

Like (0)

Report

Great! Post again if you find you still need help.

Thanks,
Ashley

Was this reply helpful? Yes No