Auto Populate Excel To Outlook then to MS Forms

(0) Share

Report

Posted on by CU11091342-0

Hi all

I am hoping someone can give some advice on whether this is possible

I have an Excel spreadsheet on share point when a User Clicks a Cell in A column message box appears saying do you wish to continue "YES" or "NO"
User clicks YES then that opens Outlook Template then Populates field entries from that particular row and adds date into the “Date order form sent”

Email then sent
when recipient receives Email they click Link in yellow, Company REF and Site Location updates automatically from Email field

I know they may seem complicated and might not even be possible :/

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Could you tell me how this process is connected with power automate ?

Was this reply helpful? Yes No
RobElliott 10,323 Super User 2025 Season 2 on at

Like (0)

Report

The Forms aspect of your request is not possible as it is not possible to pre-populate data in Forms or for Forms to look up any data.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No
Suggested answer

David_MA 12,980 Super User 2025 Season 2 on at

Like (0)

Report
This is how you can accomplish pre-populating a MS Forms response:

Open you MS Form in design mode.

In the menu bar to the right of Style > Settings > Preview click on the three dots and choose Get prefilled URL.

At the top of the form, enable pre-filled answers.

Populate the fields you want with the prefilled data and be sure to use different answers and remember what you put for each of your questions.

Scroll to the bottom of the form and click on get prefilled link.

Paste the URL into notepad or something.

It will look like this: https://forms.office.com/Pages/ResponsePage.aspx?id=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx&r9251ceba05194c7f88522399a853c494=12&r97434f401f49487caa16e6693c569d18=2

Note: I replaced my form ID with Xs.

The yellow highlighted text is the GUID of the question, and the green highlighted text is the answer you provided. Now you see why I said to remember the answers you provide. :-)

For the link in your e-mail, use this link but replace the green values with the values needed for the particular response.

I am not sure about the Excel portion of your question. Happy Groundhog Day!

Was this reply helpful? Yes No