cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cdn4lf
Resolver I
Resolver I

Sumif - Sharepoint List Validation

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?

3 REPLIES 3
eka24
Community Champion
Community Champion

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
Community Champion
Community Champion

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.

 



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,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a THUMS-UP and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.

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?

Helpful resources

Top Solution Authors
Top Kudoed Authors
Users online (3,833)