Hey @JK682
please have a look on this:
- "List rows present in a table": First you get all the items from your Excel table.
- Add an parallel branch (by clicking on the arrow between two actions and select (parallel branch).
- Use the "Filter array" action to filter your action by checking, if the TaskID field within your excel file for each field is empty or not:
ID not empty:
From: @outputs('List_rows_present_in_a_table')?['body/value']
Condition: length(item()?['TaskID']) is greater than 0
ID empty:
From: @outputs('List_rows_present_in_a_table')?['body/value']
Condition: length(item()?['TaskID']) is equal to 0
(Please notice to add the length() as an expression) into your field.
It will return you a filtered array whenever a condition fits, using "length" we count the characters within the field "TaskID".
- Apply to each item within the Filter array body (one line for each, you can see within the function the "not / is" to just put it into the correct apply to each:
Select an output from previous steps: @{body('Filter_array_-_ID_not_empty')}
Select an output from previous steps: @{body('Filter_array_-_ID_is_empty')}
- On one side we use the "Update a Task" and on the other side we use the "Create a task" and afterwards "Update a row" (in Excel) to write back the TaskID into the Excel-File for another run.
In both you don't use the dynamic value from your Excel-file, the return from the "Filter array" does not show up. Here is an example about the structure:
Format:
@{items('Apply_to_each_2')?['<Your Excel column name>']}
Example
@{items('Apply_to_each_2')?['StartDate']}
Also when you import a date formatted Excel column into Power Automate, it will not show in a correct format, that you can use to import it into a Planner task, you need to format it. Please have a look on this page on how to format this (you can just add this expression within your "Update a Task" or "Create a Task":
Handling Excel Dates in Microsoft Power Automate (shanebart.com)
Does this help you? Otherwise please give me some more information.
Best regards
Marvin
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
Blog: Cloudkumpel
