{"id":1150,"date":"2026-02-07T01:10:13","date_gmt":"2026-02-07T01:10:13","guid":{"rendered":"https:\/\/www.techpolaju.com\/blog\/?p=1150"},"modified":"2026-02-07T01:22:25","modified_gmt":"2026-02-07T01:22:25","slug":"teams-quiz-bot-tutorial-2026","status":"publish","type":"post","link":"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/","title":{"rendered":"\ud83d\ude80 Ultimate Daily Teams Quiz Bot Tutorial 2026 (Excel Version &#8211; No Premium Connectors)"},"content":{"rendered":"\n<p>In this updated Daily Teams Quiz Bot Tutorial 2026, you\u2019ll learn how to build the same automated Microsoft Teams quiz bot \u2014 but using an Excel file instead of the OpenTDB API.<\/p>\n\n\n\n<p>This version is perfect if you want:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Full control over quiz questions \u270d\ufe0f<\/li>\n\n\n\n<li>No dependency on external APIs \ud83c\udf10<\/li>\n\n\n\n<li>No premium Power Automate connectors \ud83d\udcb0<\/li>\n\n\n\n<li>Easy editing by HR or non-technical users<\/li>\n<\/ul>\n\n\n\n<p>The quiz still runs automatically every morning at 8 AM, posts an interactive Adaptive Card to Microsoft Teams, and instantly tells users whether their answer is correct.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"784\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-5-1024x784.png\" alt=\"Teams Quiz Bot Tutorial 2026\" class=\"wp-image-1159\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-5-1024x784.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-5-300x230.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-5-768x588.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-5.png 1265w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%E2%9D%93_Why_Use_Excel_Instead_of_an_API\" >\u2753 Why Use Excel Instead of an API?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%94%A7_What_You_Need_Before_You_Begin\" >\ud83d\udd27 What You Need Before You Begin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%E2%9C%85_Step-by-Step_Guide_Daily_Teams_Quiz_Bot_Tutorial_2025\" >\u2705 Step-by-Step Guide: Daily Teams Quiz Bot Tutorial 2025<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%93%8A_Step_1_Prepare_the_Excel_Quiz_File\" >\ud83d\udcca Step 1: Prepare the Excel Quiz File<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#Excel_Table_Structure\" >Excel Table Structure<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%94%81_Step_2_Create_a_Scheduled_Flow_8%E2%80%AFAM_Daily\" >\ud83d\udd01 Step 2: Create a Scheduled Flow (8\u202fAM Daily)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%8C%90_Step_3_Read_Quiz_Questions_from_Excel\" >\ud83c\udf10 Step 3: Read Quiz Questions from Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%94%81_Step_3_Apply_to_Each_Loop_Through_Questions\" >\ud83d\udd01 Step 3: Apply to Each (Loop Through Questions)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%A7%A9_Step_4_Compose_%E2%80%93_Answers\" >\ud83e\udde9 Step 4: Compose &#8211; Answers<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%92%AC_Step_5_Post_Adaptive_Card_to_Teams\" >\ud83d\udcac Step 5: Post Adaptive Card to Teams<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%E2%9D%93_Step_6_Condition_%E2%80%93_Check_Users_Answer\" >\u2753 Step 6: Condition &#8211; Check User\u2019s Answer<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%8F%86_Step_7_IF_TRUE_%E2%80%93_Update_Adaptive_Card_Correct_Answer\" >\ud83c\udfc6 Step 7: IF TRUE &#8211; Update Adaptive Card (Correct Answer)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%E2%9D%8C_Step_8_IF_FALSE_%E2%80%93_Update_Adaptive_Card_Incorrect_Answer\" >\u274c Step 8: IF FALSE &#8211; Update Adaptive Card (Incorrect Answer)<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%E2%9C%85_Final_Thoughts\" >\u2705 Final Thoughts<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/#%F0%9F%92%A1_Bonus_Resources\" >\ud83d\udca1 Bonus Resources<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9D%93_Why_Use_Excel_Instead_of_an_API\"><\/span>\u2753 Why Use Excel Instead of an API?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>While APIs like OpenTDB are powerful, Excel offers some big advantages:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Questions can be updated anytime without touching the flow<\/li>\n\n\n\n<li>Non-technical users can manage content<\/li>\n\n\n\n<li>Answers and winners can be stored in the same file<\/li>\n\n\n\n<li>Uses standard Power Automate connectors only<\/li>\n<\/ul>\n\n\n\n<p>This makes Excel ideal for internal quizzes, onboarding, training, or company culture initiatives.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%A7_What_You_Need_Before_You_Begin\"><\/span>\ud83d\udd27 What You Need Before You Begin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To follow this Daily Teams Quiz Bot Tutorial 2026, make sure you have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Microsoft 365 account<\/li>\n\n\n\n<li>Microsoft Teams access<\/li>\n\n\n\n<li>Power Automate access<\/li>\n\n\n\n<li>Excel file stored in OneDrive or SharePoint<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9C%85_Step-by-Step_Guide_Daily_Teams_Quiz_Bot_Tutorial_2025\"><\/span>\u2705 Step-by-Step Guide: Daily Teams Quiz Bot Tutorial 2025<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%8A_Step_1_Prepare_the_Excel_Quiz_File\"><\/span>\ud83d\udcca Step 1: Prepare the Excel Quiz File<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Create an Excel file and store it in OneDrive or SharePoint.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Excel_Table_Structure\"><\/span>Excel Table Structure<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Convert your data into a <strong>Table<\/strong> and name it <code><strong>QuizTable<\/strong><\/code>.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Question<\/th><th>Option1<\/th><th>Option2<\/th><th>Option3<\/th><th>Option4<\/th><th>CorrectAnswer<\/th><\/tr><\/thead><tbody><tr><td>Capital of France?<\/td><td>Paris<\/td><td>Rome<\/td><td>Berlin<\/td><td>Madrid<\/td><td>Paris<\/td><\/tr><tr><td>Capital of China?<\/td><td>Madrid<\/td><td>Beijing<\/td><td>Helsinki<\/td><td>Islamabad<\/td><td>Beijing<\/td><\/tr><tr><td>Capital of Finland?<\/td><td>Helsinki<\/td><td>Riyadh<\/td><td>Berlin<\/td><td>London<\/td><td>Helsinki<\/td><\/tr><tr><td>Capital of Norway?<\/td><td>Berlin<\/td><td>Oslo<\/td><td>London<\/td><td>Rome<\/td><td>Oslo<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Important notes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>All options must be filled<\/li>\n\n\n\n<li>Correct Answer must exactly match one of the options<\/li>\n\n\n\n<li>Table format is mandatory<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%81_Step_2_Create_a_Scheduled_Flow_8%E2%80%AFAM_Daily\"><\/span>\ud83d\udd01 Step 2: Create a Scheduled Flow (8\u202fAM Daily)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Go to <a class=\"\" href=\"https:\/\/make.powerautomate.com\" target=\"_blank\" rel=\"noopener\">make.powerautomate.com<\/a><\/li>\n\n\n\n<li>Select Create > Scheduled Cloud Flow<\/li>\n\n\n\n<li>Name the flow: <code>Daily Teams Quiz Bot - Excel<\/code><\/li>\n\n\n\n<li>Set the schedule to every day at 8:00\u202fAM<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"584\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-35-1024x584.png\" alt=\"power automate recurrence trigger\" class=\"wp-image-572\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-35-1024x584.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-35-300x171.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-35-768x438.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2025\/07\/image-35.png 1184w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udfe2 This trigger starts your daily quiz flow automatically each morning.<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8C%90_Step_3_Read_Quiz_Questions_from_Excel\"><\/span>\ud83c\udf10 Step 3: Read Quiz Questions from Excel<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add <strong>List rows present in a table<\/strong> action.<\/p>\n\n\n\n<p>Configuration:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Location: OneDrive or SharePoint<\/li>\n\n\n\n<li>Document Library: OneDrive<\/li>\n\n\n\n<li>File: Your Excel quiz file<\/li>\n\n\n\n<li>Table: QuizTable<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"545\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-3-1024x545.png\" alt=\"\" class=\"wp-image-1154\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-3-1024x545.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-3-300x160.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-3-768x409.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-3.png 1110w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>This action fetches all quiz questions from Excel.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%94%81_Step_3_Apply_to_Each_Loop_Through_Questions\"><\/span>\ud83d\udd01 Step 3: Apply to Each (Loop Through Questions)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add &#8220;Apply to each&#8221; action.<\/p>\n\n\n\n<p>Select an output from previous steps: Copy and paste the following expression, or select &#8220;body\/value&#8221; from the dynamic list.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>@{outputs('List_rows_present_in_a_table')?&#91;'body\/value']}<\/code><\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"241\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-4-1024x241.png\" alt=\"\" class=\"wp-image-1156\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-4-1024x241.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-4-300x71.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-4-768x181.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-4.png 1426w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>Each iteration represents one quiz question.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%A7%A9_Step_4_Compose_%E2%80%93_Answers\"><\/span>\ud83e\udde9 Step 4: Compose &#8211; Answers<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Inside &#8220;Apply to each&#8221; action, add &#8220;Compose&#8221; action and rename it to &#8220;Compose Answers&#8221;.<\/p>\n\n\n\n<p>Inputs: Copy and paste the following JSON. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><code>&#91;\n{\n\"title\": \"@{items('Apply_to_each')?&#91;'Option1']}\",\n\"value\": \"@{items('Apply_to_each')?&#91;'Option1']}\"\n},\n{\n\"title\": \"@{items('Apply_to_each')?&#91;'Option2']}\",\n\"value\": \"@{items('Apply_to_each')?&#91;'Option2']}\"\n},\n{\n\"title\": \"@{items('Apply_to_each')?&#91;'Option3']}\",\n\"value\": \"@{items('Apply_to_each')?&#91;'Option3']}\"\n},\n{\n\"title\": \"@{items('Apply_to_each')?&#91;'Option4']}\",\n\"value\": \"@{items('Apply_to_each')?&#91;'Option4']}\"\n}\n]<\/code><\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"992\" height=\"718\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-6.png\" alt=\"\" class=\"wp-image-1160\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-6.png 992w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-6-300x217.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-6-768x556.png 768w\" sizes=\"auto, (max-width: 992px) 100vw, 992px\" \/><\/figure><\/div>\n\n\n<p>This dynamically builds answer choices from Excel.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%92%AC_Step_5_Post_Adaptive_Card_to_Teams\"><\/span>\ud83d\udcac Step 5: Post Adaptive Card to Teams<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add &#8220;Post adaptive card and wait for a response&#8221; inside the loop.<\/p>\n\n\n\n<p>Configuration:<br>Post as: Flow bot<br>Post in: Channel<br>Message:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n\"type\": \"AdaptiveCard\",\n\"body\": &#91;\n{\n\"type\": \"TextBlock\",\n\"text\": \"Question: @{items('Apply_to_each')?&#91;'Question']}\",\n\"wrap\": true\n},\n{\n\"type\": \"Input.ChoiceSet\",\n\"id\": \"answer\",\n\"style\": \"expanded\",\n\"choices\": @{outputs('Compose_Answers')}\n}\n],\n\"actions\": &#91;\n{\n\"type\": \"Action.Submit\",\n\"title\": \"Submit\"\n}\n],\n\"$schema\": \"http:\/\/adaptivecards.io\/schemas\/adaptive-card.json\",\n\"version\": \"1.2\"\n}<\/code><\/pre>\n\n\n\n<p>Team: Select team from the dropdown<br>Channel: Select channel from the dropdown<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"1008\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-7-1024x1008.png\" alt=\"\" class=\"wp-image-1163\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-7-1024x1008.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-7-300x295.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-7-768x756.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-7.png 1182w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9D%93_Step_6_Condition_%E2%80%93_Check_Users_Answer\"><\/span>\u2753 Step 6: Condition &#8211; Check User\u2019s Answer<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Add a &#8220;Condition&#8221; action and set the following.<br>Left value<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@{body('Post_adaptive_card_and_wait_for_a_response')?&#91;'data\/answer']}<\/code><\/pre>\n\n\n\n<p>Operator<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>is equal to<\/code><\/pre>\n\n\n\n<p>Right value<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@{items('Apply_to_each')?&#91;'CorrectAnswer']}<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"321\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-8-1024x321.png\" alt=\"\" class=\"wp-image-1165\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-8-1024x321.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-8-300x94.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-8-768x241.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-8.png 1339w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%8F%86_Step_7_IF_TRUE_%E2%80%93_Update_Adaptive_Card_Correct_Answer\"><\/span>\ud83c\udfc6 Step 7: IF TRUE &#8211; Update Adaptive Card (Correct Answer)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>On the TRUE side of the condition, add the action \u201cUpdate an adaptive card in a chat or channel\u201d and copy the following JSON in the &#8220;Adaptive Card&#8221; field.<\/p>\n\n\n\n<p>Adaptive Card:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"type\": \"AdaptiveCard\",\n  \"body\": &#91;\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"\ud83c\udf89 This question has been answered correctly by @{body('Post_adaptive_card_and_wait_for_a_response')?&#91;'responder\/displayName']}!\",\n      \"wrap\": true\n    },\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"Question: @{items('Apply_to_each')?&#91;'Question']}\",\n      \"wrap\": true\n    },\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"Correct answer: @{body('Post_adaptive_card_and_wait_for_a_response')?&#91;'data\/answer']}\",\n      \"wrap\": true\n    }\n  ],\n  \"$schema\": \"http:\/\/adaptivecards.io\/schemas\/adaptive-card.json\",\n  \"version\": \"1.2\"\n}\n<\/code><\/pre>\n\n\n\n<p>For Message ID: copy the following expression if you cannot find it in the dynamic list<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>@{body('Post_adaptive_card_and_wait_for_a_response')&#91;'messageId']}<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"596\" src=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-9-1024x596.png\" alt=\"\" class=\"wp-image-1168\" srcset=\"https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-9-1024x596.png 1024w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-9-300x175.png 300w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-9-768x447.png 768w, https:\/\/www.techpolaju.com\/blog\/wp-content\/uploads\/2026\/02\/image-9.png 1386w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9D%8C_Step_8_IF_FALSE_%E2%80%93_Update_Adaptive_Card_Incorrect_Answer\"><\/span>\u274c Step 8: IF FALSE &#8211; Update Adaptive Card (Incorrect Answer)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>On the FALSE side of the condition, add another action \u201cUpdate an adaptive card in a chat or channel\u201d and copy the following JSON in the &#8220;Adaptive Card&#8221; field.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"type\": \"AdaptiveCard\",\n  \"body\": &#91;\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"\u274c @{body('Post_adaptive_card_and_wait_for_a_response')?&#91;'responder\/displayName']} answered this question incorrectly.\",\n      \"wrap\": true\n    },\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"Question: @{items('Apply_to_each')?&#91;'Question']}\",\n      \"wrap\": true\n    },\n    {\n      \"type\": \"TextBlock\",\n      \"text\": \"Answer: @{body('Post_adaptive_card_and_wait_for_a_response')?&#91;'data\/answer']}\",\n      \"wrap\": true\n    }\n  ],\n  \"$schema\": \"http:\/\/adaptivecards.io\/schemas\/adaptive-card.json\",\n  \"version\": \"1.2\"\n}<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E2%9C%85_Final_Thoughts\"><\/span>\u2705 Final Thoughts<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This Daily Teams Quiz Bot (Excel-based) is a simple, cost-effective way to run automated quizzes in Microsoft Teams using Power Automate and Adaptive Cards.<\/p>\n\n\n\n<p>By keeping questions in Excel, you get full control over content without premium connectors or complex setup. It\u2019s easy to maintain, scalable, and perfect for engagement, learning, or internal challenges.<\/p>\n\n\n\n<p>An Excel-driven quiz bot keeps your automation simple, flexible, and future-proof.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%F0%9F%92%A1_Bonus_Resources\"><\/span>\ud83d\udca1 Bonus Resources<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/auto-create-calendar-events\/\">\ud83d\udd04 10 Powerful Steps to Auto Create Calendar Events from SharePoint<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/extract-email-data\/\">\ud83d\udd04 Powerful Extract Email Data in Power Automate Tutorial for Effortless Automation<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/power-automate-approval-flow\/\">\ud83d\udd25 7 Powerful Steps to Build a Power Automate Approval flow for Reliable Document Review<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/file-conversion-and-sharing\/\">\ud83d\ude80 5-Step Effortless Tutorial for File Conversion and Sharing<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/contract-renewal-alert\/\">\ud83d\udcc5 Powerful Automated Contract Renewal Alert in 11 Steps<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this updated Daily Teams Quiz Bot Tutorial 2026, you\u2019ll learn how to build the same automated Microsoft Teams quiz bot \u2014 but using an Excel file instead of the OpenTDB API. This version is perfect if you want: The quiz still runs automatically every morning at 8 AM, posts an interactive Adaptive Card to &#8230; <a title=\"\ud83d\ude80 Ultimate Daily Teams Quiz Bot Tutorial 2026 (Excel Version &#8211; No Premium Connectors)\" class=\"read-more\" href=\"https:\/\/www.techpolaju.com\/blog\/power-automate\/teams-quiz-bot-tutorial-2026\/\" aria-label=\"Read more about \ud83d\ude80 Ultimate Daily Teams Quiz Bot Tutorial 2026 (Excel Version &#8211; No Premium Connectors)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1150","post","type-post","status-publish","format-standard","hentry","category-power-automate"],"_links":{"self":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/comments?post=1150"}],"version-history":[{"count":11,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1150\/revisions"}],"predecessor-version":[{"id":1171,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/posts\/1150\/revisions\/1171"}],"wp:attachment":[{"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/media?parent=1150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/categories?post=1150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techpolaju.com\/blog\/wp-json\/wp\/v2\/tags?post=1150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}