create the power automate flow

(1) Share

Report

Posted on by RV-13100656-0

Hi,

I want to create a Power Automate flow so that when an email with a particular subject arrives, it should collect all emails in that thread. After 30 minutes, it should analyze the replies in the thread to determine whether the responses are positive or negative, and then store the results in SharePoint.

am don't to after 30 min how can i take thread emails. please help.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, this is achievable in Power Automate. The key is that you shouldn't try to keep the flow running for 30 minutes and then retrieve the thread. A more reliable design is to use the email's Conversation ID to identify the thread.

Use the Conversation ID as the key to identify the email thread. Store it when the initial email arrives, then use a scheduled flow to retrieve all emails in that conversation after 30 minutes. If possible, use the Microsoft Graph API to query messages by conversationId, as it is more reliable and scalable than relying solely on Outlook connector actions. This design is more maintainable than keeping a single flow waiting for 30 minutes.

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @RV-13100656-0,

I agree with @11manish, just one point on how to analyse the sentiment - once you have picked the thread conversation you can use AI Builder for sentiment analysis.

Reference:

Use the sentiment analysis prebuilt model in Power Automate

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @RV-13100656-0

Nice use case!

You can try something like this:

Step 1:

Step 2:

Step 3: Add the Delay of 30

Step 4: Use Invoke an HTTP request

https://graph.microsoft.com/v1.0/me/messages?$filter=conversationId eq '@{variables('ConversationID')}'&$select=subject,from,receivedDateTime,bodyPreview,conversationId

Step 6: Loop through every @{body('Invoke_an_HTTP_request')['value']}

Step 7: Append to the ThreadText variable

From: @{items('Apply_to_each')?['from']?['emailAddress']?['address']}
Time: @{items('Apply_to_each')?['receivedDateTime']}
Message: @{items('Apply_to_each')?['bodyPreview']}

----

Step 8: Use AI Builder to analyse the sentiment

Step 9: You can use @{outputs('Analyze_sentiment')?['body/responsev2/predictionOutput/result/sentiment']} to get the sentiment (positive, negative, neutral)

Step 10: Create item in SharePoint

Let me know if it worked!

Was this reply helpful? Yes No