Unanswered

Get MS Form responses

(1) Share

Report

Posted on by Community Power Pla...

Hi, Im getting the responses from a MS Form, but Im getting troubles when I try to get the response from a question that has 2 words separated by a space

Question example

So in the json I get something like this

{
 "@odata.etag": "",
 "ItemInternalId": "",
 "ID": "32",
 "Start time": "2023-02-03T14:38:49.000Z",
 "Completion time": "2023-02-03T14:39:15.000Z",
 "Email": "",
 "Name": "",
 "Ticket / RFC number\n": "34747",
 "Description": "sjfjsfsf",
 "Comments": "najfsnaksfj\nfdsfdf\ndgdg",
 "Ticket Stage\n": "To be checked",
 "Category": "RFC Follow up"
}

And in the select Im using item()?['Ticket / RFC number'] to get the respective value and show it in an HMTL table in an email, but in the table that space for Ticket / RFC number is blank

This is the final HTML table, all the values that come from questions that have blank spaces between words are in blank

What is the correct format to get those values in the select?

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,585 Most Valuable Professional on at

Like (0)

Report
Re: Get MS Form responses

Hi

In your JSON data you have

"Ticket / RFC number\n": "34747",

Not sure why you have a \n here?

Also your expression looks like this

item()?['Ticket/RFC number'] Here there are no spaces.

Try the below

item()?['Ticket / RFC number']

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report
Re: Get MS Form responses

Hi @abm, thanks for the response

Im not sure why there is a /n either, Im redacting the question with no line break
{ "@odata.etag": "", "ItemInternalId": "************", "ID": "32", "Start time": "2023-02-03T14:38:49.000Z", "Completion time": "2023-02-03T14:39:15.000Z", "Email": "example@gmail.com", "Name": "example name", "Ticket/RFC number\n": "34747", "Description": "sjfjsfsf", "Comments": "najfsnaksfj\nfdsfdf\ndgdg", "Ticket Stage\n": "To be checked", "Category": "RFC Follow up" }

I change the question to "Ticket/RFC number", in the select Im using the same item()?['Ticket/RFC number'] and is not working, the values in the html table still empty
Also try with item()?['Ticket/RFC number\n'] but still not working

This is the full input of the select
[ { "@odata.etag": "", "ItemInternalId": "************", "ID": "30", "Start time": "2023-02-03T14:14:36.000Z", "Completion time": "2023-02-03T14:15:42.000Z", "Email": "example@gmail.com", "Name": "example name", "Ticket/RFC number\n": "35353", "Description": "RFC Follow up test", "Comments": "", "Ticket Stage\n": "Pending", "Category": "RFC Follow up" }, { "@odata.etag": "", "ItemInternalId": "************", "ID": "32", "Start time": "2023-02-03T14:38:49.000Z", "Completion time": "2023-02-03T14:39:15.000Z", "Email": "example@gmail.com", "Name": "example name", "Ticket/RFC number\n": "34747", "Description": "sjfjsfsf", "Comments": "najfsnaksfj\nfdsfdf\ndgdg", "Ticket Stage\n": "To be checked", "Category": "RFC Follow up" } ]

And this is the output
[ { "Ticket / RFC number": null, "Ticket Stage": null, "Description": "RFC Follow up test", "Comments": "", "Last Assignee": "example name" }, { "Ticket / RFC number": null, "Ticket Stage": null, "Description": "sjfjsfsf", "Comments": "najfsnaksfj\nfdsfdf\ndgdg", "Last Assignee": "example name" } ]

As you can see, if the question in the form has two words separated by a space the value will be null, if I change the question to only one single word it will work but I need to put two or more words for users to understand

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Get MS Form responses

Hi @Anonymous

Thanks for your quick reply.

Interesting issue. Could you try deleting that question in Forms and add it again without the slash. See that works. Then add the slash back again.

Thanks

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Get MS Form responses

Hi @Anonymous

I did tried the below.

Here is my flow

Here is my result

Not sure why you getting the question name. See above where I get the ID of the question not the text.

Thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Re: Get MS Form responses

@abmI already tried your suggestions above, but still not working, did you do something different when creating the form? Maybe something related with format? Is weird that you are getting a ID and Im getting the exact question

Was this reply helpful? Yes No
abm abm 32,585 Most Valuable Professional on at

Like (0)

Report

Re: Get MS Form responses

Hi @Anonymous

No I haven't done anything different. Your response is better 😃 which contains question. Try deleting that question and remove the back slash '/' call something like Ticket or RFC number

Was this reply helpful? Yes No