{"id":2273,"date":"2022-12-14T07:13:02","date_gmt":"2022-12-14T07:13:02","guid":{"rendered":"https:\/\/m365news.net\/?p=2273"},"modified":"2022-12-21T02:09:20","modified_gmt":"2022-12-21T02:09:20","slug":"microsoft-forms-get-all-answers","status":"publish","type":"post","link":"https:\/\/m365news.net\/microsoft-forms-get-all-answers\/","title":{"rendered":"Microsoft Forms &#8211; Get All Answers"},"content":{"rendered":"<p>In this video, instead of triggering a Flow every time a form has been submitted, we are going to send an HTTP request to the Forms API and receive all submitted answers at once. The HTTP request connector is the one we also use for SharePoint, so it&#8217;s free to use as a standard connector in Power Automate. The problem with this method is that the answers are received in one array. We are going to use a compose action to split the array at specific places so that we can extract the answers.<\/p>\n<p>This will be done inside an apply-to-each loop so that we can go through all responses. In the end, we have all answers from all responses in a structured and easy-to-use format. What you do with that data after this stage is up to you!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this video, instead of triggering a Flow every time a form has been submitted, we are going to send an HTTP request to the Forms API and receive all submitted answers at once. The HTTP request connector is the one we also use for SharePoint, so it&#8217;s free to use as a standard connector<\/p>\n","protected":false},"author":5,"featured_media":2309,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[226,149],"tags":[300,155,295,296,299,289,227,294,154,301,298,302,279,297,303],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2273"}],"collection":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/comments?post=2273"}],"version-history":[{"count":4,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2273\/revisions"}],"predecessor-version":[{"id":2308,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/posts\/2273\/revisions\/2308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/media\/2309"}],"wp:attachment":[{"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/media?parent=2273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/categories?post=2273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/m365news.net\/wp-json\/wp\/v2\/tags?post=2273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}