User or Group fields from item to Flow

(3) Share

Report

Posted on by michal_sutek

Hello,

I have little problem, I have list where one Item contains columns:

Name, Date from, Date to, Note, Approvers, Status

Approvers field is set as "Person or Group" type - so when the Item is created there should be information like Name, email, department....

I want to made approval proces wiitch start when Item is created and send approval emails on adresses specified in Approvers field (where our sharepoint users can be pointed)

In Flow, there is possibility to insert fields from just created Item, so I should be capable to use Approvers fielad (email) as target addresses for sending approval email.

Thing is, that if I use Name, Date from, or Date to colums from created item, it retrive values ok, but if I use field Approvers (name, email or other) it will return empty string, even the column contain person/s. I have tried to retrive Approvers email from this list with Designer 2013 and it works, but in designer I cant send email with buttons so I need to make it in Flow..

Is this some kind of BUG?

Thank you

Categories:

Using flows

I have the same question (0)

All responses (9)

Answers (0)

Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi,

you can still achieve it using a workaround. Please read this article.

http://sharepointmadeeasy.blogspot.com/2018/02/microsoft-flow-send-mail-to-multiple.html

Thanks,

Was this reply helpful? Yes No
Mduque1234 2 on at

Like (0)

Report
Copy link

Link copied!

Actually now it works for me. You just have to configure the people picker (person group field) to show field like ID then you´ll get email or whatever information you have in the profile dinamically ... let me know if that works now for you

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

I wasted a coupple of hours before I figured I'd reach out here. My lesson is I'll spend more time with community. I also think some "error-message" would be more appropriate than implementing a flawed feature.

Was this reply helpful? Yes No
ErikSargent 4 on at

Like (0)

Report
Copy link

Link copied!

You should at least support reading the first value. Or else return an error string or something - otherwise this is impossible to troubleshoot.

Was this reply helpful? Yes No
v-micsh-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Thanks for sharing and the update.

Regards

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Copy link

Link copied!

Yes, ok.. I can do workaround wiht classic workflow with what I just copy the dates as string into secondary list, and then use the text values from this list to put them into oroginal uploaded item as date.

The same workaround I can use for retrieving mails for more users from User or Group field. So I can use them as recipients in approval mail.

Last obsticle is that approval email dont wait for all recipients responses and cant compare number of positive and negative responses. - Hope this will be the next fix for this component.

Thank you

Was this reply helpful? Yes No
v-micsh-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

For question 1, well yes, that should be related with Time Zone.Microsoft Flow uses UTC as the timezone when querying the date from data source.

Apologize to say that currently I have no workarounds could offer.

For the Create Event, if you mean the Calendar ID, please click on the dropdown icon, which would show you the available Calendars:

If you have any further questions, please post back.

Regards

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

OK thank you I will submit it :).
And two more things:
1, we have strange problem that Dates from item fex. 3.2.2017 to 5.3.2017 are in flow transformed to output with one day less like 2.2.2017 to 4.3.2017 - is there some timezones between sharepoint and flow, what should be synchronize?

2, If we want to create event in user outlook calendar, what kind of ID we shoult put into flow komponent and how can we get it?

Thank you

Was this reply helpful? Yes No
v-micsh-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @michal_sutek,

I saw your SharePoint list people column have multiple values, is this people have the multiple values set to true?

Microsoft Flow currently don't support reading data from people column field which have the multiple values configured.

If you would like Microsoft Flow to support this field with multiple values, please submit this as an idea under MIcrosoft Flow idea forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards

Was this reply helpful? Yes No