cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KingsleyG
Level: Powered On

Gathering information from excel/google sheet via outlook email

Hi there,

 

I have created a flow to create a file in one drive when it is scanned to email and also create a public url with other info to search upon.

 

How do I call on this information using email? I have tried to use a few different scenarios and modify to my use case but cannot seem to get it right.

 

The work flow would theoretically be like this.

 

Email from database

Email comes into outlook

M Flow reads emails

M Flow uses information to find sheet data

sheet data is put into new email

 

My info headers for example are

 

Customer Number (REFERENCE)

Type of Document (TYPE)

File Link (URL)

 

I saw parserr but it is too expensive for this small task

1 ACCEPTED SOLUTION

Accepted Solutions
KingsleyG
Level: Powered On

Re: Gathering information from excel/google sheet via outlook email

Took me a little while but I was able to gather information from various topics and hang them together to get my desired result. 

I did not reference back to a spreadsheet but rather use information to reference to the file it is relevant to.

Thanks to everyone having requested similar problems

View solution in original post

1 REPLY 1
KingsleyG
Level: Powered On

Re: Gathering information from excel/google sheet via outlook email

Took me a little while but I was able to gather information from various topics and hang them together to get my desired result. 

I did not reference back to a spreadsheet but rather use information to reference to the file it is relevant to.

Thanks to everyone having requested similar problems

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 74 members 3,700 guests
Recent signins:
Please welcome our newest community members: