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

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jermaine28 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No