Hi everyone,
I have an Excel table with 250 devices for maintenance with all customer data. One column includes a text field as ID with a succeeding entry (PPM001, PPM002, etc.) For each entry a task in MS Planner was created through a flow called "for a selected row". So the Excel table and the tasks in the Planner already exists.
When the task is being closed I want to add the completion date of the task into the Excel table into a column called "completed at" using flow "update row in Excel".
I am not quite sure how define the key-id to find the matching row to update.
I would either have to
a) add the task id to the existing excel table in a separate column or
b) be able to extract the "PPM00x" id from the subject string of the task
to use this as key-id to find the matching row to update.
In both cases I don't know how to do it, can anyone give me a suggestion how to go about it best?
A) How can I add the ID into the existing Excel table as separate column.
or
B) How can I extract the "PPM00x" id from the subject / title of the task and use this as key-id to match in the ID-column (text field) of the excel table.
The result to achieve is to have the completed date of the task in the "completed at" row/column in the Excel table.
The table looks somehow like this example

Thanks for your help.
Best regards,
Markus