Power Automate - deleting row in excel table where Key Value is not constant (could be blank, could have various data)

asked 2020-05-28T18:22:08.88+00:00
Salvatore Lo Monaco 1 Reputation point

I am creating a Form where the responses are used to update an existing excel spreadsheet. I know I cannot overwrite data in the fields (or can I?), so I am having to delete the rows in the tables, then add the row with the updates. I have 4 tables to do this. Currently, I am able to delete 3 of them, as the data contained in those 3 are standard (location name, number, and role). I cannot seem to find a function for the 4th table that will either 1) allow me to overwrite the data in that field (person's name or email, or blank) or 2) delete that row so that another row with the results of the form question would be placed (person's name or email). Each time I run the test without deleting, the submission appears below the row I need it to. I'm sure this is because the row above is not being deleted. Now, the row I need to delete either has data already in it, but varies per row (different names or email addresses), or is blank.

What is the best way to get this to work without having to submit an exact Key Value for this (as it will be different for each function)?

Thank you for your responses. I look forward to any assistance.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,655 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-05-28T18:23:19.037+00:00
    Leon Laude 85,026 Reputation points

    Hi,

    Q&A currently supports the products listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can reach the experts in the dedicated forums over here:

    Microsoft Excel
    https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel

    Power Automate
    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    (Please don't forget to accept helpful replies as answer)

    Best regards,
    Leon

    No comments