Answered

Create a news when an item is created Question

(0) Share

Report

Posted on by knishal

185

Hi I have a question about this post you created. https://powerusers.microsoft.com/t5/Building-Flows/Create-a-news-post-when-a-list-item-is-created/m-...

l follow the instruction in that post and was successful, however at the last send HTTP action whenever I add the Text Properties from the when a new item is created, I am getting this error:

When a new item is created: I am adding the Text on and thats where the error is coming from. If I add title/name the flow runs with no errror:

Would you be able to assist?

Categories:

General topics

All responses (10)

Answers (1)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @knishal,

Have you added the Text field within the innerHTML property? Can you also share a screenshot of the configuration of that Send an HTTP request action which uses the SavePageAsDraft method?
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Expiscornovus I think the issue is, its getting the text field as an HTML. When I add the text field I am getting the error only, it started a timer on the work flow then it fails after 20 minutes.

here is the code:

The flow runs fine when I remove the text field.

I think since the text filed is a multiple line of text field in sharepoint, there has to be a compose method to remove the HTML tags because this is how its seeing the text field:

This is the output for when an item is created.
</div>","Text2":"<div class=\"ExternalClass747E7CCDCE8A42DEA57125DABC98288E\"><p>test8<br></p></div>

If there is a way it can remove the the html tags, i think then it will work. The test 8 is the text that needs to be extracted.
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @knishal,

In that case try an HTML to text action. And use the output of that in your Send an HTTP request action.
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @Expiscornovus I tried that but its giving me the same issue:
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!
This is the raw out from the HTML To Text:
{ "host": { "connectionReferenceName": "shared_conversionservice", "operationId": "HtmlToText" }, "parameters": { "Content": "<p><div class=\"ExternalClassF3736BF7A7E74453854FAF6D68CD89E0\"><p>test8<br></p></div></p>" } }
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @knishal,

That looks like the input instead of the output, to be honest. What is in the raw outputs?

When I use your html I am getting this:

It looks like it is adding new line characters. We can remove them by using a replace.

Can you use this together with the HTML output?

replace(body('Html_to_text'), decodeuricomponent('%0A'), '')
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!
Yes i took a look, I am getting the same output as well. I tried with your
replace(body('Html_to_text'), decodeuricomponent('%0A'), '')
& I am getting the same error:
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @knishal,

Your Title is empty, you used Title/Name field for that before, right? Can you please add a Title in the last part of your json?
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow. That works, Thank you so much @Expiscornovus .

Now I need to add a picture but it starts the timer when I did, Where do I add the picture in the json?

I am getting the picture from when an item is created:

Also is it possible to use a template or retain this format:
knishal 185 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a profile banner image url on the destination site:
Whenever a post is created it, display the image and the title on the home page:
Its currently not displaying any image. Do i get a get the image and store it somewhere or how can I do this? @Expiscornovus