Power Platform Community Forum Thread Details

Hi,

I am working with dataverse and working to create an app.

Database contains 5 parameters in which the validity are allowed to be overlap, example:

London-Jakarta/20/Dry/Empty/1 jan -31 jan 2021 = USD 1000

London-Jakarta/20/Dry/Empty/10 jan -31 jan 2021 = USD 1200

London-Jakarta/20/Dry/Empty/25 jan -31 jan 2021 = USD 1500

London-Jakarta/20/Dry/Empty/1feb - 28 feb 2021 = USD 1500

If the user is requesting price with:

London-Jakarta/20/Dry/Empty/15 jan -31 jan 2021 --> then it should return USD 1200
London-Jakarta/20/Dry/Empty/15 jan - 28 Feb 2021 --> then it should return USD 1200, and later on result screen we will override the date of validity = 15 Jan - 31 jan 2021

In order to set up this kind of filtering, I am using clear collect and filter - however the date filtering is not working and it keeps retrieving null value

ClearCollect(
GetPriceColl,
Filter(
[@Containers],
new_sector = DataCardSector.Selected.Value,
new_containertype = DataCardCargoType.Selected.Value,
new_containersize = DataCardContainerSize.Selected.Value,
new_type = DataCardType.Selected.Value,
new_validityfrom >= DateValueValidForm.SelectedDate,
new_validityto <=DateValueValidTo.SelectedDate
)
);
Navigate(ResultScreen)

Result: [{"BAF":null,"CargoType":null,"ContSize":null,"DHC":null,"EWRI":null,RecommendedTotalPrice":null,"Sector":null,"Type":null}]

Any suggestion how I can set up the filtering based on validity?

Thanks a lot!

Categories:

Microsoft Dataverse with Power Apps