
I'm not sure what i'm missing here and was wondering if anyone can suggested how to handle this. I'm using an excel file from bank to upload credit card transactions in D365 for expense management purposes. I am able to map all columns from excel to respective fields but Transaction Amount. That field is not even an option in dynamic content section and all i have is what i've highlighted in the screenshot below.
Any ideas? Let me know please.
Thanks,
Raheel
Since my entity field was formatted as currency amount, it seems like that was the reason why that amount field from excel wasn't coming up. I figured out this trick to make it work. I added a compose and copy pasted the amount value from there.
Please feel free to let me know if there is a better way of doing this. Thanks!