cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Flow/PowerAutomate: store email details into sharepoint based on the email subject.

Hi,

 

I'm trying to get all emails details such as sender and body to be stored into sharepoint online list.

 

It should be based on the match of the 'email subject' and also the 'Issue title' input & submitted by user through MS forms. If title and email subject is the same, the email details should be stored into sharepoint list.

 

Kindly advice.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

Have you had an opportunity to @Krishna92 's recommendations to adapt your Flow?

 

In addition to the email subject and issue title being equal, are there any other conditions that need to be met?

Do Sender and submitted by user also need to be equal?

 

For the first condition, you could try the following configuration.

  • Use the Get emails action to get the emails in the inbox, and use Search Query to filter emails with equal email subject and issue title.
  • Then get the email details and store them in the SharePoint List.

 

There is a limitation to this method. It can only get up to 25 eligible emails at a time. If the number of eligible emails is less than 25, you can consider using this method.

Image reference:

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Krishna92
Microsoft
Microsoft

@Anonymous 

 

This is a complex requirement to achieve as we have trigger only to detect either an email action or a form response submission but not the both at a time.

 

One way you can do this you can store the details of email in one share point and the form details in another.

You can create a flow to extract details from these two lists using the GET ITEMS action in flow.

 

then you can use a condition in flow to check if both values are equal and if so then you can put a CREATE ITEM action in the YES part of the condition to create item in share point.

 

As per my opinion I think this is one way to achieve the desired scenario.

v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

Have you had an opportunity to @Krishna92 's recommendations to adapt your Flow?

 

In addition to the email subject and issue title being equal, are there any other conditions that need to be met?

Do Sender and submitted by user also need to be equal?

 

For the first condition, you could try the following configuration.

  • Use the Get emails action to get the emails in the inbox, and use Search Query to filter emails with equal email subject and issue title.
  • Then get the email details and store them in the SharePoint List.

 

There is a limitation to this method. It can only get up to 25 eligible emails at a time. If the number of eligible emails is less than 25, you can consider using this method.

Image reference:

98.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,424)