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
Hi @Luke15
Please take a try use the expression:
body('Get_mail_tips_for_a_mailbox_(V2)')['value'][0]['automaticReplies']?['scheduledEndTime']?['dateTime']
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2