What Microsoft Flow can do ?

(0) Share

Report

Posted on by Negi1984

Hi All,

I heared that by Microsoft flow we can do lots of automation with in the Process.

I am looking for your valuable suggestions on my below mentioned queries if we can achieve this goal by Flow or not?

Eg : Basically I wanted to automate a process: where we received resource onboarding request from CPM , we do some manual check and add some more information from Active directory than forward that request to another team to perform.

Detail steps : -

1) CPM will enter records in Sharepoint form or provide excel which needs to automatically upload in sharepoint list. and submit a request to us. this form contains the information about resource Employee ID/Domain / Rate card/Travel profile etc.... . So here I want to know as soon as CPM submit a request automatic mail should send to CPM and me that request has been successfull submitted and next team have to work on it.

2) Now in 2nd stage : Can flow check the Employee ID and get the information from Active directory like resource office Address / Country / Contact no etc ?

3) In third stage : Can flow add the resources email ID to distribution list ?

Also looking for good training references related to my above mentioned query.

Thanks in advance for your valuable suggestions.

Regards,

Rajender

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

RezaDorrani 12,143 on at

Like (0)

Report

Hi @Negi1984

1) CPM will enter records in Sharepoint form or provide excel which needs to automatically upload in sharepoint list. and submit a request to us. this form contains the information about resource Employee ID/Domain / Rate card/Travel profile etc.... . So here I want to know as soon as CPM submit a request automatic mail should send to CPM and me that request has been successfull submitted and next team have to work on it.

You can run your Flow (trigger) when item is created in SharePoint or whena new row is added in excel
You can use send email action to notify immidiately when item is added
Alos notify your next team via email

2) Now in 2nd stage : Can flow check the Employee ID and get the information from Active directory like resource office Address / Country / Contact no etc ?
Yes flow can
You can use the Office365Users connector to fetch all details
There arE even connectos available for Azure AD

3) In third stage : Can flow add the resources email ID to distribution list ?
Not yet possible in Flow
https://powerusers.microsoft.com/t5/Flow-Ideas/Add-users-to-Outlook-365-distribution-groups/idi-p/141286?collapse_discussion=true&q=an%20AD%20Distribution%20List&search_type=thread
Vote on user voice
Users can be added to Office 365 groups but not distribution lists

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Negi1984 38 on at

Like (0)

Report

Hi Reza,

Thank you so much for your valuable feedback. Could you please also suggest me learning material related to this. where I can learn step by step.

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,143 on at

Like (0)

Report

Hi @Negi1984

New to Flow
https://docs.microsoft.com/en-us/learn/paths/automate-process-using-flow/

Here is a link to all Flow learning resources
https://flow.microsoft.com/en-us/blog/microsoft-flow-learning-resources-materials/

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No