Power Platform Community Forum Thread Details

I followed Reza Dorrani Video for "Power Automate SharePoint Item Modified flow | Track Column Changes"

https://www.youtube.com/watch?v=Ek4oYWPWfT0

and I was able to get Previous version, current version history values of all updated column values for a particular item except for a Choice column that allows multiple selections. Can you help me on how to get previous, current version values of a choice column that allows multiple selection?

Basically what he is doing in that video is:

-> When an item or a file is modified

-> Get Changes for an item or a file (properties only) since previous version using

Since: sub(decimal(triggerOutputs()?['body/{VersionNumber}']),1)

-> Get Previous values by using below

Select

From: split(replace(replace(string(outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/ColumnHasChanged']),'{',''),'}',''),',')

Mapped ColumnName: replace(split(item(),':')[0],'"','')

Value: split(item(),':')[1]

Filter Array

From: Output of Select

Value is equal to 'true'

Select Column Names

From: Body Attribute of Filter Array

Map: item()?['ColumnName']

Send an HTTP Request to SharePoint

Uri: _api/web/lists/GetByTitle('List Name')/items(@{triggerOutputs()?['body/ID']})/versions?
$filter=VersionLabel eq '@{sub(decimal(triggerOutputs()?['body/{VersionNumber}']),1)}'&$select=@{join(body('Select_Column_Names'),',')}

Apply to each

Output from Select Column Names

Append to array variable

Name: varValues

Value: {
"Column": "@{item()}",
"PreviousValue": "@{coalesce(body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']?[1]?[item()],'')}",
"CurrentValue": @{coalesce(body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']?[0]?[item()],'')}
}

Apply to each varValues

Output from varValues

Append to array variable 2

Name: varHTML

Value: Column @{items('Apply_to_each_varValues')?['Column']} has updated from @{items('Apply_to_each_varValues')?['PreviousValue']} to @{items('Apply_to_each_varValues')?['CurrentValue']}

-> Send an HTTP Request to SharePoint

Body:

{
"properties":
{
"To":{"results":["@{triggerOutputs()?['body/Editor/Email']}"]},
"Subject":"Item Updated : @{triggerOutputs()?['body/Title']}",
"Body":"<h2 style='font-weight: 1000'>Track Changes </h2> 
@{join(variables('varHTML'),' ')}

<a href='@{triggerOutputs()?['body/{Link}']}'>Open Item</a>
 
<a href='https:abc.com/_layouts/15/Versions.aspx?
ID=@{triggerOutputs()?['body/ID']}&IsDlg=1&list=
abclistID'>Version History</a>"
}
}

Added all the pictures in the same order. I would appreciate your guidance on this

TIA!