topic Re: Auto Fill Microsoft Form from HS in APIs & Integrations

Auto Fill Microsoft Form from HS

SMCNULTY — Fri, 10 May 2024 13:21:40 GMT

Good Morning,

A customer of ours has recently required us to "verify their PO" via a Office form. It's public and it located here:

Which leads here:

https://forms.office.com/pages/responsepage.aspx?id=ZCy4K7Eu90OIYv3B0jM7UE7lIih03qNPkkd-nLrAmy9UNVhQMEU4NTBXOFlBU0ZGN082TDkyOTZCSy4u

It's pretty annoying, just extra work for us. Is there any way to push property values from a HS ticket over to this browser based form? The group that made this form has near zero technical knowledge so when I asked about access to their back end to automate, they had no idea.

I've done API calls within Excel and pushed/pulled data from Hubspot, but nothing with pushing data out to a form presented in a browser.

Any help would be appreciated.

Re: Auto Fill Microsoft Form from HS

SMCNULTY — Fri, 10 May 2024 15:20:17 GMT

I will add nuggets here as I make progress. I was at least able to figure out how to inject a value in a office form via javas script. For this form, the first field (1. PO Number*) I put in "54321" via this bit of code within Chrome Console:

document.querySelector('input[aria-labelledby="QuestionId_r75c22d61242c494bb7b62b51cbf541c9 QuestionInfo_r75c22d61242c494bb7b62b51cbf541c9"]' ).value='54321'

Re: Auto Fill Microsoft Form from HS

SMCNULTY — Fri, 10 May 2024 16:22:35 GMT

I was also able to fill the form in via Microsoft Power Automate so I assume between Javascript and/or powerautomate I should be able to finagle something into working here

Re: Auto Fill Microsoft Form from HS

SteveHTM — Fri, 10 May 2024 21:17:51 GMT

@SMCNULTY - sounds like you are working to figure this all out through you own experiments!

I was going to suggest ealier that you combine two techniques to resolve this challenge:

- adding a query partameter to your URL redirection to this form that includes the PO number you need to submit

- Using JS to uncover the DOM model object for the necessary input field on the form and filling that object from the value in the query string.

Its all rather fiddly work - but probab;y the only way to address the challenge you have been set.

Good luck!

Steve