I have a List in SP where the data table items are loaded from list i wanted a filter to change the data table items based on dropdown selection
example : my dropdown items are ["2000","2001","2003","2004"] i receive an error i wanted to convert string in date format using the filter command
Filter('datasource','Date of Separation',Text("[$-en-US]yyyy")=ddyrs.SelectedText.Value). any ideas
Solved! Go to Solution.
i did a work around i have created a Field in Sharepoint as YEAR and bind to dropdown and then put the formula
Filter('Staff Separation',Year=ddyrs.SelectedText.Value) once i select a year from the drop down my data table display the items
What you are asking is not possible in a data table control. You have to build a gallery that looks like a table and supply a Dropdown. Here’s a video from Reza Dorrani that shows how to do it. https://m.youtube.com/watch?v=8I0Pt_8I6k8
---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
i did a work around i have created a Field in Sharepoint as YEAR and bind to dropdown and then put the formula
Filter('Staff Separation',Year=ddyrs.SelectedText.Value) once i select a year from the drop down my data table display the items
The filter function requires a logical expression not just a field and a value. But the error you are getting is because you want to filter by year. You can't format just a year as a Date time value. I think this is the filter command you want
Filter('datasource',Year('Date of Separation') = ddyrs.SelectedText.Value)
But as @mdevaney said you can filter the contents of a table but you can't edit values inside a table. Which is what I think you are trying to do.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
260 | |
128 | |
86 | |
85 | |
68 |