Get a Form's name (instead of GUID) in a Flow when creating item in SharePoint list

[PhilD]

I have several forms that have Flows configured so that when a response is submitted, an item is created in a SharePoint list. This works well enough, recording the user's name, their department and when the flow was submitted. The only thing I cannot seem to achieve is to simply write the name of the Form that triggered the event.

This successfully puts the GUID of the Form that triggered the event in the SharePoint list. How do I display the text title of the Form instead?

first(triggerBody()?['value'])?['resourceData']?['formId']

I have about a dozen mandatory education quizzes, and lots of departments so I want all the Forms to record entries on the same SharePoint list. This works well but without the Form's name, it is impossible to tell exactly which quiz was taken and which ones are not yet completed.

Thanks!

[v-yuazh-msft]

Hi @ PhilD,

Do you want to get the Form's name when a response is submitted in forms?

Getting the Form's name when a response is submitted in forms is not supported in microsoft flow Forms connector currently,

I afraid that there is no way to achieve your needs in Microsoft Flow currently.

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,
Alice Zhang

[PhilD]

Thanks @v-yuazh-msft

Yes, I was hoping to get the Form's name which seems like a reasonable piece of business information to wish to communicate.

Managers want to see a list of employees who have completed the mandatory quizzes. It is far too cumbersome to expect them to go into each Form's 'results' page and drill into a question to view the list of who responded (or download a spreadsheet for each one) so I set up a central SP list to record submissions. In this case, the list of respondents is more important than the actual scores/answers (to demonstrate compliance).  I planned to group the list by the Form name and the respondent's department but without the Form name, the entire process will not work. I now have yet another Office 365 'solution'  that is pretty but cannot easily address the most basic and simple needs of a business unit - a list of things grouped by name.

I guess I'm stuck setting up separate lists for each Form which makes me wish I had just used a SharePoint list to begin with (which is what had been in use on prem and worked for years).

Thanks for your reply, much appreciated.

[zoidberg]

Wow, I have the exact Scenario and the exact problem as Phil ! I have to track multiple forms in the same sheet for tracking employees' quiz completions, which also needs to be shown in a PowerBI report. We can't have a management report which shows GUIDs instead of the name of the quiz!

Really disappointed that basic and obvious features like this are not supported, and even worse is that no workaround was suggested either. This page even refers to a "Form Title" field, so I don't know where that is.

https://docs.microsoft.com/en-us/connectors/microsoftforms/#get-response-details

So we have APIs to get the Form respondent's user name, his manager's name, his photo, his birthday etc., but it is impossible to get the name of the Form he filled out !?

[sararicketts]

I have the same requirement - I have multiple forms with different questions.   I want to pull it all into Power BI and the Form ID is critical to this