Filter Gallery Based on Calculated Date

[karldenton]

Hi

I have a Sharepoint list where "Due Date Calculated" is a date field but is calculated based on 2 other columns.

I'm trying to filter a PowerApps gallery based on Due Date Calculated been less than today but it says "Invalid Argument Type Expecting Number, Date, Time, DateTime

Could anyone help

If I have a label as that field it shows as 2022-06-08T07:00:00Z

Many thanks

[AmDev]

Hi @karldenton 

Power Apps and calculated fields don't play nice sometime, which may be the issue here.

In most cases, if you are using Power Apps, it's best to handle all your calculations and logic inside the app and keep things simple in your datasource.

Would that approach suit your use case?

[karldenton]

Thanks for the reply. Potentially.

Basically we test an item on a date then add a certain number of days to it from a dropdown and the calculated column adds those together.

I can do it in powerapps as long as the back end list shows the calculated date.

[AmDev]

Yeah, that shouldn't be an issue.

Your calculation for that date could be set as instantaneous when the nr of days is selected - Just as long as your process for changing and selecting the days concludes with a means (patch or submit form) of submitting that calculated date back to what would then be a standard date/time column in SPO

[karldenton]

Fab I'll give it a go.

Is it possible to do the calculated label based on a date plus a number selected from a dropdown? So the amount of ADDDAYS would be from the dropdown?

Also just had a thought, what about all the data that is current in the SPL as that's what I want to filter the gallery on

Thanks

[AmDev]

Yes, say you have Combobox1, which has an Items property '[1,2,3,4]' - i.e. the nr of days you want to add

Your label text would include your DateAdd function and would look like this:

DateAdd(DateYouWanttoAddTo, Combobox1.Selected.Value)

In terms of all the data in your SPL, you can then just filter, based on how you wer trying to originally with your nerw DueDate, date/time column . So if you want to filter by all items where due date is less than today:

Filter(yourlist, DueDate < Today())

Hope this helps