Hi @cdn4lf ,
If I read you wright, you want to ensure that the user can submit/reserve a max of 200 sports for any selected dropdown value and the day is from a SharePoint list? if so, try this:
set this formula on dropdown OnChange property:
UpdateContext(
{
varDisableSubmit: If(
CountRows(
ClearCollect(
collabc,// collecion to avoid the delegation error
Filter(
SampleList, // SharePoint List Name
Status.Value = Dropdown15.Selected.Value // Change your Dropdown control Name
)
)
) > 199,
false,
true
)
}
)
Now you set the variable on visible property of the submit button:
varDisableSubmit
Now user can submit the form if the selected dropdown values have less than 200 rows in SharePoint list.
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.
Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
