Answered

Implementing Unsubscribe Function for Marketing Emails in Segmented Excel

(1) Share

Report

Posted on by DS-10100902-0

Hi Power Automate Community,

I’m working on a dynamic Excel file for a CRM model, and I’ve segmented the file into multiple tables across different tabs. Each table represents a specific industry, and the industries are categorized in the following tabs:

"Airports"
"OEM"
"Security Company"
"Service Organizations"

The problem I’m trying to solve is implementing an unsubscribe option for marketing emails. Here's the flow I'm envisioning:

A client fills in their email address in a Microsoft Form to unsubscribe.
Once submitted, I want Power Automate to:
- Search the Excel file across the different tabs (industries) to find where that email is present.
- Once the email is found in a specific table, update the corresponding row by marking them as unsubscribed (e.g., changing a column value in the "News" column from "Yes" to "No").

I’m having difficulty setting up the flow that can search across multiple tabs and tables in the Excel file to locate the email address. Has anyone done something similar or have any advice on how to approach this?

Attached are screenshots showing the tab names and the column headers I’m working with.

Thanks!

Categories:

Building flows

tab names.png

table column name...

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,442 Super User 2025 Season 2 on at

Like (1)

Report

HI

So what I would do is

1. When a Form Response is Submitted

2. Get Response Details

3. Get Tables (excel action)

4. Condition

left side expression length(output/body/value) from #3 (and thats not the output, its picking the proper one I always forget for Get Tables if the Dynamic field is body/value or outputs..

middle is greater than

right side 0

The above will make sure that Get Tables, returned us the list of tables in the excel file

5. In the Yes side (in the no do nothing)

Add an apply to each, with the input being the #3 output/body/value i mentioned

5a. Inside the Apply to each

list rows in a table, using a filter on the column you want to check for their email as the Filter property of the action

5b. add a Condition which is going to check the length of the List rows actions to see if it returned 1 row or not

so you have the length

middle is equal to

right 1

In the yes side of the Condition (meaning you found the one Row)

add an update Row in a table

And configure it to update that one row column from No to Yes

Done

Was this reply helpful? Yes No
DS-10100902-0 10 on at

Like (0)

Report
Dear Community,

I am currently following the steps outlined in the first answer but have encountered some challenges starting from Step 5. I would appreciate clarification on the following points:

Table and Filtering: The instructions mention "using a filter on the column you want to check for their email as the Filter property of the action." However, it is unclear which table needs to be selected and how the filtering should be applied in this context. Could you please provide further guidance on how to properly configure this step?

Dynamic Content: After completing this step, will the action "List rows present in a table" automatically be added to the available dynamic content fields? If additional configuration is required, I would appreciate details on that process as well.

I look forward to your insights and thank you in advance for your assistance.

Kind regards,
Dave

Was this reply helpful? Yes No