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!
I'm not sure what your trigger is, but assuming you have that figured out maybe you could:
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?