Hello All,
I need some direction but first here is my setup in my app that I believe is relavent to my situtation.
Sharepoint:
Columns = single line of text
Collection: colDays
ClearCollect(
colDays,
{
Value: "Sunday",
ID: 1
},
{
Value: "Monday",
ID: 2
},
{
Value: "Tuesday",
ID: 3
},
{
Value: "Wednesday",
ID: 4
},
{
Value: "Thursday",
ID: 5
},
{
Value: "Friday",
ID: 6
},
{
Value: "Saturday",
ID: 7
}
);
Form:
DataSource: Sharepoint
DefaultMode: Edit
Items:
Gallery.Selected
Gallery:
Items:
Filter(Sharepoint,'Created by' = User().Email)
DataCard:
Default:
ThisItem.ColumnName
Update:
ComboBox.Selected.Value
Multiselect.Combobox:
OnSelect:
Set(VarMeetDaysChanged, true)
Items:
colDays
DefaultSelectedItems:
Split(Parent.Default, ", ")
Modern Date Picker:
OnChange:
If(
!(Weekday(Self.SelectedDate) in ComboBox.SelectedItems.ID),
Notify(
"Date does not match Activity Meeting Days.",
NotificationType.Error,
3000
) & Reset(Self)
)
I have a Combobox that is Multiselect with each day of the week as an option. This is sent to my Sharepoint which is setup as single line text. My submitting the form is not an issue. When the form is in edit mode the user might need to update the Weekdays selected. If they do this then the way the formula is setup it should only allow them to select dates that equal the weekdays they selected in the Multiselect.Combobox. This is not happening. When I use the Modern Date Picker it does not allow any days to be selected. I have narrowed it down to the defaultselecteditems on the Combobox is not truely registering the days selected. They show in the top of the drop down field but as you can see in the picture below they are not actually selected. I also selected another weekday and my rule worked.
Does anyone see what I could do to fix this? Maybe some formula I am missing? I thought about making the Multiselect.Combobox into checkboxes and I kept getting lost on this.
As always any help will be greatly apprciated.
Thanks,
Collin
