web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Extract forms multiple choice responses into columns in Excel

(0) ShareShare
ReportReport
Posted on by 2

My employees currently sign up for overtime by responding via email with the dates they want to sign up for.

I would like to automate this procedure by creating a monthly sign up sheet via Forms, within a Teams Channel, with all available dates using multiple choices. It would be one question with all the dates as multiple choices.

I have an excel spreadsheet with the dates in separate columns. I want the excel sheet to display the users name under each date selected. 

For example: if I selected 1/2 and 1/10, my name would populate in excel under the column named 1/2 and in the column named 1/10.

is this possible?

Also is there a way to simplify updating this on a monthly basis for someone who isn’t that savvy with power automate?

I have the same question (0)
  • Suggested answer
    Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Extract forms multiple choice responses into columns in Excel
     
    So an option would be to use adaptive cards instead of MS Forms , as there is no possibility in MS Forms to display dates for each dynamically so user can select which days they have did overtime.
     
     
    Try using adaptive cards with power automate - that would be best 
     
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

  • Suggested answer
    Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on at
    Extract forms multiple choice responses into columns in Excel
     
     
    Refer this as well 
     
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 647 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 350 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard