Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

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

(3) ShareShare
ReportReport
Posted on by

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

Categories:
  • IvYohuno Profile Picture
    IvYohuno 5 on at
    Re: Using Data Integration cannot use Dates as a Source Filter in get data form F&O Export

    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

     

     

  • EricRegnier Profile Picture
    EricRegnier 8,714 on at
    Re: Using Data Integration cannot use Dates as a Source Filter in get data form F&O Export

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard

Featured topics