Unanswered

Power Automate to Get Appended Comments from SharePoint List and Insert Into Word Template

(0) Share

Report

Posted on by cjwilson80

Hello!

I have a SharePoint list with a Comments column that is set to Append so that all comments are saved with date/time stamp. I have a Power Automate flow that populates a Word Template with the data from the SharePoint List Item properties, however, I cannot pull in the Comments.

How can I get the list of comments (with date / time stamps and all) from the SharePoint list so that I can populate the Word Template with them?

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@cjwilson80

Can you share how your comments column look like on the sharepoint list ? And also how your flow is structured.

Thanks

Was this reply helpful? Yes No
cjwilson80 95 on at

Like (0)

Report
Copy link

Link copied!

Hello!

Thanks for your reply. I've attached images of what the column looks like and the comments I want to pull out. I don't have much of a flow right now since I keep having to re-do it over and over again.

I've attached the flow that runs successfully.

Was this reply helpful? Yes No
jesslynh 179 on at

Like (0)

Report
Copy link

Link copied!

Did you ever resolve this? I'm trying to get appended text and its only returning the most recent appended textline

Was this reply helpful? Yes No
viplavmulkacpm 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Im trying to achieve the same, though unable to parse through json to extract text

Was this reply helpful? Yes No
jesslynh 179 on at

Like (1)

Report
Copy link

Link copied!

I looked at the notes for my flow and I think I grab the current text on the SP item(datahistory) into a variable, the new text into another variable, concatenate them and add back to the SP list item.

Was this reply helpful? Yes No