Microsoft flows / automate issues | Community
Skip to main content
Answered

Microsoft flows / automate issues

E

I am trying to use Microsoft’s Flows to bring data from my type forms into a SharePoint Excel document using the TypeForm Flow template.

The TypeForm Flow connector has issues passing the data through to the next step in a MS Flow.

Reviewing the raw inputs the data is arriving and formatted correctly but it only allows Submitted & Sent data to be populated to the excel spreadsheet.

Several attempts with different TypeForms result generally only 2 to 5 fields populating.

Note: I am using webhooks and MS flows as I am not able to authorise the Excel connection due to rights on our corporate O365 account.

How can I get the full data to appear in the MS Flows?

 

Best answer by Liz

Hi @ePayroll got it - thanks! Hm, it’s strange that even the real data isn’t working. I sadly don’t have too much more direction I can give with Microsoft Flow since the integration was built by their team, but have you reached out to their support team yet to see if they can help/give some further direction?

View original

4 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14919 replies
  • May 11, 2021

Hi @ePayroll Thanks for stopping by! :grinning: While I’m not terribly familiar with connecting to Microsoft Flow this way, from the screenshot it looks like the data might be from a test webhook. I’d suggest submitting a response on the form directly to pull in real data, which may help. I’ve noticed this helps with some other platforms such as Zapier, so it might be the case here, too!

Life is a series of awkward moments separated by snacks.
E
  • ePayroll
  • Author
  • Explorer
  • 1 reply
  • May 12, 2021

Thanks @Liz, yes my screen shot is of test data sent via the webhook test. (Used for privacy in screenshot) However it occurs with live data, it is occurring across multiple forms and different forms appear to drop the available fields at different points. Some I only get Submitted and Sent but on average I’ll get the first 3-6 fields. When I started I was able to get 10 fields but this form then reduced about a week into running down to 5 fields.

I have re-setup the flows, used new forms, used new excel sheets.

Only item I could find under google that is roughly similar is a comment that the TypeForm Flow app doesn’t transpose data types correctly and a work around is to use a raw JSON flow connector with code to transpose all the fields. 

My fields and content are simple text so I don’t expect this to be the cause.

john.desborough
1 person likes this
  • john.desborough
    john.desborough
Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14919 replies
  • Answer
  • May 12, 2021

Hi @ePayroll got it - thanks! Hm, it’s strange that even the real data isn’t working. I sadly don’t have too much more direction I can give with Microsoft Flow since the integration was built by their team, but have you reached out to their support team yet to see if they can help/give some further direction?

Life is a series of awkward moments separated by snacks.
john.desborough
E
2 people like this
  • john.desborough
    john.desborough
  • E
    ePayroll
Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 14919 replies
  • May 18, 2021

Hi @ePayroll Hope you’re holding up over there! Were you able to get ahold of Microsoft’s team? :grin:

Life is a series of awkward moments separated by snacks.

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs