cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bh4
Level: Powered On

display values from "append changes to existing text" column in email flow set-up and powerapp

Hi!

 

I have a column in my sharepoint list with " append changes to existing text"  on. In the sharepoint list it just shows "view entries".

 

I am working on a flow that sends an update request to the owner associated with that item and in the email I have included a number of fields but also want to show the various items in that specific column. However, when nothing comes up in the email for that field.

 

Is there a clever way of modifiying the flow to retrieve all the entries in that column and displaying them into the email? I am also looking for a way to show these into a powerapp which I am building in case there is also a solution for that.

 

Thank you in advance for any suggestions. I did look around for solutions but couldnt find anything that worked.

 

question1.pngquestion2.png

1 ACCEPTED SOLUTION

Accepted Solutions
bh4
Level: Powered On

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @abm 

 

thanks for the help. I am afraid i would need some more guidance with the http and json part. not sure what to put in Uri and the json schema..

 

thanks!

 

update.png

View solution in original post

8 REPLIES 8
Super User
Super User

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @bh4 

 

In your email all other field mapping are showing correctly? Only the 'Update' multi-line text values are not displaying.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



bh4
Level: Powered On

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi abm,

Yes all the other fields are correct. Just the column with “append to existing text” is blank.
Super User
Super User

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @bh4 

 

I am working on this and get back to you on tomorrow.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Super User
Super User

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @bh4 

 

Please follow the below steps. Here I am usin a selected list item from SharePoint which I am using as my trigger. Next step I have declared an array. This is used for storing all the comments later.

 

val1.png

 

Next we need to use the API call for getting all the versions and use a parse JSON to extract the values. To get the schema of the JSON run the flow up to Send an HTTP request to SharePoint step. Copy the results into the Parse JSON to generate the schema.

 

ver1.png

 

{
"type": "object",
"properties": {
"d": {
"type": "object",
"properties": {
"results": {
"type": "array",
"items": {
"type": "object",
"properties": {
"__metadata": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"uri": {
"type": "string"
},
"type": {
"type": "string"
}
}
},
"Update": {
"type": [
"string",
"null"
]
}
},
"required": [
"__metadata",
"Update"
]
}
}
}
}
}
}

 

 

Finally iterate the JSON results and append the comments in an array.

val3.png

If you have any more questions let me know.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



bh4
Level: Powered On

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @abm 

 

thanks for the help. I am afraid i would need some more guidance with the http and json part. not sure what to put in Uri and the json schema..

 

thanks!

 

update.png

View solution in original post

Super User
Super User

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @bh4 

 

Can we do a screen share? 

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Super User
Super User

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

Hi @bh4 

 

Thanks for the screenshare. I have updated my earlier reply.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



bh4
Level: Powered On

Re: display values from "append changes to existing text" column in email flow set-up and powerapp

@abm helped me to get the flow to work during a screenshare. He was very knowledgeable and helpful. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 174 members 5,605 guests
Please welcome our newest community members: