cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JPChadd
Level: Powered On

Using Flow to sepeate Form to different SharePoint lists

Afternoon,

 

I am wondering if the following scenario might even be possible.

 

We have a requirement for using a Form to as part of a process which we'd like to replicate to another section of our department. As below:

* We have the Form which outputs results to a SharePoint List in location A

* Another area of the department would like to use the same Form that outputs the results to a list in within their departmental SharePoint

 

What I am looking into is whether or not there is a possible option within Flow that will allow this to happen, maybe adding a question to the Form along the lines of 'Are you from Dept A or B?' and then depending on the outcome, Flow recognises this and by setting a condition, Flow will output the data to the relevant SharePoint list?

 

I have been looking into manually setting up a Flow from scratch, but am not sure, unless I am missing something obvious that I am not missing anything here.

 

I appreciate that I have the other option of copying to form and using Flow to output the data to their SharePoint list and simply providing them the URL for that to happen.

 

Any help or advice would be most welcome.

 

Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Using Flow to sepeate Form to different SharePoint lists

@JPChadd 

Please see my additional comments on the first response (sorry I edited it instead of posting a new one).

One you add the trigger and the action block "Get response details", the edditor will automatically add the "Apply to each" block. You just need to add the condition inside it and select the proper expression.

Hope it helps





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





7 REPLIES 7
Super User
Super User

Re: Using Flow to sepeate Form to different SharePoint lists

@JPChadd 

 

You are thinking on a Form like this, right?

 

test_forms_1.png

If so, you can build a Flow that will trigger with each response, analyse the answer to "1. Source Dpt", and apply a different service logic depending on the response given, as you will see in the following screenshot:

test_forms_2.png

 

Please note the user that creates the Flow shall have access to both Sharepoint sites

Hope this helps





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





JPChadd
Level: Powered On

Re: Using Flow to sepeate Form to different SharePoint lists


@efialttes wrote:

@JPChadd 

 

You are thinking on a Form like this, right?

 

test_forms_1.png


Hi,

 

Yes, that is right. So we have a form with a large number of questions, so I'll add another, like your example.

 

So if Dpt A is the response given, then Flow will send the Form data to Department A SharePoint list. However if the response is Dpt B, the Form data will be sent to Department B SharePoint list.

 

Thanks.

Super User
Super User

Re: Using Flow to sepeate Form to different SharePoint lists

@JPChadd 

Please see my additional comments on the first response (sorry I edited it instead of posting a new one).

One you add the trigger and the action block "Get response details", the edditor will automatically add the "Apply to each" block. You just need to add the condition inside it and select the proper expression.

Hope it helps





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





Super User
Super User

Re: Using Flow to sepeate Form to different SharePoint lists

@JPChadd :

Another option you can try is to leverage the Office 365 User profile information.  If the department information is populated, it will eliminate the need to prompt users for where they work.  You can retrieve the user profile info of the individual who submitted the form via their email address (available from Dynamic properties for Get Response details).  This information is populated in Exchange and must be configured by an admin.

Department.jpgDepartmentA.jpg

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
JPChadd
Level: Powered On

Re: Using Flow to sepeate Form to different SharePoint lists

Hi,

 

Thanks, I will take a look at that.

 

 

JPChadd
Level: Powered On

Re: Using Flow to sepeate Form to different SharePoint lists

Hi Scott,

 

Thanks for that, again I am not sure if that is something we do or utilise, so I'll look into that also.

Community Support Team
Community Support Team

Re: Using Flow to sepeate Form to different SharePoint lists

Hi @JPChadd ,

 

What’s your current situation?

If you are still having problem with this issue, please feel free reach to us.

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 233 members 4,651 guests
Please welcome our newest community members: