Showing results for 
Search instead for 
Did you mean: 
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

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?
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.

Frequent Visitor

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

Helpful resources

MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,564)