Hello all,
I have a flow that is meant to track upsells our account rep team completes in D365 Finance and Ops. In the form, they enter in the Sales Order Number that has the upsold products. They also will enter in the line # and Product # to ensure its pulling the correct line in D365 F/O. Once it finds the line, it adds that line with some additional details to a SharePoint list and that is exported to a PBI report.
This has worked for the last 2 months just fine and all the way through last night but as of this morning, the flow is no longer able to find the Sales Order Number provided in the MS form. I have confirmed the Sales Orders exist and everything is correct on the form submissions as well as on D365 F/O.
I have tried re-running the last submission that did work from last night and it is not working for that submission as of this morning.
I am getting the SO number from the form, then using the D365 Fin Ops connector, I am using a list items present in table action. I am searching the D365SalesOrderLines entity and using the Odata Filter Query of SalesOrderNumber eq 'Dyanmic content of answer from form question'. This is now producing a null or [] value when it should be returning the Sales Order.
Has anyone had this issue where a flow connected to D365 was working and the next day it suddenly was unable to find any values when nothing has changed?
18
Share
Report
All responses (
Answers (
