Customer experience | Sales, Customer Insights,...

Removing contact from marketing list in Power Automate

(0) Share

Report

Posted on by Odetonoise1

Hi There,

I'm trying to set up a flow that removes a contact from a static marketing list after a certain condition is met.

I'm trying to use the "Perform a bound action" step and I'm getting the error below. Not sure if anyone has run into this before or how to get around it.

Thanks!

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

protc on at

Like (0)

Report

Hi,

Thank you for your query.

When an action requires an entity as a parameter and the type of entity is ambiguous, you must use the @odata.type property to specify the type of entity. The value of this property is the fully qualified name of the entity, which follows this pattern: Microsoft.Dynamics.CRM.+<entity logical name>.

If you do not specify the type of entity in this situation, you can get the following error: "EdmEntityObject passed should have the key property value set.".

Refer the article for more info on Bound actions,

docs.microsoft.com/.../use-web-api-actions

Was this reply helpful? Yes No
Odetonoise1 20 on at

Like (0)

Report
Thanks Protim,

As seen in the screenshot, and in the code peek below. It appears I am passing that

"parameters": { "entityName": "lists", "actionName": "Microsoft.Dynamics.CRM.RemoveMemberList", "recordId": "@outputs('Compose_Marketing_List_GUID')", "item/ListMember/entitytype": "Microsoft.Dynamics.CRM.contact", "item/ListMember/_entityid_value": "@items('Apply_to_each')?['_entityid_value']" }

The form for the Perform Bound Action doesn't specify an field for oData type.

The options I have are below.

Entity name

Marketing lists

*Action Name

RemoveMemberList

*Item ID

⁠Outputs×⁠

listmember overriddencreatedon

listmember _ownerid_value

listmember _modifiedonbehalfby_value

listmember entitytype (Input: Microsoft.Dynamics.CRM.contact)

listmember _createdby_value

listmember name

listmember _listid_value (Input: Contact GUID)

listmember owninguser

listmember importsequencenumber

listmember timezoneruleversionnumber

listmember owningbusinessunit

listmember createdon

listmember modifiedon

listmember versionnumber

listmember _entityid_value

listmember _modifiedby_value

listmember listmemberid

listmember utcconversiontimezonecode

listmember _createdonbehalfby_value

Not sure which one I should be selecting? OR do I have to just insert that attribute in the body of the response?

Was this reply helpful? Yes No
Suggested answer

protc on at

Like (0)

Report

You need to add the Odata.type and specify the contact entity manually I guess

"@odata.type": "Microsoft.Dynamics.CRM.Contact",

May be like this, but I have not tested it

"parameters": {
"entityName": "lists",
"actionName": "Microsoft.Dynamics.CRM.RemoveMemberList",
"recordId": "@outputs('Compose_Marketing_List_GUID')",

"@odata.type": "Microsoft.Dynamics.CRM.contact",

"item/ListMember/entitytype": "Microsoft.Dynamics.CRM.contact",
"item/ListMember/_entityid_value": "@items('Apply_to_each')?['_entityid_value']"
}

Was this reply helpful? Yes No
Suggested answer

Odetonoise1 20 on at

Like (4)

Report

Hi Protim,

I engaged Microsoft support on this and they provided the following response.

"For RemoveMarketingList action, below should be the values:

listmember entitytype = "@odata.type": "Microsoft.Dynamics.CRM.Contact"

listmember listmemberid = @{items('Apply_to_each')?['contactid']}"

It appears you have to declare the full JSON attribute in the field, not just the full logical name of the entity in question.

Thanks again for your support on this!!

Was this reply helpful? Yes No
CraigK 55 on at

Like (0)

Report

Hi Odetonoise1,

I'm also attempting to use this bound action to remove members from a subscription list but I cannot seem to get the formatting for listmember entity type correct. Do you happen to have a screenshot of how you have this implemented in Power Automate?

Any help is greatly appreciated!

Was this reply helpful? Yes No
Suggested answer

Ramon M. R. 10 on at

Like (0)

Report

I think the made a mistake and switched the naming of listmember_entity_value with listmember_listmemberid. Below is a working example

Was this reply helpful? Yes No
MM-17091751-0 4 on at

Like (0)

Report

How did you surface the EntityType? I'm not finding it when I list rows for listmembers.

Was this reply helpful? Yes No