Unanswered

json - format a sharepoint news post

(0) Share

Report

Posted on by Community Power Pla...

I'm hoping someone is able to assist me. I have created a communications form using a SharePoint list. Once the form is submitted I have it creating a SharePoint news post. My problem is that formatting of the news post. Can someone please assist me with formatting the news post similar to the attached document?

{

"LayoutWebpartsContent":"[{\"id\":\"cbe7b0a9-3504-44dd-a3a3-0e5cacd07788\",\"instanceId\":\"cbe7b0a9-3504-44dd-a3a3-0e5cacd07788\",\"title\":\"\\n Title area\\n \",\"description\":\"\\n Title area description\\n \",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{},\"imageSources\":{\"imageSource\":\"\"},\"links\":{},\"customMetadata\":{\"imageSource\":{}}},\"dataVersion\":\"1.4\",\"properties\":{\"imageSourceType\":2,\"title\":\"Test\",\"textAlignment\":\"Left\",\"showPublishDate\":false,\"authors\":[{\"id\":\"\",\"upn\":\"\",\"email\":\"\",\"name\":\"\",\"role\":\"\"}],\"showTopicHeader\":false,\"authorByline\":[\"\"],\"layoutType\":\"CutInShape\",\"titlePlaceholder\":\"Name your news post\",\"topicHeader\":\"\"},\"reservedHeight\":356}]","CanvasContent1":"[{\"controlType\":4,\"id\":\"1212fc8d-dd6b-408a-8d5d-9f1cc787efbb\",\"position\":{\"controlIndex\":2,\"sectionIndex\":1,\"sectionFactor\":12,\"zoneIndex\":1,\"layoutIndex\":1},\"addedFromPersistedData\":true,\"innerHTML\":\"@{triggerOutputs()?['body/Topic_x002f_Issue']}\",\"emphasis\":{}},{\"controlType\":0,\"pageSettingsSlice\":{\"isDefaultDescription\":true,\"isDefaultThumbnail\":true}}]","Title":""}@{triggerOutputs()?['body/Title']}

https://powerusers.microsoft.com/t5/Building-Flows/Create-a-news-post-when-a-list-item-is-created/m-p/841111

Categories:

Process mining

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @Anonymous,

You could add some html markup to your CanvasContent1 section of the json you currently have.

Below is an example of that:

"CanvasContent1":"[{\"controlType\":4,\"id\":\"1212fc8d-dd6b-408a-8d5d-9f1cc787efbb\",\"position\":{\"controlIndex\":2,\"sectionIndex\":1,\"sectionFactor\":12,\"zoneIndex\":1,\"layoutIndex\":1},\"addedFromPersistedData\":true,\"innerHTML\":\"<h2>Service Center Today's Update </h2>Topic / Issue Line of Business: QPPKB Article Reference: KB00012345 Did you know:Insert Communication / Message Insert Signature \",\"emphasis\":{}},{\"controlType\":0,\"pageSettingsSlice\":{\"isDefaultDescription\":true,\"isDefaultThumbnail\":true}}]",

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Expiscornovus , thank you for the suggestion. I add the html markup but keep getting a 502 error bad gateway.
I'm sure I'm definitely doing something wrong.

{
"error": {
"code": 502,
"source": "flow-apim-msmanaged-na-centralus-01.azure-apim.net",
"clientRequestId": "e8ae18bd-0e41-4bb8-91a3-1353d919774f",
"message": "BadGateway",
"innerError": {
"status": 502,
"message": "<?xml version=\"1.0\" encoding=\"utf-8\"?><m:error xmlns:m=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\"><m:code>-1, System.Runtime.Serialization.SerializationException</m:code><m:message xml:lang=\"en-US\">Expecting state 'Element'.. Encountered 'Text' with name '', namespace ''. </m:message></m:error>\r\nclientRequestId: e8ae18bd-0e41-4bb8-91a3-1353d919774f\r\nserviceRequestId: 3258c49f-f02e-c000-0163-093d8c6c3238",
"source": "https://ventechsolutionsllc.sharepoint.com/sites/U-HUB/The-Hub/_api/sitepages/pages(31)/SavePageAsDraft",
"errors": []
}
}
}

{
"LayoutWebpartsContent":"[{\"id\":\"cbe7b0a9-3504-44dd-a3a3-0e5cacd07788\",\"instanceId\":\"cbe7b0a9-3504-44dd-a3a3-0e5cacd07788\",\"title\":\"\\n Title area\\n \",\"description\":\"\\n Title area description\\n \",\"audiences\":[],\"serverProcessedContent\":{\"htmlStrings\":{},\"searchablePlainTexts\":{},\"imageSources\":{\"imageSource\":\"\"},\"links\":{},\"customMetadata\":{\"imageSource\":{}}},\"dataVersion\":\"1.4\",\"properties\":{\"imageSourceType\":2,\"title\":\"Test\",\"textAlignment\":\"Left\",\"showPublishDate\":false,\"authors\":[{\"id\":\"\",\"upn\":\"\",\"email\":\"\",\"name\":\"\",\"role\":\"\"}],\"showTopicHeader\":false,\"authorByline\":[\"\"],\"layoutType\":\"CutInShape\",\"titlePlaceholder\":\"Name your news post\",\"topicHeader\":\"\"},\"reservedHeight\":356}]",""CanvasContent1":"[{\"controlType\":4,\"id\":\"1212fc8d-dd6b-408a-8d5d-9f1cc787efbb\",\"position\":{\"controlIndex\":2,\"sectionIndex\":1,\"sectionFactor\":12,\"zoneIndex\":1,\"layoutIndex\":1},\"addedFromPersistedData\":true,\"innerHTML\":\"<h2>Service Center Today's Update </h2>Topic / Issue Line of Business: QPPKB Article Reference: KB00012345 Did you know:Insert Communication / Message Insert Signature \",\"emphasis\":{}},{\"controlType\":0,\"pageSettingsSlice\":{\"isDefaultDescription\":true,\"isDefaultThumbnail\":true}}]","CanvasContent1":"[{\"controlType\":4,\"id\":\"1212fc8d-dd6b-408a-8d5d-9f1cc787efbb\",\"position\":{\"controlIndex\":2,\"sectionIndex\":1,\"sectionFactor\":12,\"zoneIndex\":1,\"layoutIndex\":1},\"addedFromPersistedData\":true,\"innerHTML\":\"@{triggerOutputs()?['body/Description']}\",\"emphasis\":{}},{\"controlType\":0,\"pageSettingsSlice\":{\"isDefaultDescription\":true,\"isDefaultThumbnail\":true}}]","Title":"@{triggerOutputs()?['body/Title']}"}

Was this reply helpful? Yes No
jleystral 97 on at

Like (0)

Report

Would it be possible to insert a hyperlink as well?

Was this reply helpful? Yes No