Need automation step flow

(1) Share

Report

Posted on by CU24101413-0

Hello Team

I am using when http request is received action, here i am getting ProcessKey.

Then i have to read excel file which has column name called "Title" if, ProcessKey and Title matches i need to take Emailaddress corresponding to the title in excel file and mention in a teams channel using EmailAddress.

How to achive this in power automate Please explain with each steps.

Thanks in advance

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

trice602 16,277 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Here's some pretty good framework to help you get started quickly.

The key here is your http request and the List rows present in a table. You need both of those before your condition. Then you check if the dynamic content of Excel title is equal to the dynamic content of the Process Key.

Goes without saying, not shown here is when you add the dynamic content, this will wrap itself in an apply to each because there can be more than 1 excel row. If true, post a message with the email addresses, if false, do nothing.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
CU24101413-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Thank you for the detailed explanation. I have tried to implement the same flow but when i ran the flow condition is not matching. Please guide me if any variables for Title and ProcessKey needs to be same ?

Was this reply helpful? Yes No
trice602 16,277 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post need automation step flow in this category building flows from 10/26/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 2 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,277 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No