Hi
I've created a flow which updates an excel file by looking up each persons email address in mail tips and where an automated message is present it shows them as out of office - this works great as the automated message flag is separated out in the dynamic expressions
I want to expand on this by showing the date they are back - i can see " "scheduledEndTime": {
"dateTime": "2021-08-23T07" in the raw output but when i attempt to extract it using split or substing - flow tells me it isnt an array it's an object
please forgive me if this is rudimentary - i am self taught (well you tube taught!)
i tried parsing as a JSON, i tried html to text and getting nowhere!
Please help