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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow Designer not allo...
Power Automate
Unanswered

Flow Designer not allowing JSON input for the {Body} field of an Update Items (SharePoint list) step

(1) ShareShare
ReportReport
Posted on by 358

I am building a flow with an UpdateItem step and want to use a variable as the SiteAddress - this is so we can easily transfer flows between different environments such as DEV > TEST > Pre-Live > Live just by querying the Environment information

 

We have done this inn the past with no issues - here is an example: from a flow we did a couple of years ago, and works in live every day:

livingstonep_0-1720109416032.png

As you can see, the Designer has allowed us to enter the JSON data

But in the flow I am building today, when I try to set the field values (using the hardcoded address) then change it to the variable this is what Power Automate is showing me in the Designer:

livingstonep_1-1720109562541.png

 

So is it me?

Or has Microsoft changed something?

Is there a workaround to be able to enter the JSON Body in the Body field of the step?

thanks

 

.

Categories:
  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    Hi @livingstonep 

     

    Firstly, no i don't see that it allowed you to put in JSON, all I see is a pink bubble, please share the Expression, which would be the JSON.

     

    As for the second screenshot, I don't understand whats wrong. You haven't populated the item and its required, so thats the error, not the Site.


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • livingstonep Profile Picture
    358 on at

    you can see in this image that we are able to use a variable as the SharePoint Site Address:

    Please also note that there is a BODY field, and NO ITEM field:

    livingstonep_1-1720170355372.png

    here is the JSON in the Body field:

     

    {
     "Title": @{triggerBody()?['Title']},
     "ImplementationDateTime": @{triggerBody()?['ImplementationDateTime']},
     "CABImplementor": @{triggerBody()?['CABImplementor']},
     "ServiceType": @{triggerBody()?['ServiceType']},
     "RollbackDateTime": @{triggerBody()?['RollbackDateTime']},
     "ImplementationComplete": @{triggerBody()?['ImplementationComplete']},
     "CABNumber": @{triggerBody()?['ID']},
     "CABStatus": {
     "Value": @{triggerBody()?['CABStatus']?['Value']}
     },
     "CABOwner": {
     "Claims": @{triggerBody()?['CABOwner']?['Claims']}
     },
     "SubmittedBy": {
     "Claims": @{triggerBody()?['SubmittedBy']?['Claims']}
     },
     "CABType": {
     "Value": @{triggerBody()?['CABType']?['Value']}
     },
     "TestingSignedOffBy": @{triggerBody()?['TestingSignedOffBy']},
     "BusinessApprovals": @{triggerBody()?['BusinessApprovals']},
     "CABImplementingTeam": {
     "Value": @{triggerBody()?['CABImplementingTeam']?['Value']}
     },
     "ServiceImpact": @{triggerBody()?['ServiceImpact']},
     "CABLocation": {
     "Value": @{triggerBody()?['CABLocation']?['Value']}
     },
     "ImpactCategory": {
     "Value": @{triggerBody()?['ImpactCategory']?['Value']}
     },
     "BusinessRisk": {
     "Value": @{triggerBody()?['BusinessRisk']?['Value']}
     },
     "CherwellTicket": @{triggerBody()?['CherwellTicket']},
     "ReasonForChange": @{triggerBody()?['ReasonForChange']},
     "TechnicalDetail": @{triggerBody()?['TechnicalDetail']},
     "PrechangeTesting": @{triggerBody()?['PrechangeTesting']},
     "PostChangeTesting": @{triggerBody()?['PostChangeTesting']},
     "SuccessCriteria": @{triggerBody()?['SuccessCriteria']},
     "RollbackPlan": @{triggerBody()?['RollbackPlan']},
     "CommunicationPlan": "comm@{triggerBody()?['CommunicationPlan']}",
     "CABRisk": @{triggerBody()?['CABRisk']},
     "PCIImpact": @{triggerBody()?['PCIImpact']},
     "ImpactToSecurity": @{triggerBody()?['ImpactToSecurity']},
     "ThirdPartyDataSharing": @{triggerBody()?['ThirdPartyDataSharing']},
     "ActiveDirectoryIntegration": @{triggerBody()?['ActiveDirectoryIntegration']},
     "ImpactDisasterRecovery": @{triggerBody()?['ImpactDisasterRecovery']},
     "ImpactOtherDocumentation": @{triggerBody()?['ImpactOtherDocumentation']},
     "SendNotificationEmail": @{true},
     "DPIACompleted": {
     "Value": @{triggerBody()?['DPIACompleted']?['Value']}
     },
     "DPIAApproved": {
     "Value": @{triggerBody()?['DPIAApproved']?['Value']}
     },
     "SARBApproval": {
     "Value": @{triggerBody()?['SARBApproval']?['Value']}
     },
     "NotificationSent": @{true}
    }

     

     

    That is all working fine, no problems in over 3 years of live use.

     

    But in my new flow, I want to do the same, use a variable for the Site Address:

    Unfortunately, as you can see below, it is not offering the Body field - only an Item:

    livingstonep_2-1720170809750.png

    and that is my problem

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 430

#2
11manish Profile Picture

11manish 341 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 282

Last 30 days Overall leaderboard