cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jagangv
Microsoft
Microsoft

Using Data Integration cannot use Dates as a Source Filter in get data form F&O Export

Hi,
We are looking for a syntax for filtering data via Dates range using Data Integrator to move the data from D365 F&O export project. So the Data Integrator should sends the filter to F&O and get the exported data based on the date filter.
Kindly let us know what kind of syntax can be used to filter based on the date. Or is there an option to filter date format from DI to D365 F&O with possible documentation. How can we pre filter from F&O export to DI ?
Capture1.PNGCapture.PNG

2 REPLIES 2
EricRegnier
Super User II
Super User II

Hi @Jagangv,

Have you tried the F&O forum for better support as this is mainly for Dataverse?

https://community.dynamics.com/365/financeandoperations

Cheers

This was an issue I had and it seems like the issue should be owned by both Power Platform and Finance and Operations parties. 

 

There is a way of filtering dates in Finance and Operations, therefore, I assume it is possible for CDS Data Integrator to add these filters if there was an update on the UI. On the Finance and Operations side, this could be fixed by adding syntax in the query language to date filter a Record-ID- However, I imagine changing a whole query language would be a lot more work that adding additional UI elements that may communicate with Finance and Operations in amore detailed way

 

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (75,473)