Not able to get decimal fields from Excel listed as field on D365 for Finance and Operations

[AndreAdc]

Hi community,

I'm building a Flow to create purchase orders in Dynamics 365 for Finance and Operations based on lines provided in an Excel sheet. I'm using the List rows action from the Excel for Business connector. When I choose an action of type Create a record in Dynamics 365 for Finance and Operations, I can see the list of Excel fields on string typed fields like the item number. When I want to have the same lookup for decimal type of fields, the list is empty. 

I reviewed the Excel sheet and noticed that the Excel cell type for the quantity and purchase prise was set to standard. I already tried to change this to decimal.

This is not helping me to show the correct fields. I cannot create the order lines without the quantity. Does anyone has experience how to solve it?

[v-yamao-msft · Accepted solution]

Hi @AndreAdc,

I am afraid that you may need to convert the value’s type to string or others. Please check the following doc on Conversion functions for more details:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#c...

Hope it could be a reference for you.

Best regards,

Mabel Mao

[AndreAdc]

Hi Mabel,

Thanks for your reply. It helped. Using the float() function, it works. Pretty stupid thing here is that another sheet on another entitiy of Dynamics 365 for Finance and Operations is working correctly on the decimal fields without this float() function.

I wonder what is the trigger in Flow to show what columns to choose from. I also wonder if the float function is smart enough to recognize local settings for the decimal symbol.