web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / The response is not in...
Power Automate
Unanswered

The response is not in JSON format

(0) ShareShare
ReportReport
Posted on by 82

Hello,

 

I have a flow which main purpose is to move emails from different folders of Shared Mailbox to one. I am doing this activity through "Move email (V2)" which is taking its "Message id" from excel. 

In some cases the flow is working fine, in other occassions it shows error "The response is not in JSON format". When I was comparing succesful transaction and failed one I noticed that in the failed one in "Message id" I have "/" in the end.

Flow.jpg

Message ID.jpg

Any suggestions?

Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    on at

    Hi @dvoinikat,

     

    Could you please confirm if the message ID of the Email valid?

    My messages ID all end with "AAAA==", and there is no character "/":

    Screenshot 2021-02-12 111559.jpg

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dvoinikat Profile Picture
    82 on at

    I assume those are valid since I have them through Excel Power Query which was connected to Exchange in order to get all emails of the shared mailbox. It will surprise me, if in the same excel spreadsheet some IDs are valid, and some others are not. 
    In the example of yours - I need to move 58 k emails and when I observe large sample of data, I identify IDs with "/", others with "+", and still others with no delimiter. 

    Does this answer your question?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard