cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

Delete the whole row except one column with Flow

Hello ,

 

I was wondering if anybody can help me with an issue I'm having. What I'm trying to do is every time that a new entry is created move it to another SharePoint list and delete the old one except from the NameOfEmployee column. This is what I have. It works fine but it deletes the whole entry I want to keep the data of the first Column  there.

Thanasis_0-1611079610680.png

 

If Anybody can help me with that I would really appreciate it.

 

Thank you 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage
Solution Sage

3 REPLIES 3
Solution Sage
Solution Sage

@Thanasis 

This is very simple. Instead of delete, use update item action and set all other values to null and keep the value of required column as it is.

 

Hope this helps.

Solution Sage
Solution Sage

Hello @jinivthakkar  that worked. Thank you very much. Can I ask you one more thing. When I copy all my data from one list to another I have a column that is a Choice - checkboxes (allow multiple selections ). Then think is it keeps creating for every selection a new entry on that new list. Is there a way to copy it in just one entry ?

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (87,964)