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.
I am afraid I have moved to a simpler solution. So I can no longer provide any more details.
You are welcome to delete the thread.
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.
Still lost.
Hi @gene,
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:
Distinct(
Filter(Schedule, DateDiff('Week of', DateAdd(Today(), -Weekday(Today())+2)) = 0),
Target
)
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:
Distinct(
Filter(
Schedule,
DateDiff(DateValue(Text('Week of')), DateAdd(Today(), -Weekday(Today())+2)) = 0
),
Target
)
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.
Best regards,
Kris
I am afraid I have moved to a simpler solution. So I can no longer provide any more details.
You are welcome to delete the thread.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
203 | |
187 | |
81 | |
50 | |
37 |
User | Count |
---|---|
292 | |
244 | |
123 | |
74 | |
55 |