Data Validation in gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

i have a requirement which might sound confusing and i am not able to achieve it so reaching out for help.

i have a gallery with multiple month columns (Jan,Feb,March), now when i hit the edit button i can edit the data.

Now the user have a specific requirement, this is in regard to resource utilization. The total resource utilization of an employee for a month cannot be greater than 1.
Now, as you see in the below image , what i am trying to explain is , if lets say user A has a project ABCDEF for which his utilization for the month of Jan is 1 then if he is being assigned another project his utilization for the month can be only 0 , as he is already assigned 1 for month of Jan for project ABCD.

so while the user is entering the number and moves on to the next input , the app should check for all the lines for that particular employee in the collection and calculate the total and if the sum is equal to 1 then only 0 can be entered but if it is less than 1 then the user can only enter the 1 - total number.

i hope it makes sense , i know it can be a little confusing if you need more help do tell me , but it is a really necessary requirement and would appreciate if someone could help me out in this.

Thanks in advance guys.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous
Maybe you can do next.
Make sure all the month input boxes are format Number and put your validation in the 'Max Length' property of the input fields.
In the Maximum Length property you could take the total sum of all the lines and if it's 1, then max length is 0 and if lower max length is 1. I'm not exactly sure on what it exactly is you have to filter, but here's an idea to put in the Maximum Length property of the input boxes:
If( Sum( Filter(colProjects, employee = "John Smith", month = "January" ), WorkLoad ) >= 1, 1, 0 )
Hope this helps. Let me know if I misunderstood.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@SkiDK i do allow text values too in those column, however if we make it number value. what i would like to do is to filter out all the values of that particular employee sum it up and see if the sum is greater than 1 and if it is it automatically becomes 0 and if not you see a message saying you can enter 1-total sum value = answer in the text box.

Was this reply helpful? Yes No