How to update excel using planner tasks

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone, I followed Miguel_E's video: https://www.youtube.com/watch?v=quJl0wCvNkM&t=17s&ab_channel=TecProSvc

and I can't get this flow to update.

My flow runs but it refuses to update and never passes into the second condition of add a row.

Any help would be amazingly appreciated,

Cairo

All responses (17)

Answers (1)

crate12 2 on at

Like (0)

Report

Re: How to update excel using planner tasks

Hi,

I tried doing this but the length formulae is causing the error.
Error msg:
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#length for usage details.'.
jjimenezar 2 on at

Like (0)

Report

Re: How to update excel using planner tasks

Hi, can you help me? I need that in the update to put the id or the name of the person who has completed the task, is that possible? inside the flow, not with a trigger ..Thanks
Jenisha 2 on at

Like (0)

Report

Re: How to update excel using planner tasks

But how do you delete a row from excel when the planner task is deleted????
Matthew1900 23 on at

Like (0)

Report

Re: How to update excel using planner tasks

All set - Checklist-Level Detail for Excel Export? - Power Platform Community (microsoft.com) Thanks.
jinivthakkar 4,179 on at

Like (0)

Report

Re: How to update excel using planner tasks

@Matthew1900 please post a new question for the issue.
Matthew1900 23 on at

Like (0)

Report

Re: How to update excel using planner tasks

Thank you all for the helpful explanations. Is there a way to easily modify the flow so as to bring in checklist-level detail (complete/not complete) based on item? @jinivthakkar

Thank you!
-Matt
zepedaasal 5 on at

Like (0)

Report

Re: How to update excel using planner tasks

Hi @jinivthakkar, thank you for the explanation. I just have an issue when it comes to deleted tasks; when a task gets deleted from planner, would this also be reflected in Excel? If so, do you mind sharing how to do so?
zepedaasal 5 on at

Like (0)

Report

Re: How to update excel using planner tasks

Hi @jinivthakkar, it all worked fine for me. I just have an issue when it comes to deleted tasks; have you tried a flow to eliminate a task from the excel file if it was deleted from planner? if so, do you mind sharing how to do so?
jinivthakkar 4,179 on at

Like (0)

Report

Re: How to update excel using planner tasks

Logic as explained:

- Get all tasks
- Initialize variable used to set bucket name
- Apply to each to iterate through each task - outputs('Lists_tasks')?['body/value']
- List rows in a table - query the excel with first task ID
If length is 0 it means no task found and add a row in excel else update the row(updating is simple)

formulae to check length - length(outputs('List_rows_present_in_a_table')?['body']?['value'])

Now explaining only adding of new tasks in excel:
if length is 0, now we need to add a task but before that we need to get the bucket name, so
- list buckets
- apply to each to iterate through bucked id and check if it matches bucket id of the task(each task has a bucket id)
- if it matches then set variable value with bucket name
- then create a new row in excel which is again simple.

Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Verified answer

jinivthakkar 4,179 on at

Like (1)

Report

Re: How to update excel using planner tasks

@Anonymous details :

Apply to each 2