You’re offline. This is a read only version of the page.
Basically I have a flow which uploads an excel file to sharepoint which would then have the rows inside it appended into a sharepoint list. There is a column called 'Doctor Code' in both the excel file and sharepoint list and what I want to happen is when the excel file gets uploaded to sharepoint it will first check if the doctor code in it is already existing in the sharepoint list, if yes then it would delete that specific row.
Right now I have this flow.
I imagine the process can be achieved in the Yes condition but I just cannot figure out how to do it.
Any help would be greatly appreciated!
Although I just have an additional question. I now have this flow to delete the rows in the excel file.
My question is how can I get the output from that step to get whatever was not deleted in the excel file in order to append it into the sharepoint list.
Edit: Nevermind I figured it out again, I just have to create a step to list rows present in a table to get the updated version of the excel file and then just use the output of that to Create Item in sharepoint list
Hello @MarvinBangert
I actually managed to solve it a few hours ago and this is exactly what I did. Thank you so much for the reply!
Hi @Anonymous
do you mean the row within excel or sharepoint lists to be deleted?
@Anonymous wrote:if yes then it would delete that specific row.
If you want to delete the items from your excel list, use the excel action "delete a row":
Your Key Column is the column to identify which row needs to be deleted (you should use a unique value).
Does this help you? Otherwise please give me some more information.
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
Blog: Cloudkumpel
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
