Viva Engage Town Hall Question Collector

Overview

This flow makes town hall / AMA Q&A data-driven. Each time an attendee submits a question through a Microsoft Form, the flow captures it, also reads the linked Viva Engage community thread, de-duplicates questions, ranks the combined set by upvotes/reactions, posts a ranked summary to a Teams channel, and emails the presenter the ranked list. A Dataverse table is the durable question store so rankings accumulate across submissions.

Why it matters: The loudest voices shouldn't dominate Q&A. Aggregating questions from a Form and a Viva thread and ranking by reaction surfaces the questions people actually care about.

Status: Built as a demo — ships Off. Going live requires only (1) authorizing the five connection references and (2) setting the seven environment variable values. No placeholder/fixture data — every data fetch is a real connector action.

Use Case

Leadership running a quarterly town hall wants the top employee questions surfaced and ranked automatically, drawn from both a submission Form and an open Viva Engage community thread, without manual triage.

Flow Architecture

Environment Variables

Connectors & Connections

Connector	API name	Actions used
Microsoft Forms	shared_microsoftforms	CreateFormWebhook GetFormResponseById
Viva Engage	shared_yammer	GetMessagesInGroupV3
Microsoft Dataverse	shared_commondataserviceforapps	ListRecords CreateRecord UpdateRecord
Microsoft Teams

Customization Guide

Almost every realistic variant of this flow can be implemented by changing environment variable values. A few cases require small edits inside the flow definition — those are called out explicitly below.

Smarter clustering

Replace exact normalized-text matching with fuzzy matching or an Azure OpenAI grouping step to merge semantically similar questions.

Live re-ranking

The flow re-ranks and re-posts on every submission; add a debounce or switch to a scheduled digest if posting frequency is too high.

Anonymity

Form questions store the responder; map the submitter to Anonymous if you want fully anonymous Q&A.

Answer follow-up

After the event, post answers back to the Viva thread or mark rows with a Status of Answered.

Top-N

Change the $top on Get Ranked Questions to control how many questions appear in the summary.

Key Expressions

The flow is intentionally light on Power Fx / WDL gymnastics — the heaviest expressions are the branch-name concatenation and the approval outcome check. They are listed below in the order they appear in the flow.

@{coalesce(body('Get_Form_Response')?[parameters('EnvVar_FormQuestionFieldId')], 'No question text provided')}

@{toLower(trim(outputs('Compose_Form_Question')))}

@and(equals(coalesce(item()?['system_message'],false),false), contains(coalesce(item()?['content_excerpt'],''),'?'))

@add(coalesce(items('Foreach_Viva_Question')?['liked_by']?['count'],0),1)

Customize & download