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 / "is not in a JSON form...
Power Automate
Unanswered

"is not in a JSON format" in power automate

(0) ShareShare
ReportReport
Posted on by 89

My flow was working for 2 months and now it's not..

I am basically grabbing items from a SPO list to then delete on the other SPO lists. 

Dina_0-1646421357135.png

Dina_1-1646421364615.png

 

Error Action 'Get_items_Cancel_Delete_List' failed

 

Any help would be greatly appreciated. 

 

Thanks

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    @Dina ,

    Could you please take a try to update the connection or add a new connection for the List rows present in a table action in your flow?

    "Unauthorized" error could usually be fixed by updating the connection.

  • Community Power Platform Member Profile Picture
    on at

    I will update my response, sorry I thought you were working with excel. Are you an admin on the SharePoint site?

  • Dina Profile Picture
    89 on at

    I am the site owner not admin. I’ve updated connections, removed lists and added them back .. still nothing!

  • Dina Profile Picture
    89 on at

    @Anonymous any other options? Thanks for the help! 

  • Community Power Platform Member Profile Picture
    on at

    @Dina ,

     

    All the things you've done make sense to me. One last thing I would try in this case might be creating a new flow from scratch and creating this Sharepoint action on the new flow. Sometimes weird things happen in power automate to me. If it magically works you can simply copy the rest of your flow to the new flow

  • Community Power Platform Member Profile Picture
    on at

     

    hi @Dina ,

     

    I had the same case for sharepoint, I managed to solve it by changing to "JSON format" (absurd) but that's how it is.

     

    site 1 : /name/folder/content.xxx (get)
    site 2 : %252fname%252ffolder%252fcontent.xxx (delete)

     

    change / to %252f
    and space by %2b

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a 👍

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
David_MA Profile Picture

David_MA 223 Super User 2025 Season 2

#2
Expiscornovus Profile Picture

Expiscornovus 205 Most Valuable Professional

#3
harshdeol Profile Picture

harshdeol 167 Moderator

Last 30 days Overall leaderboard