Hello,
This is my first time making a PowerApps form, so hopefully this isn't too obvious. I am trying to make a form that will validate against a larger SharePoint list to ensure that no more than 200 spots are booked for any drop-down value.
Is there an easy way to go about this?
Can you give example to explain the scenario, if possible a screenshot
------------
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
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.
Hi Kristina,
That's one approach to it. What if I wanted to count a value in a column expected attendance (variable by row), and limit is so the expected attendance for any dropdown value was less than 200?
User | Count |
---|---|
121 | |
88 | |
88 | |
75 | |
66 |
User | Count |
---|---|
215 | |
180 | |
138 | |
96 | |
82 |