Customer Engagement & Dynamics CRM Forum

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Does the data have to all be created at once? Can you not separate your Flows 'Create Contact' and then Create 'Phone Calls' The other option would be creating a Flow but add a delay action in-between creating the Contacts and then the Phone Calls.

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton
------------------------------

Original Message:
Sent: Feb 17, 2022 04:47 PM
From: Rod Carlson
Subject: Using Power Apps to create Activities

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Thanks for your comment Adam,

It is true that the data does not have to be created at once. However, I do not see how to retrieve the newly created contact IDS, after they have been imported, and then apply them to the regarding ID column before inserting into the Phone Calls Table. Would Flow allow me to have temporary storage?


------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Original Message:
Sent: Feb 18, 2022 03:01 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

Does the data have to all be created at once? Can you not separate your Flows 'Create Contact' and then Create 'Phone Calls' The other option would be creating a Flow but add a delay action in-between creating the Contacts and then the Phone Calls.

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 17, 2022 04:47 PM
From: Rod Carlson
Subject: Using Power Apps to create Activities

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

This is what I would do:

1. Flag the Contact records you are importing
2. Create a List Row Action and set Filter Rows to retrieve the flagged Contacts
3. Next add a Add a new row Action - Set the field Regarding(Contacts) /contacts(Contacts) This is the unique identifier from the Contact List Rows Action

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton
------------------------------

Original Message:
Sent: Feb 18, 2022 10:04 AM
From: Rod Carlson
Subject: Using Power Apps to create Activities

Thanks for your comment Adam,

It is true that the data does not have to be created at once. However, I do not see how to retrieve the newly created contact IDS, after they have been imported, and then apply them to the regarding ID column before inserting into the Phone Calls Table. Would Flow allow me to have temporary storage?


------------------------------
Rod Carlson
Database Administrator
Chicago

Original Message:
Sent: Feb 18, 2022 03:01 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

Does the data have to all be created at once? Can you not separate your Flows 'Create Contact' and then Create 'Phone Calls' The other option would be creating a Flow but add a delay action in-between creating the Contacts and then the Phone Calls.

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 17, 2022 04:47 PM
From: Rod Carlson
Subject: Using Power Apps to create Activities

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Thanks! I will try that out. In parallel, I am researching the Azure Data Factory with pipelines.

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Original Message:
Sent: Feb 18, 2022 10:34 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

This is what I would do:

1. Flag the Contact records you are importing
2. Create a List Row Action and set Filter Rows to retrieve the flagged Contacts
3. Next add a Add a new row Action - Set the field Regarding(Contacts) /contacts(Contacts) This is the unique identifier from the Contact List Rows Action

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 18, 2022 10:04 AM
From: Rod Carlson
Subject: Using Power Apps to create Activities

Thanks for your comment Adam,

It is true that the data does not have to be created at once. However, I do not see how to retrieve the newly created contact IDS, after they have been imported, and then apply them to the regarding ID column before inserting into the Phone Calls Table. Would Flow allow me to have temporary storage?


------------------------------
Rod Carlson
Database Administrator
Chicago

Original Message:
Sent: Feb 18, 2022 03:01 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

Does the data have to all be created at once? Can you not separate your Flows 'Create Contact' and then Create 'Phone Calls' The other option would be creating a Flow but add a delay action in-between creating the Contacts and then the Phone Calls.

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 17, 2022 04:47 PM
From: Rod Carlson
Subject: Using Power Apps to create Activities

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

I was able to build several pipelines with Azure Data Factory. In combination with SQL database Tables/Views and custom fields to store special unique keys between the SQL database records and custom fields added to Dynamics 365, I was able to get everything working.

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------

Original Message:
Sent: Feb 22, 2022 10:10 AM
From: Rod Carlson
Subject: Using Power Apps to create Activities

Thanks! I will try that out. In parallel, I am researching the Azure Data Factory with pipelines.

------------------------------
Rod Carlson
Database Administrator
Chicago

Original Message:
Sent: Feb 18, 2022 10:34 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

This is what I would do:

1. Flag the Contact records you are importing
2. Create a List Row Action and set Filter Rows to retrieve the flagged Contacts
3. Next add a Add a new row Action - Set the field Regarding(Contacts) /contacts(Contacts) This is the unique identifier from the Contact List Rows Action

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 18, 2022 10:04 AM
From: Rod Carlson
Subject: Using Power Apps to create Activities

Thanks for your comment Adam,

It is true that the data does not have to be created at once. However, I do not see how to retrieve the newly created contact IDS, after they have been imported, and then apply them to the regarding ID column before inserting into the Phone Calls Table. Would Flow allow me to have temporary storage?


------------------------------
Rod Carlson
Database Administrator
Chicago

Original Message:
Sent: Feb 18, 2022 03:01 AM
From: Adam Travers
Subject: Using Power Apps to create Activities

Does the data have to all be created at once? Can you not separate your Flows 'Create Contact' and then Create 'Phone Calls' The other option would be creating a Flow but add a delay action in-between creating the Contacts and then the Phone Calls.

------------------------------
Regards, Adam Travers
Empath Services Ltd
Southampton

Original Message:
Sent: Feb 17, 2022 04:47 PM
From: Rod Carlson
Subject: Using Power Apps to create Activities

I would like to use Power Apps to created activities inside Dynamics 365.

I am thinking of using Data Flows.

However, the tricky part are activities. I need the Regarding Object ID to have a value.

For example, if the contacts are new and the phone calls are new, How do I know the contact ID (which has not been created yet) in order to insert into the Regarding ID for the Phone Call record?

Any suggestions?

Thanks

------------------------------
Rod Carlson
Database Administrator
Chicago
------------------------------