cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
freddiejoseph1
Helper IV
Helper IV

Get AssignedBy and AssignedTo information in daily summary of planner tasks email

Hi all,

 

I have created a flow which looks like this template: https://emea.flow.microsoft.com/en-us/galleries/public/templates/df5797658f954281b54bad8bf9cc8246/cr... for some reason I cannot find a way to include information about who has been assigned to the task, or who the creator of the task was. Could anyone point me in the right direction?

 

Also - when the created date and due date are populated in the table they show the date as yyyy-MM-dd & the time (like the screenshot attached). How can I change that so that only the date appears (without the time) and with the date format dd-MM-yyyy?

 

freddiejoseph1_0-1622819882082.png

 

 

Many thanks,

 

Freddie

5 REPLIES 5
PrasadAthalye
Super User
Super User

From the list task, you can pick following?

 

PrasadAthalye_0-1622825762390.png

and for assignments you can pick following and then use office 365 user action to query the user

PrasadAthalye_1-1622826021263.png

 

Refer information given within this thread..

https://powerusers.microsoft.com/t5/Building-Flows/Exporting-the-Assigned-To-user-ID-from-Planner/td...

 

For Date conversion, you can simply use formatdatetime expression

 

formatdatetime(utcnow(), 'mm/dd/yyyy')

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Hi Prasad,

 

Thanks for getting back to me. Sorry about my delayed response.

 

I am able to select the Created by User Display Name, yes. But it just shows as a blank field in the table for some reason: 

freddiejoseph1_0-1623140560831.png

 

I have tried following the more complex way of getting the assigned by and assigned to information using the info from the link you provided. I cannot work out where abouts in the flow to try and loop that substring in to get the right information. Where would I put it? This is what my flow looks like currently:

 

freddiejoseph1_1-1623145014129.pngfreddiejoseph1_2-1623145034794.png

 

 

Thanks,

 

Freddie

Did you add substring logic under the apply to each loop? You should find assignments collection... If you did, can yo show expression?

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Hi, yes I did add it under the apply to each look. You can see the screenshot below. I think the flow is now stuck in an endless loop though. 

 

I had to zoom out quite a lot so I have sent a couple of screenshots.

 

freddiejoseph1_1-1623161263525.png

freddiejoseph1_3-1623161313082.png

 

 

 

freddiejoseph1_0-1623161166164.png

 

Thanks,

 

Freddie

 

Sorry. I have made a couple of little changes and I am a bit closer I think, but still not quite there yet. I have added another condition in so that if the assignments value = "" then the value of the variable is set to "Unassigned". But for some reason that still isn't working. I get the below showing in my table now.

 

freddiejoseph1_0-1623165838758.png

 

However, the value always shows as unassigned, even when the value shouldn't be blank.

 

freddiejoseph1_1-1623166017429.png

 

 

Thanks,

 

Freddie

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,787)