cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
K_Zarar
Level: Powered On

Trying to create a note in Dynamics 365 from Sharepoint List

Hi guys,

 

Like the title says, I'm trying to create notes in Dynamics 365 from a Sharepoint List.

 

The flow runs successfully if I don't map the "Regarding" and "Regarding Type" fields.

 

What I'm trying to do is put the ContactID in the Regarding Field and selected contacts as the entity type in the Regarding Type field. I'm pretty sure the problem lies here. However, I need to use these fields as the notes would go under a specific contact.

 

The error I'm getting is :

flow error.PNG

 

Your help is appreciated!

 

Cheers,
Kashif

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi @K_Zarar 

 

Can you please share more details on this? Can you share a screenshot of the flow (barring any sensitive information)? I just made a small test on my end and it works fine. I want to check how you are passing the regarding fields in the flow in particular. 

 

 

View solution in original post

5 REPLIES 5
Dual Super User
Dual Super User

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi @K_Zarar 

 

Can you please share more details on this? Can you share a screenshot of the flow (barring any sensitive information)? I just made a small test on my end and it works fine. I want to check how you are passing the regarding fields in the flow in particular. 

 

 

View solution in original post

K_Zarar
Level: Powered On

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi Yash,

Thanks for the reply!

 

I've actually got the flow to work.

 

But what I'm struggling with right now is querying the result. Is there anyway to query just the Contact IDs from the Contacts entity? Because I've got a condition flow next that actually sees whether the ContactID from my Sharepoint list matches the Contact IDs that have been queried and then create the note if it equals to yes.

flow3.PNG

 

I also get an error which basically says a lot of data is being queried whereas the flow can handle only a fixed amount (I forgot what the error actually says, but this is what I made of it).

 

Cheers,

Kashif

Dual Super User
Dual Super User

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi @K_Zarar 

 

Can you share what is it that you mean by Contact ID? is it a custom field that you have created or is it the guid of the record that you want to get? 

 

Either way you cannot restrict the fields that are coming in. You might want to add 2 in the top count to check if the results that are coming in are correct. 

 

Have you tried using the Common Data Services (CDS) connector for this? 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

K_Zarar
Level: Powered On

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi Yash,

 

What I meant was:

When we are querying the Contacts entity, the entity and all its fields get querid. But wha would've helped was if I could query a certain field only.

Super User
Super User

Re: Trying to create a note in Dynamics 365 from Sharepoint List

Hi @K_Zarar 

It is possible to control which fields are returned if you use the Common Data Service (Current Environment) connector which is available when building your Flows within a Solution. It is good practice to return only the fields that you are interested in to avoid issues with large datasets being retrieved.

 

image.png

 

Also, if you know the SharePoint ContactId that you want to compare before you make the call to Dynamics 365 then you should be able to add another filter condition on the ContactId. Based on the field you are using for the order, this filter will be 

int_contactid eq [DynamicValueHere]

Replace the value "DynamicValueHere" with the SharePoint Contact Id that you want to use for your comparison. Then add another action within an Apply to Each (on the list Contacts result) after the list records action to send the email. This will only be executed if a result is found in Dynamics matching the ContactId.

 


Did I answer your question? Mark my post as a solution!

Proud to be a Flownaut!


Follow me on Twitter at @QG_LeeJHarris

Or on LinkedIn at in/leejharris

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons in April

Read the announcement for more information!

firstImage

Better Together Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Kudoed Authors
Users online (4,441)