Delete all rows from ms form input

(0) Share

Report

Posted on by Z94shaikh

Hi there,

I have an MS form that asks the user to input their email.

I also have an excel spreadsheet which has a column containing a list of emails in each row.

The flow then needs to look for the email inputted into MS forms and look at the excel table and delete all the rows where this email is present.

I have been able to do this so that the flow deletes the first row where it finds a corresponding email. However I need to do it so that the flow deletes every row I which the email address is present.

For context, this is a form to unsubscribe from a mailing list on excel.

All responses (2)

Answers (0)

Z94shaikh 2 on at

Like (0)

Report

Re: Delete all rows from ms form input

I really appreciate the help @FLMike , this is what I have so far but not too sure about how to get it over the line. I will apply the steps you have listed in the meantime and see if I can get it to work (I'm still new to power automate and not too sure how to use apply to all yet). Many thanks.
Michael E. Gernaey 41,311 Super User 2025 Season 1 on at

Like (0)

Report

Re: Delete all rows from ms form input

@Z94shaikh

Can you please share?

You must be close, because the only way to get the data from Excel is the List rows present in a Table, which is a loop, so you would have them all (depending on your Filter) and bingo 🙂 delete them one by one.

I bet you are soooo close hehe, lets get you the rest of the way, but please share your entire flow (just snapshots) and explain the steps you are doing (expression wise).

The basis steps would be.
1. Get the Response from the Form
2. Read the Email address of the one you want to delete the rows for
3. Do a List rows present in a Table (Excel Action), but you want to filter the EmailAddress Column by the value you got in #2
So if you called it Email Address you would put
[Email Address] eq 'TheValueFromStep2'

4. Add an Apply to Each
-Inside the Apply to Each
---Add a Delete a Row
---Use the Id from the current Apply to each loop to delete the correct row

Done 🙂

If you like my answer, I would really appreciate if you please Mark it as Resolved, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey