You’re offline. This is a read only version of the page.
I'm trying to figure out if there is a way to format a linke to a reponse in MS Forms. I would like to add a 'click here' type of link to an e-mail flow each time a response is submitted. I don't really need to emebed the detail variables into the message since the users who need the data will all have access to the form responses.
I was able to figure this one out. Here's what I did for the variables:
Hope this helps.
Hi Marc, any chance you found a solution to get the ResponseToken? I'm trying to save the link of each fulfilled forms in a SharePoint List. I'm the only one who answers the form, but getting the saved responses in "fulfilled forms" tab is somehow tricky.
this is fantastic! I'm very close but would it be possible to show the expanded view of each of those steps? So that I can see 'Name' , 'Type' , and 'Value' for each of the variable steps? would be greatly appreciated
@kinnett You can do the whole thing with the compose action too, rather than using variables. I used variables because they were easier to use in my multi-level flow. Using compose simplifies the whole thing quite a bit. You could even do it in one compose action, but I think it's easier to break up math actions from string actions.
Here's a simple example.
Inside the subtraction compose action, have the following expression which adds negative 1 to the response ID. @Amira703 If you just grab the response ID from the dynamic content you get from the Get Response Details action, it will be the one that was most recently submitted.
Share
Report
All responses (
Answers (add(-1,triggerOutputs()?['body/resourceData/responseId'])
Inside the Compose URL action, I have this input. This prevents you from having to muck around with concatenate expressions. The dynamic content here is just the output from the subtraction compose action.
Then in the email, I find it easier to create the link within the HTML code instead of trying to get dynamic content into the WYSIWYG editor. The dynamic content here is the output from the URL compose action.
Then the URL is actually a link in the email so folks can just click it instead of having to copy and paste.
I have tried this multiple times and keep getting the error- "enter a valid integer". Can you clarify for me what goes in each of these boxes? I assumed this went into "initializing variable 2", but I keep receiving the "enter a valid integer" error
3. Initialize variable: responseURL (String)
4. Initialize variable 2: responseID (Integer)
5. Set variable
6. Set variable 2
I'm not very experienced with initializing and setting variables. Are you able to open those steps to show the code inside?
The way I'm doing it must be wrong since the URL that results defaults to the first response vs. most recent. The ridx number increases by one each time, but how to do I code it to go to the most recent ridx?
Angelwing,
Your images don't show where or how you modified the URL to create the link to the form responses. If you include more detail there, we might be able to help.
KES2,
Sorry for the late reply. Here is a page on using variables in Power Automate. You need to "initialize a variable" first. In that step, you'll name the variable and choose the type of variable (string).
The compose step is a bit more difficult to explain, but if you look at @goncaloperes's post right above yours, you'll see a clearer explanation.
In the future, if you have a question that does not fit the topic of a discussion, such as how to use variables, you should probably start a new thread.
~C
Hi goncaloperes,
I tried your method and everything worked except when the email is received, the link gets an error that the form doesn't exist. I have attached a view of the process as it is now. Can you help?
#1
David_MA
276
Super User 2025 Season 1
#2
Michael E. Gernaey
234
Super User 2025 Season 1
#3
stampcoin
210
