Hello,
I have sharepoint list, and it has column 'Target Customer' containing date value (mm/dd/yyyy). I want to filter that column with combobox, but I want to show a date value with format like (mm/yyyy), the list component which has that date (mm/yyyy) will show in gallery. how to do that?
Thank you in advance.
@firda59 ,
That is strange as it works fine in my testing - below is a better version with applies Distinct to the MM/YYYY format rather than the full date
Distinct(
AddColumns(
SPList,
"MonthYear",
Text(
'Target Customer',
"mm/yyyy"
)
),
MonthYear
)
Test result below
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Hi @WarrenBelz
Not error, but show nothing.
This is my SP list
This is my Apps
Do you know how to fix it? Thank you
@firda59 ,
In the Combo Box Items
AddColumns(
RenameColumns(
Distinct(
SPList,
'Target Customer'
),
"Value",
"Dates"
),
"Value",
Text(
Dates,
"mm/yyyy"
)
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Hi
Distinct('Your SharePoint List', 'Target Customer')
Text(Value, "[$-en-US]mm/yyyy")
Replace "Value" with the name of the column that contains the date value.
Filter('Your SharePoint List', 'Target Customer' = ComboBox1.Selected.Value)
Replace "ComboBox1" with the name of your ComboBox.
Hi @firda59 ,
Assuming you have the combo box Items displaying mm/yyyy and I have also assumed an output of .Value for it,
then the filter would be something like
Filter(
AddColumns(
SPList,
"TargetMY",
Text('Target Customer', "mm/yyyy")
),
TargetMY = YourComboBox.Selected.Value
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps