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?
From the list task, you can pick following?
and for assignments you can pick following and then use office 365 user action to query the user
Refer information given within this thread..
For Date conversion, you can simply use formatdatetime expression
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:
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:
Did you add substring logic under the apply to each loop? You should find assignments collection... If you did, can yo show expression?
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.
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.
However, the value always shows as unassigned, even when the value shouldn't be blank.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.