cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RalphyC
Helper I
Helper I

Adding missing data to Activity Party in Dynamics using Flow (or any other means for that matter)

Hi all, 

We have a lot of unresolved email addresses in our system and they're causing us a problem with some of our data extraction work (not reelvant here). 

 

As a potential solution I used Advanced find to see that these objects existed as Activity Party entries, but seemed to be missing a partyid. I then used powerBI to extract all the Activity Partys that has missing partyid to confirm and this was the case. I've put together a flow that correctly interrogates the Activity Party using Fetchxml :

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
<entity name="activityparty">
<filter type="and">
<condition attribute="partyid" operator="null" />
<condition attribute="partyidname" operator="eq" value="xxxx@xxx.net"/>
</filter>
</entity>
</fetch>

to bring me back a list. But when I try to update the missing data:

RalphyC_0-1628091028766.png

I get the error:

The 'Update' method does not support entities of type 'activityparty'.

 

This seems odd. It is a single row in a table that is being edited and it has a single missing column value. Any ideas on how I can make the flow update the row (or any other way of achieving the same aim)?

Thanks

Ralph

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC 

I managed to replicate the same scenario with multiple unresolved addresses per email activity and to keep the sender as well, it is a little bit lengthy solution but it works.

1. This the same List rows from Previous Solution

Mira_Ghaly_0-1628506264598.png

2. Initialize UniqueActivityId array and Activity Party Array to hold the Sender and unresolved created contacts

Mira_Ghaly_1-1628506321317.png

3. Append to the Activity Id Array

Mira_Ghaly_2-1628506380277.png

4. Get Unique Values

Mira_Ghaly_3-1628506420318.png

union(variables('UniqueActivityIdArray'),variables('UniqueActivityIdArray'))

5. Parse JSON

Mira_Ghaly_4-1628506468154.png

Schema:

{
    "type": "array",
    "items": {
        "type": "string"
    }
}

6. Loop on the output of Unique Activity Id  to get related activity Party Id only, So List Rows 2 gets all activityparties per emailid

Mira_Ghaly_5-1628506562164.png

7. Clear the array of the ActivityParty before looping on List Rows 2

Mira_Ghaly_6-1628506632899.png

Mira_Ghaly_7-1628506711207.png

8. Get the email sender and append to the activity party id

Mira_Ghaly_8-1628506791171.png

9. And this is how the final update happens on the email

Mira_Ghaly_9-1628506834038.png

Hope this fixes your issue!

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

8 REPLIES 8
Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC 

Create/ Update are not supported on the activityparty Table/Entity, An alternative approach I would suggest and i have tried myself and it looks working , is that you update the email activity instead of the activity party.

 

So you create a contact with the unresolved email and link it to the To  as below but you need to do it on more than one step because the email i suppose it is sent so to be able to update it you need to change it to Open -> Draft and then Update activity Party then Back to Completed -> Sent

 

First step is to get activityparties as you already did:

Mira_Ghaly_0-1628332556592.png

Apply to each and create a contact from the activity party email as below:

Mira_Ghaly_1-1628332672175.png

Change email to Draft:

Mira_Ghaly_3-1628332771992.png

 

 

Mira_Ghaly_2-1628332741131.png

Mira_Ghaly_4-1628332808174.png

Then next step another update on the Email record to update the activity party to the created record and set Activity Status to Completed and Status Reason to Sent

 

Mira_Ghaly_5-1628332873796.png

 

Hope this works for you!

 

 

 

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Thanks @Mira_Ghaly  that's an awesome set of instructions and I think  gets me nearly there. Just a quick question before I run it through:

If I understand it correctly, the update on the Activity Party Attribute on the Update Row will replace whatever was there before. This could be a problem as we have a lot of these emails where there are multiple to/cc recipients only one of which is unresolved (which is why I had headed down the activityparty table route). If I'm correct (and I may not be), I would need a way to resolve 'n' unresolved items from a json array of variable length without changing the correct items. So - am I right (if not your solution will work perfectly) and if I am, have you any more ideas?

(If I get a chance to test this before you reply I'll update the post!)

Thanks again 

Ralph

Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC 

Yes it will replace so the solution will be simply as you need while looping on each activity party -> get the other related activity party ids given the Activity ID , so you will have a list of activity parties per Activity Id, then you create a contact and append to an array variable in the below format:

Mira_Ghaly_0-1628497948042.png

The update the email as below by passing the array variable:

Mira_Ghaly_1-1628498040876.png

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC 

Can I ask you if you need to keep the Sender as well?

Is the Sender usually a User or it can be anything ?

Why I am asking this here is because we need to replace the whole activity party array with the newly created contacts as well as the sender..

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here
Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC 

I managed to replicate the same scenario with multiple unresolved addresses per email activity and to keep the sender as well, it is a little bit lengthy solution but it works.

1. This the same List rows from Previous Solution

Mira_Ghaly_0-1628506264598.png

2. Initialize UniqueActivityId array and Activity Party Array to hold the Sender and unresolved created contacts

Mira_Ghaly_1-1628506321317.png

3. Append to the Activity Id Array

Mira_Ghaly_2-1628506380277.png

4. Get Unique Values

Mira_Ghaly_3-1628506420318.png

union(variables('UniqueActivityIdArray'),variables('UniqueActivityIdArray'))

5. Parse JSON

Mira_Ghaly_4-1628506468154.png

Schema:

{
    "type": "array",
    "items": {
        "type": "string"
    }
}

6. Loop on the output of Unique Activity Id  to get related activity Party Id only, So List Rows 2 gets all activityparties per emailid

Mira_Ghaly_5-1628506562164.png

7. Clear the array of the ActivityParty before looping on List Rows 2

Mira_Ghaly_6-1628506632899.png

Mira_Ghaly_7-1628506711207.png

8. Get the email sender and append to the activity party id

Mira_Ghaly_8-1628506791171.png

9. And this is how the final update happens on the email

Mira_Ghaly_9-1628506834038.png

Hope this fixes your issue!

 

 

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

RalphyC
Helper I
Helper I

Thanks @Mira_Ghaly extremely helpful. You're definitely getting a solution from this (I would never have got close without your help), but I just want to complete the final method first. I think I've simplified this down,  but just testing some different scenarios...

 

RalphyC
Helper I
Helper I

Hi @Mira_Ghaly thanks so much for your help on this. I've simplified some bits and complicated others to get to the solution I needed, and now have a flow that checks the email address against existing contacts and runs on a case by case basis (because all these clauses make it very slow). But just a quick thing about the existing parties:

If you filter for the existing parties like so:

RalphyC_0-1628701766134.png

The output results allow you to dynamically update the json in a single append apply to each:

RalphyC_1-1628701887504.png

 

That makes that section of the flow much neater. 

 

Thanks again for all your help

 

Ralph

 

Mira_Ghaly
Dual Super User II
Dual Super User II

@RalphyC

  • Yeah thanks for sharing the append part for the activity party it makes perfect sense.
If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,791)