Unanswered

Getting contents of email attachment(excel) and do some data editing and save it to Dataverse.

(0) Share

Report

Posted on by Jermaine28

Hello, I'm trying to automate the task of getting Excel from some customer and I want to format this excel sheet like using its filename and edit some columns and save it to Dataverse or OneDrive is there any helpful suggestions to how to do it.
I will really appreciate the suggestion and instructions. Thanks

All responses (2)

Answers (0)

Jermaine28 2 on at

Like (0)

Report

Re: Getting contents of email attachment(excel) and do some data editing and save it to Dataverse.

Hi scott,
The things I want to automate includes below :
1. Trigger : when email arrives from certain user
2. Get the attachment content (In excel data sheet)
3. Upload excel to dataverse table

The excel file is formatted in exactly same way. Its monthly repetitive task.
thanks scott
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: Getting contents of email attachment(excel) and do some data editing and save it to Dataverse.

@Jermaine28

Can you provide additional detail on what you would like to accomplish?

Is the data in an Excel table?

Are all the spreadsheets formatted in exactly the same way?