Hi,
Not sure if it is the best way, but I would do the following:
Before your step to create a new vendor in D365FO, I would start with (1), to pull the vendor data from D365.
You dont want to pull all vendors, thats why you need a filter criteria under (2). Lets say you choose to take the Tax exempt number to check if the vendor exists, just as an example here, then the filter query would be something like:
TaxExemptnumber eq 'x' - x is the tax exempt number that you pull from the sharepoint list. So, you are pulling vendor data from D365 only that have the tax exempt number from the sharepoint list.
Now you create the condition (3).
In (4) you put in the Tax exempt number from step (1).
In (5) you put in the tax exempt number from your sharepoint list.
If the condition is true, i.e. a tax exempt number is found in step 1, then step 4 will be equal to step 5. In this case you can insert a Terminate step when condition is true.
If the condition is false, then you proceed with your steps to create a vendor.
You could also change 4 and 5 in such a way to check if the list under step 1 is empty or not - there are multiple ways to check that.
If step 1 is empty, then it means no vendor with the tax exempt number from the sharepoint list was pulled, i.e. the record doesnt exists.
Hope it helps, Adis
If this helped, please mark it as "Verified" for others facing the same issue
Keep in mind that it is possible to mark more than one answer as verified
