cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

User or Group fields from item to Flow

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..

 

 shp_flow.JPG

 

 

shp_flow2.JPG

 

 

 

Is this some kind of BUG?

 

 

Thank you

9 REPLIES 9
Highlighted
Community Support
Community Support

Re: User or Group fields from item to Flow

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.

55.PNG

 

 

 

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: User or Group fields from item to Flow

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

Highlighted
Community Support
Community Support

Re: User or Group fields from item to Flow

Hi @ivan_stricek,

 

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:

1.PNG

If you have any further questions, please post back.

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: User or Group fields from item to Flow

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

 

 

Highlighted
Community Support
Community Support

Re: User or Group fields from item to Flow

Hi @ivan_stricek,

 

Thanks for sharing and the update.

 

Regards

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: User or Group fields from item to Flow

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

Highlighted
Anonymous
Not applicable

Re: User or Group fields from item to Flow

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.

Highlighted
New Member

Re: User or Group fields from item to Flow

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

Highlighted
Advocate IV
Advocate IV

Re: User or Group fields from item to Flow

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,

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (2,677)