How to pull Microsoft form Responses to Datatable in Uipath?

Hi Everyone,
Kindly let me know is there any scope to pull Microsoft form output responses to Uipath data table as of now.
One method is to export form response as excel file to local machine and read the excel as DT. In my case i need to avoid the front end interactions to download response excel file, I am looking for any backend possibilities like Api call/Activities from Uipath studio it self.
Kindly share your thoughts :slight_smile:
Thanks

1 Like

Hey @ramees.pk,

Check this docs once,

It has the ability to pull each response from the form by id.

But you may check is there any chance to pass wildcard and fetch all the responses.

Thanks :slight_smile:

1 Like

@Nithinkrishna thanks for response,
How can we integrate this connectors to Uipath studio?
I think this connectors can be use in power automate/Flow .Please advice how to use this connectors in studio.
Thanks

1 Like

Hey @ramees.pk,

Yep, you are right.

That link is just to get some idea.

You may check for any API source to access the Excel(basically one drive api may be) which has form data.

Thanks :slight_smile:

1 Like