Solved: Re: Create a daily summary of Planner Tasks by Buc...

IainG · ‎10-30-2019

Using this flow to generate an email for a set of daily tasks, these can be completed by a number of users, so I have amended the array to add a column for "CompletedBy", however using dynamic content to pull "value completed by user completed by display name" comes up blank. If I use any of the "id" options it pulls the ID data through.

Found an article on the same flow, their issue was on the date format but I happened to see they had managed to put in a workaround to display the assigned name. So I thought I would use it as a guide to doing it for "completedby".

https://powerusers.microsoft.com/t5/Building-Flows/How-do-I-format-the-date-in-the-standard-template...

However, I can't get it to work! Flow either fails or no data appears in the email, depending on what value I place in "*select an output from the previous steps"

v-bacao-msft · ‎10-30-2019

Hi @IainG ,

Please refer to the following method to configure your Flow.

Use an expression to get the user id.

items('Iterate_through_tasks')?['completedBy/user/id']

And set the Set TaskDetails variable action can also run normally after the Get user profile action fails.

https://flow.microsoft.com/en-us/blog/error-handling/

Then use if () function to determine whether the user id is empty, if it is, then the value of the CompletedBy field is empty, if not, then use the display name output by the Get user profile action.

if(equals(items('Iterate_through_tasks')?['completedBy/user/id'],null),'',outputs('Get_user_profile_(V2)')?['body/displayName'])

Image reference:

Hope it helps.

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-bacao-msft · ‎10-30-2019

Hi @IainG ,

Please refer to the following method to configure your Flow.

Use an expression to get the user id.

items('Iterate_through_tasks')?['completedBy/user/id']

And set the Set TaskDetails variable action can also run normally after the Get user profile action fails.

https://flow.microsoft.com/en-us/blog/error-handling/

Then use if () function to determine whether the user id is empty, if it is, then the value of the CompletedBy field is empty, if not, then use the display name output by the Get user profile action.

if(equals(items('Iterate_through_tasks')?['completedBy/user/id'],null),'',outputs('Get_user_profile_(V2)')?['body/displayName'])

Image reference:

Hope it helps.

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

IainG · ‎10-31-2019

Thanks for the detailed response, however, unfortunately, I still get an error on the Get User Profile.

WorkflowOperationParametersRuntimeMissingValue. The 'inputs.parameters' of workflow operation 'Get_user_profile_(V2)' of type 'OpenApiConnection' is not valid. Error details: The resolved string values for the following parameters are invalid, they may not be null or empty: 'id'

Thanks

Iain

v-bacao-msft · ‎10-31-2019

Hi @IainG ,

This is the expected result, so we need to set configure run after.

Because not all tasks are completed, the completed by id may be empty.

According to my method configuration, you can get the results you want.

Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

IainG · ‎10-31-2019

Hi Barry,

Apologies, very new to flows, so am confused as to what is now required?

I assume I have to configure something to except the null entry (for tasks that have not been completed), however, I had assumed that the "if" statement in the set variable was the workaround for this?

Thanks

Iain

v-bacao-msft · ‎10-31-2019

Hi @IainG ,

You only need to configure Flow according to the method in the screenshot I provided.

Is there something in the screenshot that you don't understand?

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

IainG · ‎10-31-2019

I took a further look and now see the issue the flow was failing is due to the formatting of the date!

Once I removed the formatting the flow works.

Thank you for your help I can now see the user name!

I will now work on formatting the date to something cleaner.

Regards

Iain

Behzad-Navabian · ‎12-14-2019

Hi @v-bacao-msft ,

your solution for getting CompletedBy works perfectly fine,

Thank you! & wish you a nice weekend!

JeffNg88 · ‎01-13-2020

Hi @v-bacao-msft ,

Thank you for the detailed explanation. Sorry if my question was too stupid, I still couldn't get the flow working after following the guide. It keeps giving me this error whenever i'm trying to save the flow:

The template validation failed: 'The repetition action(s) 'Iterate_through_tasks' referenced by 'inputs' in action 'Get_user_profile_(V2)' are not defined in the template.'.

My end goal is to update the CompletedBy UPN into SP List when a task is completed.

Kindly advise. Thanks in advanced.

CaoMJ · ‎09-30-2020

I ran into the same issue - did you figured out what was wrong?

Behzad-Navabian · ‎10-01-2020

Hi @CaoMJ @JeffNg88 ,

Can you share your expression ? the way see it , you need to do it the other way around i would say. here "Item " refers to Each row in apply for. what you need is get CompletedBY from main body which is "when a task is completed"

The Expression should be something like this :

triggerOutputs()?['body/CompletedBy/User/id']