Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Salesforce cases using spo lists

(0) ShareShare
ReportReport
Posted on by 89

Hi all, 

 

 

I am using this connector https://us.flow.microsoft.com/en-us/galleries/public/templates/4844ba12dc784771860e8ebffbaa743b/create-a-record-in-salesforce-when-an-item-is-created-in-a-sharepoint-list but when selecting what items I want, I always get an error "The request body must have a valid JSON format." or "A value must be provided for item." 

Not sure what I am missing. The list items show up properly but now sure the correct ones to use to ensure the connection works. 

 

 

Dina_0-1611611001848.png

Dina_1-1611611077589.png

 

 

  • Verified answer
    Kcronic1 Profile Picture
    on at
    Re: Salesforce cases using spo lists

    Hello  @Dina ,  

      

    I looked at the screenshots you provided, and it appears that your flow is failing at the “Create A Record” action.  Without being able to see what you entered for the required parameters it’s hard to identify why you are receiving the JSON Format error. 

     

    One reason you may be experiencing the JSON Format error is that one of the required parameters doesn’t have a value.  

     

    Here’s a link(Salesforce - Connectors | Microsoft Docs ) that might help you in determining what the required parameters are and how to configure them in the “Create A Record” action.  

     

    Regards,  

    Kristie Cronic  

    Community Support Team  

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

    If you would like to create a ticket with Microsoft Customer Support here is a link on how to do so: Get Help + Support - Power Platform | Microsoft Docs  

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,702 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,015 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow