Parsing JSON from DataTable to Sharepoint (Beginner)

Forms
1

Hi, I'm making simple Forms to capture data from DataTable to Sharepoint List, trying to understand the guide from this link (https://plumsail.com/docs/forms-web/how-to/excel-datatable.html) but seems missing step by step guidance on how to do Parsing JSON and map it to each row on Flow/PowerAutomate.

I have no experience on JSON/JS coding, thus please bear with me with questions.

Here's my Form for your reference:

image

And here's my Sharepoint List:

image
image.png1104×101 1.66 KB

All I need is to make sure all data can be mapped properly on Sharepoint, similar like this guide
https://plumsail.com/docs/forms-web/how-to/data-table-to-sp.html, but with only single table for all detail.

Thanks,
Adit

2

I think I understand what you're trying to do. There is a component in Power Automate called "Parse Json". When you feed it a schema, it gives you the outputs that you can use to populate the SharePoint list.

Create a parse json component

image
image.png672×653 24.3 KB

Use the data somewhere.

image
image.png1050×586 44.5 KB

3

Hello!

@Kurtnelle, thank you for helping! You are right!

@AdityaGiriHertanto,

Are you using SharePoint Forms?

If I understand you correctly, you want to create a new item in a SharePoint list with information from Data Table control. Is that right?

Do you know about List or Library control? With this control, you can create new list items, and there is no need to use flow for this.

Please find more information about List or Library control here.

4

Thanks a lot @Kurtnelle, sorry was away after I tried this. This instantly works and I forgot to say thank you. :sweat_smile:

Hello @Margo, I'm using Public Forms to collect input from external users.