I have created a flow to create tasks in a planner successfully except specifying the due date in each task.
In my excel, each row (for each task) has a different due date. How do I tell the flow to import that specific due date for each task. Sorry, I have read some similar questions and tried, but couldn't figure out a solution.
@Rahber , thank you very much for the link. Yes, I use Excel online (business) connector. I read it through and am still a bit confused.
I tried the following expression: addDays('1900-01-01',int(items('Due Date_')?['Date'])) into "expression" and saved the flow, but got an error message: "The template validation failed: "the repetition actions "Due Date" referenced by "inputs" in action "create a task" are not defined in the template.
Do I miss a step? How do I define?
For your reference, this is how my current flow looks like:
Manually trigger a flow -> List rows
List rows present in a table
Get a row
Apply to each (condition to put a specific task to a specific bucket) - create a task
Here is the correct formula to use
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
@Rahber , I am still having trouble with that. Now, it gave me another error message: " the template validation failed: the inputs of template action 'create a task' at line 1 and column 4270 is invliad. Action 'apply to each" must be parent foreach scope of action 'create a task' to be referenced by 'repeatItems' or 'items functions'.
Please allow me to share the screenshots of my entire flow:
I have the steps to pull bucket ID so that each task can be created into the correct bucket.
1) You do not need Get a Row action inside Apply yo each since you already have all the rows form List all Rows.
Why are you listening buckets and what is the condition you are checking?
This is how the flow should look like
Manually Triggers the Flow
List Rows Present in Table in Table
Get Buckets ID
Apply to EACH BUCKET
Apply to Each ROW
Create a Task
Do Something Else