You’re offline. This is a read only version of the page.
Hello all,
I would like to get the calendar events from a meeting room and save them into a sharepoint list. I have a "REST call to Graph API" successfully running and I get an output. After the REST Call, I have a parse Json step. This is all working. Now, I would like to extract "subject" and "organizer" for each event in the json object/array and save this values into a sharepoint list.
I am struggling to get these values out of the object/array. I've tried to create a HTML table first. When I add Create HTML step I get an error:
Could someone give me a hint what I need to check to get the values out of the parse json?
Thanks in advance
Kay
Hi @Kayle,
You can use an item function for that and reference each field.
Try using the expressions below within the apply to each (in a create item for example).
Share
Report
All responses (
Answers (
item()['Subject']
item()['Organizer']
Hi @Expiscornovus ,
I am slowly approaching the result 🙂
After parsing the json, I am using now a Select Function to map the values I need. This is the output of my "SelectValues" step:
{
"body": [
{
"Subject": "Test1",
"Organizer": "Kay, Pohl"
},
{
"Subject": "Test2",
"Organizer": "Kay, Pohl"
}
]
}
Now, I am trying to create an item in a sharepoint list for each item in this array. I created an Apply to each step with "body('SelectValues") as input.
My Sharepoint list does have 2 columns. Subject and Organizer. I am able to create items in the sharepoint list, but I don't know which expression I need to use to get the Subject and Organizer value for the array. Could you please help me here again?
Thanks in advance
Kay
Hi @Kayle,
That is correct. You can add the same value field in the Apply to each. Within the apply to each you can use a create item action.
Hi @Expiscornovus ,
thanks for your help. It is working when I use body('Parse_JSON')?['value'].
The HTML Table should be just a debug information. When I now want to write the values to a sharepoint list, I need to use a "Apply to each" step, right? And for the Organizer Name, I need to use something like "item" because this is nested?
BR
Kay
Hi @Kayle,
What field are you using in the From field of the Create HTML table? You should be able to use the value field in the From, that is an array.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
