Unanswered

Deleting a row in Excel Online Business if it already exists in a Sharepoint list

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

MarvinBangert 1,924 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

@MarvinBangert
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

Was this reply helpful? Yes No