Answered

MS Graph Calendarview to sharepoint list

(0) Share

Report

Posted on by Kayle

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.

Screenshot 2023-05-02 at 22.49.10.png

Screenshot 2023-05-02 at 22.52.31.png

Screenshot 2023-05-02 at 22.54.38.png

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:

Screenshot 2023-05-02 at 22.59.06.png

Could someone give me a hint what I need to check to get the values out of the parse json?

Thanks in advance

Kay

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kayle on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Kayle on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,472 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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).

item()['Subject']

item()['Organizer']

Was this reply helpful? Yes No
Kayle on at

Like (1)

Report
Copy link

Link copied!

Thanks @Expiscornovus ,

it is working now 🙂

BR
Kay

Was this reply helpful? Yes No