cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Validation of two lists on filling a form

Hi all,

I am having two lists,

One contains the list with all details and is grouped based on date and have separate totals columns for each date,

I am trying to validate that total column data with a date with value in another list while filling the form.

 

For Example,

 

List 1

DateSome DataSeating 
July 1Text130
July 1Text240
Sum 70
July 2Text320
Sum 20

 

List 2

DateSeating Availibility
July 1100
July 220

 

In the form validation,

If (List1.Sum of July 1) <= (List. Seating Availability of July 1)

 then (Submit the form)

else

(Invalid entry)

 

Any way to achieve this.

Also, I am using List 2 to generate a chart next to the form to make the user aware of the seating availability.

 

Thanks

22 REPLIES 22

Same, not getting the sum of seats.

Screenshot 2020-07-05 at 11.19.52 PM.png

Try;
ClearCollect(MyRequest,Filter(AddColumns(GroupBy('All Requests',"Date","AllSeats"),
"TotalSeats"Sum(AllSeats,Seats)),Text(Date,ShortDate)>=Text(Today(),ShortDate)))
 
If still errors give 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.

Screenshot 2020-07-06 at 12.16.41 AM.png

Deadline is the date

 

Invalid argument type, expecting a number value

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (27,592)