Forum Discussion

royalswe's avatar
royalswe
Helper I
5 years ago
Solved

Dynamic date in Odata query

I am fetching data from Dynamics 365 with OData and I only want to fetch data that is 3 days old or newer.   I have this query and it works but the date is hardcoded as you can see.     = ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

royalswe did this work for you in the service as well? I keep getting the error saying dynamic content can't be scheduled?

 

Thanks,

royalswe's avatar
royalswe
Helper I
5 years ago

No It didn´t work when scheduled in services.

I had to make the date filter in another row in the M query.

Like this

 

 

let
    Source = OData.Feed("https://sandbox.operations.dynamics.com/Data/SupplyForecastEntries?"
    &"$select=StartDate, SupplyTypeId, LastDate"
    // &"&$filter=ForecastStartDate ge " & Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()), -3), "yyyy-MM-dd")
    , null, [Implementation="2.0"])
   , #"Filtered Rows" = Table.SelectRows(Source, each [StartDate] >= [LastDate])
in
    #"Filtered Rows"