Unable to link Form shared with me

[Anonymous]

I am working on a Flow which uses trigger "when a new response is submitted" for an O365 Form. A colleague has created a new Form to link to it and shared with me but it does not appear on the drop down list to select to add. Is there a way to add manually and if so what do you input? 

Otherwise the only way around it I can see is for me to save as the Form and then link from there. I would expect if its shared with me for it to appear on the drop down as if I had created it so a little clunky. 

[RobElliott · Accepted solution]

By  O365 Form I assume you mean a form in Microsoft Forms? If so and it's been shared with you it's a group form and although you can't select a group form from the dropdown you can enter it as a custom value.

Get the url for the Form and in the trigger in Flow paste just the characters AFTER the id= as a custom value.

So if for example your form response url is..
https://forms.office.com/Pages/ResponsePage.aspx?id=g63aHu-yPUiB8SxIaC9A7B4fqWJxhk9EprbnRFYHGoVUME41...

..you paste the following in as a custom value both in the "When a new response is submitted" AND in the "Get response details" action.

g63aHu-yPUiB8SxIaC9A7B4fqWJxhk9EprbnRFYHGoVUME41R1FRMURSREpJNUpVQVlMRDY1SDdTNSQlQCN0PWcu

Then you carry on with the Flow as normal.

Rob
Los Gallardos

[cymorg1]

To say the current behaiour is a little clunky is putting it mildly. I don't see why a "Shared with me" option exists at all when it seems impossible to share forms created in MS Forms, with individual users or groups.  I understand items created in that manner can still be shared, but not specifically with "me".  Perhaps MS Forms created in some other way appear under "Shared with me", if so my colleagues clearly don't want to share with me as I've never seen anything in my list. 😐

[Frown]

I realize this is an old post, but I just wanted to say a big THANK YOU to Rob Elliott for is response!!!!! You saved my butt, dude.

[Claire_Elspeth]

Brilliant, thank you!

[ninjaryder1st]

This didn't work for me (4/5/21) noting the Flow could not recognize the Form from the Form link pasted into the Flow ID denotes the "Form ID requested is invalid" note in pink. 

[RobElliott]

It didn't work for you because you pasted in the whole url which is incorrect. You must only paste in the form ID which is the part AFTER ID=

You can see examples of it earlier in the thread.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[ninjaryder1st]

@RobElliott   that was it!  Thanks for clarifying its not the entire URL.  I missed that in your original response, thinking it was instruction for cut/paste the entire URL in the Form ID field for the trigger.   

[dtshepherd04]

@RobElliott appreciate your feedback to others above. When I'm using a form that's shared with me, how would I get certain fields to populate in the create task? For instance in mine, if I wanted the title to be what is known in the form first/last name, I'm not seeing that option right now. Is that possible?

This is what I have now:

This is what I'm trying to get:

[cymorg1]

Try using the "Response ID" in the "Get response details" action directly after the "When a new response is submitted".

[dtshepherd04]

@cymorg1  I'm unable to get the response id like you you have picture in your screenshot. Any tips? Does that mean I copied my link wrong?

[cymorg1]

@dtshepherd04 The trigger for my flow was "When a new response is submitted".  If you don't have that as your trigger you won't be able to get the "Response ID".

[dtshepherd04]

That makes sense! Thank you!

[MarkSinghGDI]

Thanks Rob.. this worked so far and I triggered notifications. However I don't see any dynamic content. Is there a way to include that as well?

[RobElliott]

@MarkSinghGDI have you included the get response details action? It's required.

Rob

Los Gallardos

[MarkSinghGDI]

I did not - forget that step b/c I was so happy to get this part working :). Works now.

[shred21]

Thanks for this post - very cool! 

Question: does the list need to have all the questions as columns? It worked, but no data showed up in the list. Of course, there's only one column there now (Title). The form I am capturing has 36 unique questions. Assuming I need to create 36 cols ?

thanks in advance... 

[RobElliott]

You need to have one column for each question in the form. Then in your create item action add the response from each question into the appropriate column.

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

[shred21]

Got it. Thank you for the prompt reply... time to get busy creating columns! 😊

[jlapvf]

I am having the same trouble as above, but when I insert the ID, it doesn't seem to do anything, and the fields don't pull from my should-be-linked Form.