cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndreAdc
Advocate I
Advocate I

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,344)