Sumif - Sharepoint List Validation

[cdn4lf]

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?

[eka24]

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.

[KrishnaV]

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.

[cdn4lf]

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?