Display Appended Comments Version History From SharePoint List On PowerApps

Thanks for this tutorial. I got everything running except that it looks like all the comments in the html field in my gallery are all the same. Am I missing something with an apply to each or extra details with getting all comments associated to each specific ID?

Hey d d, I edited my JSON as suggested but still seem to be getting those nulls returned. Do you have any other pointers? I do use a button to submit form which would update the record in a SharePoint list, but not specifically the 'notes' field I'm using for appended comments.

If you're getting null from your JSON change the type section to type": ["string" ,"null"]

Thank you for this excellent guide. I am having a bit of trouble with the formula that is used for the OnSelect property of the button in PowerApps. What is the URL that is used in the formula and where would I get the one that I need to use in mine?

For people trying to get this to work. I would recommend, also checking out this tutorial: https://www.agarwalritika.com/post/get-version-history-from-mlt-field-on-sharepoint-in-canvas-apps. That is finally how I got something to work.

I was able to successfully run the flow with only one Parse JSON action, but I had to modify the schema to the following: { "type": "object", "properties": { "value": { "type": "array", "items": [ { "type": "object", "properties": { "Comments": { "type": "string" } } } ] } }, "required": [ "value" ] }

Anyone able to get this to work? Does anyone have the missing JSON step? My flow errors at the Apply to Each step and says the first Parse JSON step is Null and can't complete. I really need to get this functionality to work

Hi Dhruvin, Thank you for these instructions. I tried to follow the steps and get to the bottom of step 1 and get the Failed to Save error when I try to save the Flow I just created. Any ideas what might be wrong? Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each' referenced by 'inputs' in action 'Compose' are not defined in the template.'.'.

Do we need to adapt the PARSE JSON step ? in the section with the json code, do we need to replace the 2 mentions of "Comment" with the name of our field ? thanks

Hey Dhruvin, I am stuck in the last step where we have to add the flow by going into the action. I get error message when I try to add your code for setting the new variable "AppendCommentsMore" as by default when I select my flow, it gives me the "Flow name.Run(" and then asks me to add 5 input variables to pass as we added in the flow.

This is what I need, but still up against a final hurdle. The variable created in the App is of DataType Record and not allowing me to get the "result" when I attempt to display the value. Any new guidance would be greatly appreciated. Thanks for making this available too!

Amazing write up. I have searched for weeks for something that I could actually follow. I'm having trouble with the Button "On Select" formula. I'm not sure how to edit that to go with my flow. This is a crucial step since it is what is connecting my app to the flow, I think. How do I get the direct link the flow? Thanks for your help!

Hi Dhruvin, thanks for this article. However, I am still far from success to implement this. The OnSelect action can not compile: Set(varholdHistory,RetrieveRemarksVersionHistory.Run(Remarks,"https://today.sharepoint.com/sites/yesterday",'mobile Connectivity Request',varCurrentRequestItems.ID)). PowerApps frown that it received an invalid number of arguments, expected 5 received 4. the arguments in the run function seems to be missing AppendComment argument. Kindly review and assist.

Hello, Can you explain the formula template? I believe i'm very close, but the differences between your list and app are not defined adequately to understand how to customize this statement for our implementation. I've been able to reverse engineer this so far. Set(variable,'Powerapp flow name'.Run("columname","site address","ListName", unknown.Selected.ID))

Did anyone find out why one of the examples showed two Parse JSON steps yet the test flow later on only showed one? I have an error when trying to create this flow, Error: Flow save failed with code 'InvalidWorkflowRunAction' and message 'The workflow run action 'Respond_to_a_PowerApp_or_flow' has type 'Response' that could not be nested under an action of type 'foreach'.'.

First of all, thank you very much for this solution approach, I have followed the steps and come to the following problem: 1) I thought the same as Joe Doe, a Parse JSON step is missing from the list, but is shown in the Screeshot. 2) I only get the last comment shown, all others don't! I'm missing an append or something from the text in the Apply_to_each loop. Is there a small fix?

Hi! I followed your procedure and it was a success. The only problem that I'm getting is whenever I update a filed on the form, I'm getting null value on the comments. I tried to create a condition and did some tweaking on the Parse Json, but still the same. Let me know your thoughts on this. Thanks.

I'm having a problem in the flow on the "Apply to each" section. "ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['properties']?['properties']?['properties']?['value']' is of type 'Null'. The result must be a valid array."I looked at the Json parse result and i saw the result that im looking for, but I can't pass the value to the string variable due this error. Do you have any ideias why i'm getting this error? Thanks. Greate job!

Unable to process template language expressions in action 'ColumnName' inputs at line '1' and column '2205': 'The template language expression 'triggerBody()['ColumnName_Value']' cannot be evaluated because property 'ColumnName_Value' doesn't exist, available properties are 'Initializevariable2_Value

Hi! When typing formula in OnSelect field, I get an error: "Invalid number of arguments: received 4 expected 1. Any ideas? Also, when I try to provide just 1 argument, flow doesn't work and I get an error:

Good day, may you please explain OnSelect Code with what is expected within the Set()brackets because I also get the same error as Vlad Albu "errors: "Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the type of values in other places in your app", "Invocation of unknown or unsuported function", "Invalid use of '.'

Hello. I do this and when I add the Button on PowerApps I receive the following errors: "Incompatible type. We can't evaluate your formula because the context variable types are incompatible with the type of values in other places in your app", "Invocation of unknown or unsuported function", "Invalid use of '.'" I used the following formula: "Set(AppendCommentsMore,GetAllversions.Run("Tax Comments","My Website Link","Audits",SPAppendText.Selected.ID))"Can you help?

In the for each step you have "Value" as output from previous step. How I get that?

When I try to set up the piece in the App it tells me "invalid argument type, table was expecting text. What am I doing wrong?

Getting the below error. Please help... The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array.

Thank you for creating this guide. It works incredibly well. One thing I would like to note. In the AppendComment HTML, you have listed "items('Apply_to_each')['Author']" to display a name on the comment/note. "Author" applies to the name of the person who created the list item, if another person updates the comment/note, their name will not be displayed. Use "items('Apply_to_each')['Editor']" to display the name of the person who updated the comment. Thank you again.

I get this error , The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array. I really appreciate any help you can provide.

Hello, thank you for this great flow! I use it in conjunction with the Microsoft PowerApps example "Heldpdesk". However I also struggle with the empty comments that are passed along from SP when an item of SP list has been edited but not the comment field specifically. I then get ugly comment historie with a lot of empty strings inbetween. also the last proposed schema here didn't change that. Is there for ex. a condition verifying for empty content to be included into the concat function? Or else? Appriciate your help!

{ "type": "object", "properties": { "d":{ "type": "object", "properties": { "results": { "type": "array", "items": { "type": "object", "properties": { "Comments": { "type": "string" } }, "required":["Comments"] } } } } } }

Please use below schema.

I am getting an error because some comments are null. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['value']' is of type 'Null'. The result must be a valid array.

Good series for power apps tutorial