Answered

Update Sharepoint News Post Text via Power Automate

(2) Share

Report

Posted on by IO-09070904-0

I'm trying to create a method of creating Sharepoint News Articles via a Sharepoint list and Power Automate.

I've followed a few online tutorials, most recentlt this one: How to add text to any part of a SharePoint Page using Power Automate (aka. Microsoft Flow) - Collab365

It all works until the stage to write the updates into the news article.

If I post the code from the payload into the "SavePageAsDraft" step the flow saves.
As soon as I add Dynamic Content into the payload (ie. the sharepoint list columns to replace my placeholders" it errors with "The input parameter(s) of operation 'Send HTTP to Sharepoint - Save Draft' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Send HTTP to Sharepoint - Save Draft'."

Send HTTP to Sharepoint - Save Draft is the name of my flow step.

Any ideas why this would keep erroring or how to troubleshoot because the Power Automate error message isn;t too helpful!!

TIA

Ian

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Haque 3,217 on at

Like (0)

Report
Copy link

Link copied!
Hi @IO-09070904-0,

This is probably because the JSON payload is not properly formatted when mixing static text and dynamic expressions, you are seeing the error “Send HTTP to SharePoint - Save Draft”.

Use a Compose or Variable to Build the JSON Payload - Instead of inserting dynamic content directly inside the HTTP action’s body, first build the entire JSON payload as a string in a Compose action or a String variable.

Suppose you want to replace placeholders with SharePoint list column values dynamically. Use the following expression:

concat( '{ "field1": "', triggerOutputs()?['body/Column1'], '", ', '"field2": "', triggerOutputs()?['body/Column2'], '" }' )

Note: In the HTTP action’s body, use the output of the Compose action by selecting it from dynamic content. This ensures the payload is a valid JSON string.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
IO-09070904-0 10 on at

Like (0)

Report
Copy link

Link copied!
Thanks - I setup a variable as a string called "PageCode" and populated the page code.

Then setup a second empty string variable called "PageCodeNew"

Finally I created a step to set the "PageCodeNew" variable with a nested replace function to find my placeholders (identified with {{}}) and update these with the sharepoint list columns...

replace( replace( replace( replace(variables('pagecode'), '{{AUTHOR}}', triggerBody()?['Author/DisplayName'] ), '{{SUMMARY}}', outputs('Summery_Linebreaks') ), '{{HEADER}}', triggerBody()?['Title'] ), '{{ARTICLE}}', outputs('FullArticle_Linebreaks') )

The last step is as HTTP to Sharepoint POST with the "body" being the PageCodeNew variable.

Only bit to sort tomorrow is that one of the Placeholders is a date field, so it won;t work in the String Variable.

Was this reply helpful? Yes No