Help with Flow to take email subject and populate the proper cell in Excel. Example attached.

(0) Share

Report

Posted on by LR-29120802-0

I am new to Power Automate and automation in general. The task. Take an Incoming Outlook email, use the subject matching the Client name in the excel sheet to populate the proper cell in Excel. I have attached an example. In the example the Client name is Marcus Coleman Credit Card, the email subject is FILES RECEIVED FROM CLIENT - Marcus Coleman Credit Card. When we receive the email with subject "FILES RECEIVED FROM CLIENT - Marcus Coleman Credit Card". I could like it to fill the cell under the column FILE RECEIVED/ PROCESSING matching the CLIENT name with the light green color like in the attached example. I need to do this for several clients.

Marcus Coleman Cr...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Srini007 3,483 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LR-29120802-0

Since I'm able to see your image file, I would suggest you paste the image in the description and then explain in detail what you are trying and getting the error with more screenshots

Regards,

Srini

Was this reply helpful? Yes No
LR-29120802-0 2 on at

Like
a
(0)

Report
Copy link

Link copied!

When receive email with Subject TPRO FILES RECEIVED FROM CLIENT - Marcus Coleman Credit Card. Populate the excel spreadsheet looking like the screenshot. I need to do this for several different clients.

When received this email to inbox

Populate the excel spreadsheet to look like this.

Trigger: When a new email arrives in a shared mailbox (V2)

Was this reply helpful? Yes No