Updating Timeline with Activity

(0) Share

Report

Posted on by SMS-Martin

Hello

I require guidance on a power automation I have created for my business. The main automation is functioning correctly. It performs a lookup against a subscription table and sends an email to each customer if any subscriptions are due within the next 30 days.

This part of the automation is working as intended. However, I want to post an update to the account record timeline to indicate a reminder has been sent to the customer as an audit trail.

It does create a task in Dynamics but it is not associated with the customer’s account record because it does not fill in the regarding field. I am unsure where I am going wrong and tried several methods but nothing seems to work. If I looked at the output when running the automation, I can see the account GUID for each customer's account in the output

Here the code for the process

{
"inputs": {
"host": {
"connectionName": "xxxxxx",
"operationId": "CreateRecord",
"apiId": "xxxxxxx"
},
"parameters": {
"entityName": "tasks",
"item/subject": "TEST: Your Subscription is Renewing Soon",
"item/description": "30 day renewal reminder email has automatically been sent to @{items('Apply_to_each')?['account/emailaddress1']} on @{formatDateTime(utcNow(),'dd MMM yyyy HH:mm')}.",
"item/regardingobjectid_account_task@odata.bind": "@{items('Apply_to_each')?['_xxx_account_value']}"
},
"authentication": "@parameters('$authentication')"
},
"metadata": {
"operationMetadataId": "xxxxxx"
}
}

Regards

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

BCBuizer 22,692 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @SMS-Martin,

To populate the Regarding field, in the action that creates the record in the Task table, set the following for the Regarding input field:

/accounts(<AccountGUID>)

, where <AccountGUID> should be dynamic content that references the Account GUID for the customer.

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
SMS-Martin 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks @BCBuizer

I have updated the Regarding (Accounts) to /accounts(@{items('Apply_to_each')?['_xxx_account_value']})

and now get this error

The supplied reference link -- /accounts() -- is invalid. Expecting a reference link of the form /entityset(key).

Regards

Was this reply helpful? Yes No
BCBuizer 22,692 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @SMS-Martin,

Based on the provided error message, it seems the reference to the Account GUID resolving a blank value: there is nothing between the parenthisis.

This means either the value is missing in the referenced action, or the expression is not correct. If you can share the expression and a sample of the output of the referenced action, maybe I can help determine which of the two is causing the error.

Regardless, there is a way to prevent blank values from causing an error, but that does mean no relation with the account is saved:

if( equals( <AccountGUID>, null ), null, concat( '/accounts(', <AccountGUID>, ')' ) )

If this reply helped you in any way, please give it a Like 💜 and in case it resolved your issue, please mark it as the Verified Answer ✅.

Was this reply helpful? Yes No
SMS-Martin 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks @BCBuizer

The output from the action when testing is

{

"error": {

"code": "0x80060888",

"message": "The supplied reference link -- /accounts() -- is invalid. Expecting a reference link of the form /entityset(key)."

}

}

The expression on the post to timeline is

/accounts(@{items('Apply_to_each')?['_sms_account_value']})

The initial list rows which filters the subscriptions expiring to send the email code is, this the goes through an array to send out the email and update the xxx_remindersent to true, it should, then post a update the customers account timeline as a task, the task is created but it not filling in the Regarding (Account) field with the customers account name to associate it with the account

{

"inputs": {

"host": {

"connectionName": "xxxx",

"operationId": "ListRecords",

"apiId": "xxxx"

},

"parameters": {

"entityName": "xxx_productses",

"$select": "xxx_domain,xxx_nextbillingdate,xxx_name,xxx_dotorenew",

"$filter": "xxx_nextbillingdate ge @{addDays(utcNow(),28)} and xxx_nextbillingdate le @{addDays(utcNow(),31)} and xxx_duration eq 1 and sms_billingplan eq 1 and xxx_remindersent eq false and statecode eq 0 ",

"$expand": "xxx_Account($select=name,emailaddress1)"

},

"authentication": "@parameters('$authentication')"

},

"runtimeConfiguration": {

"paginationPolicy": {

"minimumItemCount": 5000

}

},

"metadata": {

"operationMetadataId": "xxxxxx"

}

}

Regards

Was this reply helpful? Yes No