Hiya Community,
Could anyone provide me some assistance in regards to a flow I am trying to build?
I have an issue trying to attach a specific sharepoint file to an email response based on the microsoft form results. For example, I have a form with one of the questions results are Level 1 and Level 2. What i would like to do if send the responder an email with a specific PDF depending on which Level they selected.
Any replies will be greatly appreciated.
Hiya @OliverR-82 @v-LilyW-msft
Thank you both for your help regarding this. @OliverR-82 your last reply solved the issue and i received the specific PDF for both Level 1 and Level 2.
Awsome work from the pair of you.
I've just set up a quick test form myself and can confirm that answers to multiple choice questions seem to get an added line attached to them when you process the results.
If the only 2 options to that question are "Level 1" and "Level 2" then you could work around this by evaluating on the first 7 characters of the "Which level" dynamic content; that would give you just "Level 2" without the added line.
The expression is as follows:
substring(<insert your dynamic content here>,0,7)
There may be better or more elegant ways to work around this, but this seems to work.
So, to be clear: instead of just inserting your dynamic content in the Switch action, you would write the above expression in the expressions window and insert that. While writing your expression, you can insert your "Which level" dynamic content in the expression as described above.
@OliverR-82Thanks for all your support, this is definately a learning curve for me.
I have removed and re-added the switch and once tested, received the same error. This is really confusing.
Ah, I see now. My suggestion was wrong, I apologize. You would not add a new line in the Switch action, but rather in the 'Case' and 'Case 2' actions. However, it does not allow you to do that, so I'm out of ideas for the moment.
Yes, deleting the Switch action and adding it again is probably a good idea at this point.
I can confirm that it has just added a 2nd line.
@OliverR-82Would removing the switch and re-adding it have any change?
Yes, I understand your confusion now. I have no explanation as to where the extra line comes from and if it is something that you can change or configure in your MS Forms configuration; I am not knowledgeable about MS Forms. You could try adding the extra line in the Switch action as per my previous post, and see if that works.
Oh I apologize, I just notice that you already provided a screenshot of that action in your earlier posts. You can ignore my request then.
So, judging from your other screenshots, it looks like what MS Forms is returning as a response is:
Level 2
<new line>
I don't know why it does that. But, if that's not something you can change, you could try adding a new line to the Switch action. So, after the Dynamic content, press enter so that it DOES look like this:
@NebulaRoss can you post a screenshot of how you have configured your Switch action? So, not a screenshot of a flow run (which shows the results of a flow run), but how you have configured it while editing your flow. That way, we can see if you (accidentally) added the new line yourself after the dynamic content, or if that is how the result is returned by MS Forms. So, this part of your flow:
It should look like that.
It should NOT look like this (note the added space, which indicates a new line):
Hiya @OliverR-82
Thanks for your assistance. Unfortunately I am still learning power automate. I am not sure how/why there would we a new line in the code when applying the dynamic response within the Swtich. Also, how do you access the switch content as code. this may be a lot easier to see why errors occur.
Sorry for being a pain regarding this request.
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1