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.

All responses (4)

Answers (1)

AKRogers 354 on at

Like (0)

Report

Re: Update Sharepoint list from Excel Table when new Mail arrives

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

Thanks,
Ashley
Verified answer

Cjramsey22 48 on at

Like (1)

Report

Re: Update Sharepoint list from Excel Table when new Mail arrives

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.
AKRogers 354 on at

Like (1)

Report

Re: Update Sharepoint list from Excel Table when new Mail arrives

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
Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report

Re: Update Sharepoint list from Excel Table when new Mail arrives

@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.

Community site session details

Update Sharepoint list from Excel Table when new Mail arrives

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Update Sharepoint list from Excel Table when new Mail arrives

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates