Create a SharePoint Item once based on the new Purchase Order in Business Central

[NastaraN]

Hi, 

I am trying to create a simple workflow between Dynamic 365 Business Central and SharePoint. I created a list in SharePoint with metadata columns relevant to the Purchase Order info of Business Central. The flow includes 3 simple steps, but I got this error in the test. I've already changed the currency code to Number, currency and text, none of them worked, however i am not sure what is the 'Number/double'. 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/CurrencyCode' is required to be of type 'Number/double'. The runtime value '"CAD"' to be converted doesn't have the expected format 'Number/double'.

I would appreciate if anyone can help. 

Thanks, 

Nastaran 

[edgonzales]

@NastaraN 

Hey there.  So, I'm reading this error as your SP list has a "required" field of "Currency Code" that is an ID rather than a text field (possibly a lookup?).  So, the value you are feeding it (in this example) is "CAD" for Canadian Dollars, but it is expecting a number.

Take a look at the output from your Get Record, and see if there is another value that is the ID of the corresponding Currency type rather than the familiar name, then use that as your dynamic value for your "Create Item" step.

Hope that helps.

-Ed

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

[NastaraN]

Hi Edgonzales, 

Thank you for your response. Your suggestion response resolved the main issue, the flow works now, but it doesn't take the information of the amount & currency. 

Please let me know if you have any resources or video that explains similar scenario to my scenario for more learnings. 

Thanks,