cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Connect forms with sharepoint lists

Hi all

 

I did a MSFT Forms and created 2 sharepoint lists.

 

One SP list is called Greater China & Korea and the other one is called ASEAN.

 

One of the questions on the form is if you are in ASEAN or Greater China & Korea.

 

What I want to do have in the flow is that if the person selects ASEAN in the forms for example, the answers will got tot the ASEAN sharepoint list only.

 

The problem I have is that all the answers are going to both sharepoint lists.

 

 This is my flow:

 

sdfdsfsf.JPG

 

1234.JPG123.JPG

How can I get it right in the flow?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi again

When you typed 'Japan' in 'Condition 4'... did you added by mistake a hidden space?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

19 REPLIES 19
Highlighted
Community Support
Community Support

Re: Connect forms with sharepoint lists

 

Hi @diegoandre10 ,

 

You should add Condition below Get response details action to check which list the user has selected.

Then configure the two Create item actions in the two branches of the Condition.

Please try again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hola!

First of all I would get rid of the 'Apply to each' and move 'Get response details' just after your trigger.

Now, you need to add a 'Condition' action block just after 'Get response details', evaluate response to your target answer there

'Condition' action block will set up two branches: true (yes) branch and false (no) branch.

So assuming you compare the response to your target question with value 'ASEAN', in your true branch you need to add 'Create item' in the ASEAN SP List; in your false branch you need to add 'Create item' in the alternate SP list

Hope this helps

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes  and @v-bacao-msft 

 

I created the condition but didn't work as planned.

 

Basically you have 4 possible paths, so I did 4 conditions:

 

BUs.JPG

 

My flow is:

 

First (1) if Business Unit is equal to Greater China & Korea then create the item in that Sharepoint List.

 

If no, move to second condition (2): if Business Unit is equal to ASEAN then create the item in the ASEAN Sharepoint list.

 

If no, move to third condition (3): if Business Unit is equal to India & South West Asia then create the item in the India & South West Asia Sharepoint list.

 

If no, move to final condition (4): if Business Unit is equal to Japan then create the item in the Japan Sharepoint list.

 
1,2,,3.JPG
 
4,5,6,.JPG
 
 
 
I ran a test with a project title called "only Japan test 1" using Japan as the Business Unit in the form and got this result in the sharepoint lists:
 
 
oj4.JPG
The project wasn't added in Japan.ooj2.JPGoj1.JPG
 
oj3.JPG
Added in Greater China and ASEAN.
 
What do you see wrong in my flow?

Thanks!
 
 
 
 
 
Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi again!

Your screenshot is so big I just can see the boxes, but not the inputs assigned 😞

 

"I ran a test with a project title called "only Japan test 1" using Japan as the Business Unit in the form"

 

May I suggest you to add a 'Compose' action block just after 'get response datails', assign as its input 'Business Unit' response, reexecute the flow and share its contents?

Since you did considered suppressing 'Apply to each' yet, please also share the nr of times 'Apply to each' is executed also

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes 

 

I tried with the compose, but the item was not added on the Sharepoint list of Japan. It was added on Greatet China and Asean, despite selecting in my form only Japan. 

 

Here is the new flow:

 

1jpn.JPG

2pjn.JPG

34jpn.JPG

 

The results:

 

sp4.JPGsp3.JPGsp2.JPGsp1.JPG

 

If you need me to share the flow let me know.

 

Thanks a lot for your help!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi!

Sorry I did not explained myself well, please share the output of the 'Compose' action block when executed

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes 

 

Sure, here it is:

 

out1.JPG

out2.JPG

out3.JPG

out4.JPG

 

All the inputs are false in the conditions, but the condition 4 should be true since it is for Japan.

 

Thanks!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi again

When you typed 'Japan' in 'Condition 4'... did you added by mistake a hidden space?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



View solution in original post

Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

hi @efialttes 

 

You are right, it had an enter. It was now added in Japan SP List 🙂

 

The problem is that it was added to China and ASEAN too, have a look:

 

onjpan1.JPG

oj2.JPG

oj3333.JPG

 

So, the flow added the item to condition 1, 2 and 4. Despite being true only 4.

 

Results:

 

11111111.JPG3dfdsf.JPGl;;l;;l.JPG

 

Thanks a million!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Wait wait wair

Does it work now as expected? If so, CONGRATS!

 

 



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes 

 

Partially solved haha, the item still appeared on the SP list of China and ASEAN. Should appear only in Japana.

 

Have a look the results of my previous comment.

 

Thanks!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi again!

Well, close to the happy ending 😄

Please check again your last flow execution... How many times is your 'Apply to each' being executed?

If more than once, please remove the 'Apply to each'

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes 

 

Yeap, close but will get there!

 

Where do I look at the times?

 

Last execution shows this, is it 1? :

 

dfdsafsdfsdsf.JPG

 

What caught my attention is that the first and second conditions, even though were false and the create item shows not satisfied. , an item was added to China and Asean:

 

dsdfsfs.JPG

 

Thanks again!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

Hi!

Can you test again with a new project name?

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Hi @efialttes 

 

I added a project called "Flownaut" for India & South West Asia

 

But it was added to SP list of China, ASEAN too 😕

 

f8.JPGf6.JPGf5.JPG

 

To the Japan SP it wasn't added which is correct. The problem seems to be with China and Asean SP lists.

 

flownaut3.JPGflownaut2.JPGflownaut1.JPG

 

I did a zip of the flow, can you open it?

 

https://1drv.ms/u/s!ApgeWwGTKtFdhmyYRN_GawjluUyT?e=h8Vts7

 

I dont what's wrong 😞

 

Thanks!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

@diegoandre10 

Aaaargh! I am afraid I cannot import it, it crashes... I guess due to the fact I do not have permissions to access the Forms Survey.

Can you share several screenshots from your current flow design? I mean you already did it but in a single image that was so big I could not see the inputs assigned in each step

THanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

HI @efialttes 

 

I think the problem was that I had activated the old flow haha. So I just deactivated it.

 

You solved my problem and I highly appreciate your time and help!

Highlighted
Dual Super User
Dual Super User

Re: Connect forms with sharepoint lists

OMG! The issue is finally solved! 

Congrats! Enhorabuena!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Helper IV
Helper IV

Re: Connect forms with sharepoint lists

Gracias!

 

Apologize for not considering the other flow that had to be deactivated.

 

Have a great day 🙂

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Users online (8,655)