Power Platform Community Forum Thread Details

I have built a solution in powerapps / SharePoint - but i don't think its the correct approach.

So i am looking for a) an answer to the solution i have used b) a better solution / approach

I have a SharePoint list with multiple content types. one of the content types is called Figures. This content type has columns associated to it (Jan, Feb, March, April etc )

A user manually enters a numeric value in Jan, Feb, March, April etc.

Now what i need in PowerApps is to have a icon displayed next to each month, so if the value in Jan is > 10, then the icon colour should be Red, or if it <10, then green or if the value is blank, then show Black.

What i did was, i created calculated columns in that content types called 'Jan_status', Feb_Status, Mar_Status etc. and the formula i have used for each column is =IF(January>=10,"Red","Green")

This part all works fine.

I have managed to get a icon on my power apps with circle on my edit form with the following formulae,

If(DataCardValue114.Text = "Red", Red, Green)

Where DataCardValue114 is the value of Jan_Status calculated column.

How can i write this formulae to have a default value, so if Red, then Red, else Green. Or if the DataCardValue114 is blank, then show as Black.?

Is there a better way to achieve what I am trying to achieve?

Categories:

Building Power Apps