cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sweteg
New Member

Excel online business: Possible to move a row to another sheet in the workbook?

Hey guys,

 

I couldn't find a solution to this and not sure if it's possible.  On a shared online workbork, I'm trying to have it to where if a certain drop down list choice is selected, it would move that specific row to another sheet in the same workbook.

 

I have the get a row filled out properly with the key value being the selection from that drop down list choice, but I can't find an action in excel online version that moves/insert a row.

 

Thanks in advance!

2 REPLIES 2
Anonymous
Not applicable

I'm not sure what your trigger is, but assuming you have that figured out maybe you could:

  1. "List rows present in a table" for your source table.
  2. "For Each" value add a condition to check for key value field.
  3. If "yes", "List rows present in a table" for your target table with a filter on your key value (assuming you do not want duplicate entries).
  4. Add condition to check if a record was found (Key value is equal to Key value)
  5. If "no" (which should mean a row was not found)
  6. "Add a row into a table" into your target table
  7. "Update a row in a table" with your data. 
  8. You said "move", so maybe at this point you "Delete a row" from your source table to remove the original row.

Is your trigger going to be when a file is modified? Hope this is slightly helpful.

Thank you for the solution!

Most of it worked for me, except for the Delete a row:

In my Excel table, the rows to be moved are supposed to have a key value in a specific column called "To Archive", which is "Yes".

However sometimes the cell would be empty and then I get this action failed...Even though the purpose has been perfectly filled, all the rows are moved to the second table and deleted from the first table.

Could you please help me find a way to handle this failure? 

failed1.pngfailed2.png

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,017)