Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Need a formula using different types of columns/values (showing a warning/changing demand (over demand) color)


It is an app that points to 2 Sharepoint lists, 1 with 7 columns (demand) and another one with 5 columns (availability)
column type details in the images.
How does it work:
Availability: The manager registers the availability (monthly %) of the resources to be used in projects.
Demand: the PM requests the time in which he needs that resource for his project.
The appearance of the app in the attached images

A formula (or way) in which you can add the demand for each resource (within the established date), and if it is greater than the availability of that resource (previously registered) on the available date entered, a warning would appear that there is overdemand (also the % of demand entered for those dates changes to red color).

Resolver II
Resolver II

Hi @jostroca,


from the pictures it looks like you have a data table that is only used to display data and not to manipulate it. To achieve your goal, add a gallery, a demand text input and a save button. When you select the button, you need to build your logic.

First, you need to look through the table to find the availability of the selected resource (Lookup function). If the result of Lookup().availability is less than the demand, update the row, otherwise set a variable (say var_visible) to control the visibility of the warning message (a label)

Hello @anibra ,


Both screens have a gallery as you can see in the attached image.
The edit the items in the gallery, click on the ''edit in grid'' button or hit the ''new item'' button to add a new line.
To save, click again on ''exit grid view''.

Any idea how to find a formula like the one mentioned above? involving the resources (individual sum for each one) and the dates...

Resolver II
Resolver II

Hi @jostroca ,


so you have a general save button. Then you have to use ForAll function.


Hello @anibra,

Thanks again.


I still do not understand how to sum all the demand entries by date for each resource. Could you explain more in detail?

Resolver II
Resolver II

Hi @jostroca,

this example might help you Group By And Find The SUM - Matthew Devaney

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,635)