
Hi there,
I am attempting to create a flow that upon creating a new item in a SharePoint List, a flow is generated to a manager based on 'Department' (6 departments) who then delegates one person (10 per department) and that person will be populated back into the List.
My initial thought was an approval with custom responses (one for each delegate), but I didn't know if that value would make it into SharePoint as a person when I used update item?
Any thoughts or different approaches would be helpful!
Hello @sarah4496 ,
I think it would work with custom responses, but you must be able to identify the specific user and I'm not sure if a name would be enough. I'd probably add also email of that user in the response, e.g.
Tom Riha | xxx@tomriha.com
John Black | yyy@tomriha.com
That way you can use the split(...) expression on the selected response to split it by the separator and take only the email address, e.g.
split([Respose], ' | ')[1]
Note:
[Response] is a placeholder, replace it including the [ and ] with the response dynamic content
And once you get the email address you should be able to easily update it into a SharePoint people picker column.