Hi,
I am trying to update project level custom field which is of type text and other of type flag. I am using power automate send http request to SharePoint trigger. Help me to over come this issue. Below is the screenshot of the trigger that i am using.
Here is the Body of this:
"<?xml version="1.0" encoding="UTF-8"?>
<Request xmlns="http://schemas.microsoft.com/sharepoint/clientquery/2009" SchemaVersion="15.0.0.0" LibraryVersion="16.0.0.0" ApplicationName="Javascript Library">
<Actions>
<Method Id="14" Name="SetCustomFieldValue" ObjectPathId="12">
<Parameters>
<Parameter Type="String">Custom_internalName</Parameter>
<Parameter Type="String">@{items('Apply_to_each')['ProjectNotification']}</Parameter>
</Parameters>
</Method>
<ObjectPath Id="16" ObjectPathId="15" />
<Query Id="17" ObjectPathId="15">
<Query SelectAllProperties="true">
<Properties />
</Query>
</Query>
</Actions>
<ObjectPaths>
<Constructor Id="0" TypeId="{3a609e5f-e2a1-497c-87a2-e5e8a781c096}" />
<Constructor Id="2" TypeId="{f256f605-bb33-4d62-b206-72a06a765075}">
<Parameters>
<Parameter ObjectPathId="0" />
</Parameters>
</Constructor>
<Property Id="4" Name="Projects" ParentId="0" />
<Method Id="6" Name="GetByGuid" ParentId="4">
<Parameters>
<Parameter Type="String">@{items('Apply_to_each')['ProjectId']}</Parameter>
</Parameters>
</Method>
<Constructor Id="0" TypeId="{3a609e5f-e2a1-497c-87a2-e5e8a781c096}" />
</ObjectPaths>
</Request>
"
I could not get the above method to work for any custom fields...it only worked for like 3 standard fields
If you check out my link here, I spent some time working with Custom Fields to come up with a solution.
We're still running it 2x a day every day to update our custom fields.
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional