You’re offline. This is a read only version of the page.
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 :
Your help is appreciated!
Cheers,
Kashif
Hi @Anonymous
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.
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.
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.
Hi @Anonymous
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!
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.
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
Hi @Anonymous
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
