Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by

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.

  • Verified answer
    v-bacao-msft Profile Picture
    v-bacao-msft on at
    Re: Flow/PowerAutomate: store email details into sharepoint based on the email subject.

     

    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,

  • Krishna92 Profile Picture
    Krishna92 on at
    Re: Flow/PowerAutomate: store email details into sharepoint based on the email subject.

    @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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics