Hey Everyone,
Since Typeform change their API in August 2018, it broke the original flow connector (which worked great!) The new connector does not work and the way it tries to work makes it impossible to put the data into a sharepoint list.
I have a HTTP request POST trigger, for my typeform.
This theoretically should get all of the payload and the questions and answered. I need to be able to line up the question answers to sharepoint columns, but I cannot get Dynamic content to show, so I can then use it later in the flow to put the answers into Sharepoint.
PLEASE help. I have lost a lot of time since this broke and we were at 99% completion and ready to start using it before it all died.
Image of the flow
As you can see below, we get both the fields and the answered through in the payload. But I cannot use any of the fields to put a response anywhere.
Start of the fields section that the http request receives in the payload
[ { "id": "gJe60XtlWQx2", "title": "Please provide us with some initial information", "type": "group", "ref": "36ff7039-2e97-4c7c-8e02-6a2d0e8427d5", "properties": { "fields": [ { "id": "DMrtCHbnGlBC", "title": "First Name", "type": "short_text", "ref": "cb5e1057-df9a-4192-be5d-6194eb2705b1", "properties": {} }, { "id": "oYEVSNXVqTzn", "title": "Last Name", "type": "short_text", "ref": "1624ba3a-dca4-4373-a443-5614747048bf", "properties": {} }, { "id": "ETwgmd6ZbrQ4", "title": "Tax File Number", "type": "short_text", "ref": "eefc642a-3dbf-4c4e-ad4e-d83dac4a2429", "properties": {} } ] } }, { "id": "ZzS7zkohtkyP", "title": "Is this your first year with CATS?", "type": "yes_no", "ref": "c2aeb036-d3a6-4826-a51a-5c128759002f", "properties": {} }, { "id": "lijzrvsLns8y", "title": "Please provide the following details", "type": "group", "ref": "247abead-7bb4-4927-8212-1c906e19aadd", "properties": { "fields": [ { "id": "qASeXhO9rhIh", "title": "Email address", "type": "email", "ref": "29f08841-7b3c-4358-b34c-3467f360d406", "properties": {} }, { "id": "NWvozJt4emQx", "title": "Address", "type": "short_text", "ref": "a8b18411-dff7-4497-857e-b95fbe1d4569", "properties": {} }, { "id": "fUJ2yHvI6siw", "title": "Phone Number", "type": "number", "ref": "403ce190-4547-4244-8b4d-b18e56e071f4", "properties": {} }, { "id": "ByiEUfTAo2mf", "title": "Date of Birth", "type": "date", "ref": "3388a5c4-48e5-46f2-bbe9-2f81ac448c45", "properties": {} },
Some of the answeres response the HTTP request recieves
[ { "type": "boolean", "boolean": true, "field": { "id": "ZzS7zkohtkyP", "type": "yes_no" } }, { "type": "boolean", "boolean": true, "field": { "id": "KXrsHlkrd34Q", "type": "yes_no" } }, { "type": "choices", "choices": { "labels": [ "Barcelona" ] }, "field": { "id": "HT1cAtyMpuCf", "type": "picture_choice" } }, { "type": "file_url", "file_url": "https://admin.typeform.com/form/u5Edrc/field/SZUpv2IpyCs0/results/file.ext/download", "field": { "id": "SZUpv2IpyCs0", "type": "file_upload" } }, { "type": "boolean", "boolean": true, "field": { "id": "akHOmEAaVtSo", "type": "yes_no" } }, { "type": "choices", "choices": { "labels": [ "Barcelona" ] }, "field": { "id": "GJO1g4GVuBWx", "type": "picture_choice" }
Hi @Leon-Inspired,
Do you want to submit Typeform responses into a SharePoint list?
May you consider using the trigger When a response is submitted in TypeForm?
It seems that we could select dynamic content from the trigger for corresponding column.
I have made a simple flow likes below.
Please take it for a reference.
Best regards,
Mabel
Thanks for the response, but this is the exact problem!
When using the typeform connector, the dynamic content changes with each response.
I.e. say I have a question that is in a question block and it is.
1a
1b
1c
1d
2
3
The new typeform connector will give the responses like this
1:1a
2: 1b
3:1c
4:1d
5:2
6:3
Say that in response to question 1b, we skip to question 2. based on the answer, the dynamic content will now be like this
1:1a
2:1b
(wont show up)1c
(wont show up)1d
3:2
4:3
So, first problem is, getting all the the questions to be able to link up to the relevant sharepoint column.
second problem is (i imagine) because the dynamic content name changes every time there is a sequence done different, or a question is modified, answer 2 in dynamic content, may be something completely different the next time it triggers, so then we will have wrong information all over the place or the dynamic content selected in the flow will not work or be incorrect.
Do you undertand what I mean?
This is why I am looking to use the webhook instead of the new typeform connector. Or are my assumptions in the dynamic content incorrect and it wont matter that the numbers change with each trigger?
Anyone have any ideas?
Ill do some more testing this week
@v-yamao-msft These issues have still not been fixed. Do you know if they're being actively worked on?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
26 | |
16 | |
16 | |
15 |
User | Count |
---|---|
145 | |
45 | |
44 | |
33 | |
30 |