Hello,
I created a company planner tool that among many other fields, it uses AssignedTo (people field) to set the assignee of the task. Only one person is assigned to a single task (in the field settings I set not to allow multiple people).
I'd like to set a Flow that sends a reminder to the assignee N days before the due date contained in another field. The email will contain ALL the tasks for a specific assignee
I tried to replicate THIS POST but for an unknown reason it fails when appending the value to the array; this could be because my AssignedTo field is not allowing multiple people and for some reason flow handle a single user not as an array.
Is there a way to achieve the same goal in my scenario?
Thanks in advance for any help
Solved! Go to Solution.
Hi again
Thanks for your last detailed post. I think your current problem is: you expect SP List 'AssignedTo' column output to be an array of elements (each element a Person object), but the output is actually a single Person object, not an array.
So, I would replace your current expression and try with this instead:
item()?['AssignedTo']?['Email']
Hope this helps
Proud to be a Flownaut!
Hi!
Can you share a screenshot of your Flow so far in edit mode?
Thanx!
Proud to be a Flownaut!
Hi,
thanks for the reply.
I kept in my test only the section that doesn't work (the last step)
The error I get is this one
Thanks!
Hi again
Thanks for your last detailed post. I think your current problem is: you expect SP List 'AssignedTo' column output to be an array of elements (each element a Person object), but the output is actually a single Person object, not an array.
So, I would replace your current expression and try with this instead:
item()?['AssignedTo']?['Email']
Hope this helps
Proud to be a Flownaut!
Thanks, I tried both your solution and another approach from HERE
and they both work! Thanks!
Hi
Glad to see you found another valid approach 😉
Happy Flowing!
Proud to be a Flownaut!
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
17 | |
14 | |
7 | |
6 | |
5 |
User | Count |
---|---|
24 | |
18 | |
10 | |
8 | |
7 |