Probably a newbie issue.
This is this the formula I am trying to use to populate a fitered list in a dropdon.
It seems PowerApps does not see the ( Schedule.'Week of' ) as date. This is clearly setup as a date within the list.
Distinct(Filter(Schedule, DateDiff(Schedule.'Week of', DateAdd(Today(), -Weekday(Today())+2)) = 0), Schedule.Target)
I get a invalid argument type.
Solved! Go to Solution.
A little more troubleshoooting..... I found out Poweapps is seeing the SP List Field as a number and it's a large number like excel's native format.
So now how do I convert Today's date to a number or convert the List date field 'Week of' to a date for comparison?
So thinking the the date field in SharePoint 'Week of' is in a "DateValue" format, I tried setting this part in a DateValue "DateAdd(Today(), -Weekday(Today())+2)" So the entire formula would be
Distinct(Filter(Schedule, DateDiff(Schedule.'Week of', DateValue(DateAdd(Today(), -Weekday(Today())+2))) = 0), Schedule.Target)
I still get a Invalid argument type on the operator.
Could you please share more details about your error message with your formula in your app?
Based on the formula that you mentioned, I have made a test, and don't have the issue that you mentioned. The screenshot as below:
If the 'Week of' column is a Date type column in your SP list, I think there is no syntax error with the formula that you provided.
Please take a try to modify your formula as below:
Filter(Schedule, DateDiff('Week of', DateAdd(Today(), -Weekday(Today())+2)) = 0),
In addition, if PowerApps recognize the 'Week of' column (of your 'Schedule' SP list) as a Number type column, and you want to convert the 'Week of' column value into a Date value, please take a try with the following workaround:
DateDiff(DateValue(Text('Week of')), DateAdd(Today(), -Weekday(Today())+2)) = 0
If the issue still exists, please consider take a try to re-create your SP list, and create a new app based on this SP list, try above formula again, check if the issue is solved.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021