@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
