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

Outlook connector export an email to SharePoint if the from email is in a list

Hello,

 

I've got a simple flow that triggers if an email has 'Test' in the subject it exports it to a SharePoint site.

 

I would like it to check the from email address against a list I have in CDS of saved email addresses and if it is in the list then export it to SharePoint,

 

IE if I get an email from dave@minitech.co.nz,  it checks my list to see if dave@minitech.co.nz is on the list and if it is it'll then save it in Dave's file

 

Any help?

 

1 ACCEPTED SOLUTION

Accepted Solutions

@LeoMG 

 

Something like the following.

 

DamoBird365_0-1618986160603.png

 

Albeit you mention CDS so would probably use the list rows action instead of get items

 

DamoBird365_1-1618986290737.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

View solution in original post

4 REPLIES 4
DamoBird365
Super User
Super User

Hi @LeoMG 

 

You can add a filter to get items, columnnameemailvalue eq 'emailaddressdynamicvalue'

 

Then, using a condition, if the length() of get items result is greater than 0 branch yes, save to daves list else no - do something else.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Hello,

 

Would you mind explaining a little bit more?

I start with the trigger 'when a new email arrives' - how do I add a condition to that?

@LeoMG 

 

Something like the following.

 

DamoBird365_0-1618986160603.png

 

Albeit you mention CDS so would probably use the list rows action instead of get items

 

DamoBird365_1-1618986290737.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

View solution in original post

LeoMG
Frequent Visitor

Hello,

Thank you that works brilliantly! 

 

Cheers

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,049)