Unanswered

Automatically Populate Data in Microsoft Forms using Unique ID from Excel

(0) Share

Report

Posted on by SantoshMMSI

I'm currently working on a project where I need to automatically populate data in a Microsoft Form based on a unique ID selected by the user. The data resides in an Excel sheet, and I want the form to fetch and display the corresponding row in Excel when the user selects a unique ID.

Specifically, I would like to know:

Is it possible to configure Microsoft Forms to automatically pull data from an Excel sheet based on a unique ID selected by the user?

If yes, what would be the recommended approach or steps to achieve this integration?

I've looked into Microsoft Power Automate, but I can't find any Flows and out of the box solution that able to accomplish my project. Any guidance, tips, workaround or examples would be greatly appreciated.

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Srini007 3,490 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SantoshMMSI

I really don't think that Forms can get the information from Excel, rather it can save the information to an excel

Check below for your reference

https://support.microsoft.com/en-gb/office/sign-in-to-microsoft-forms-620daa7a-3e03-4013-8f92-5cce86210ef6

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Cheers,

Srini
RobElliott 10,539 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

@SantoshMMSI just to emphasise the point made by @Srini007 as he sounded not 100% sure (althoiugh I bet he was) :). it is absolutely not possible to pre-populate data in a form in Microsoft Forms using Power Automate. And the api can't do it either.

Rob
Los Gallardos
Principal Consultant, SharePoint, Forms and Power Platform, WSP Global (and classic 1967 Morris Traveller driver)
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@SantoshMMSI

Could you please provide more details about your use case, including examples and screenshots?

Additionally, could you explain how users will select the unique ID during the process? Please include screenshots for clarity. I will then explore potential solutions using Power Automate Desktop if it seems feasible.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀