cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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
Highlighted
Frequent Visitor

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
Highlighted
Frequent Visitor

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

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (7,580)