
Announcements
hi, Everyone
I am trying to build a combined flow to " create a table then delete rows with specific criteria" as the picture shows.
Every time I export Excel from our sales database, the "Rows to be deleted" content will be the same, but the row's location will be different.
I understand that the first step should be to convert the Excel into Table, but then I don't know the next steps.
Thanks for the advice
Hi @JarvisliuMW
I would do something like this below:
In the condition part for each row in Column A contains "Date" or "Project Code" need to be true so the row gets deleted.
Last but not least I forget to put in the flow is to always remove the first 2 row from the top.
Hope this helps. Good luck buddy!
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.