cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 363 members 6,356 guests
Please welcome our newest community members: