cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roisinc21
Frequent Visitor

Getting dynamic content from JSON output

I am using a HTTP get request to collect results from Formsite and want to use the responses to create items in SharePoint.

 

A sample of the json output is below.  "id" is the question e.g "Expiry date 1" and "value" is the answer.  I have upwards of 40 questions each with an individual id on the Json output.  I only need to map back about 10 answers to the SharePoint list

{
                    "id""98",
                    "position"87,
                    "value""15/06/2021"
                },
{
                    "id""97",
                    "position"85,
                    "value""09/01/2022"
                }
 
 
I have read quite a few posts but none that actually work for me thus far. Is anyone able to provide any assistance/quidance on a soulution for this?
2 REPLIES 2
nhance
Advocate II
Advocate II

Could you use a different form connector? There are quite a few that have connectors in Power Automate that handle forms that will make this easy.

 

https://www.connectorreview.com/#/t/Form

Roisinc21
Frequent Visitor

Unfortunately no, we pay a lot for Formsite and can't change

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,028)