cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jostroca
Regular Visitor

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

Description:

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

Need:
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).

5 REPLIES 5
anibra
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 ,

Thanks!

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...

anibra
Resolver II
Resolver II

Hi @jostroca ,

 

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

ForAll(Gallery.AllItems,If(Lookup()))

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?

anibra
Resolver II
Resolver II

Hi @jostroca,

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

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,977)