HI
I have custom list with following fields
Title – String
Impacted Sites – Choice field with Multi Selection Enabled {Site1, Site2…Site16 }
Status – Choice { Red, Amber , Green}
I have to show the 16 tiles (Site1, Site2…Site16) in PowerApps screen. By default background color of the each tile is Green.
In case any item added in the above custom list with Red or Amber, I need to change the background color of respective tile.
Ex: New Item added in the list and if I selected Site1, Site 3 in the “Impacted Sites” choice filed, I need to change the background color the Site1 and Site 3.
Red Priority :
If have two items added in the list like
Item 1 – Site 4 and Site 6 selected and Status is Amber
Item 2 – Site 6 and Site 8 Selected and Status is Red
I need show the Site 6 tile background color in Red. Since Red is the first priority.
I can able to write he script to achieve this functionality in SPFX. But I have restricted use only PowerApps with MS Flow to achieve this requirement.
Can you please help me how to do this reequipment in PowerApps.
The script I written to get the open items(Red and Amber) is below.
private async getOpenItem()
{
let myMap = new Map();
var results = await pnp.sp.web.lists.getByTitle("List")
.items.filter(`Status ne 'Green'`)
.select("ID","Title","Description",
"Status","ImpactedSites")
.get();
// .then( results =>
// {
if(results != null)
{
for(var i=0;i<results.length;i++){
var stringArray = results[i].ImpactedSites.splice(',');
for(var j=0;j <stringArray.length;j++)
{
if(myMap.has(stringArray[j]))
{
if(results[i].Status =="Red")
{
var status =myMap.get(stringArray[j]);
if(status ="Amber")
{
myMap.set(stringArray[j],results[i].Status);
}
}
}
else
{
myMap.set(stringArray[j],results[i].Status);
}
}
}
if(myMap.size>0 )
{
this.FormTiles(myMap);
}
}
}
