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.
Check out these cool Power Apps & vote on your favorite!
Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021