I have a client who has a list in SharePoint and they are moving to Dynamics. In the interim they would like to continue using their SharePoint task list as they have for years but sync new assignments over to Dynamics as they come to help transition. Before I update a Dynamics record I have been told I need to do a "List Records" and "Filter Query" to get the specific record needing the update. I am having trouble with the Filter Query to get the specific record to update. When I click on the Filter Query I don't get any Dynamics records as options only SharePoint ones. so I am manually typing in the field name in dynamics "BSC File No" which is the unique key for the list in SharePoint. My Query looks like this:
http://www.digitalcontentpros.com/DCP/Images/FlowError.GIF
I think I need to place a Dynamics Dynamic Field Control on the left then eq then the SharePoint Dynamic Field Control as I currently have. I am puzzled why I cannot see the Dynamics dynamic fields as options. Here is the error I am getting as I am running it now. http://www.digitalcontentpros.com/DCP/Images/FlowError2.GIF
I've seen online examples where the field is spelled out like I have done it but it is not working for me. I have searched the internet high and low for someone who has updated a Dynamics record from SharePoint with no luck. Can anyone help?