Apologies for the delayed response,
No stress at all, happy I can be of help :D,
Its definitely possible but since its not utilizing locally stored data (since numerous people need to access it) you would have to use a database to store the data (I would say sharepoint lists is best since its free and more than capable of doing the job).
Firstly, Ill show you the structure of the list,
It contains the Title column and the Colour Column which is a text datatype column. Title is the default Title datatype.
Next, make the connection to the list in PowerApps. Go to 'Add Data' > Sharepoint > Add A Connection > It will open up a page where you can add the sharepoint connection > Go back to the App > Ensure it is connected or else select that connection again.
Once its connected, use the Patch function like so (Noting my list is called Test List, and my first Table has the Title column value of Table 1 etc,
This will actually live update the datbase so anyone who is using the app will be able to update these. It would be worth placing a timer on the screen too so it refreshes the list every 3 seconds or so.
For your convenience here is the code noting you will have to do this for every table/traffic light:
If(
LookUp('Test List', Title = "Table 1").Colour = "Red",
Patch(
'Test List',
LookUp('Test List', Title = "Table 1"),
{
Colour: "Green"
}
),
LookUp('Test List', Title = "Table 1").Colour = "Green",
Patch(
'Test List',
LookUp('Test List', Title = "Table 1"),
{
Colour: "Red"
}
)
)
2nd code:
If(
LookUp('Test List', Title = "Table 1").Colour = "Red",
Color.Green,
Color.Red
)
Hope this helps 🙂
If you need more tailored advice, feel free to reach out on DM.
