Showing data against the time range of correlated inputs in 2 lists

[Joaoandrebs]

I have a gallery that displays some data from list 1. In list 2 are some input data, BOTH have in common
the same "ATIVO" column, I need to make a condition that:

When inputting data that is related to the asset that the column "Semana1"  (week1) is = 5, it shows the green color in the rectangle on the side for 1 day in the gallery - when the 1 day expires, show the yellow color as it is -

If the input is for the asset that has the number 1 in the week 1 column, the rectangle turns green for 7 days, then turns yellow again.

If the input is of the asset that has the number 2 in the week 1 column, the rectangle turns green for 15 days, then it turns back to yellow.

[BCBuizer]

Hi @Joaoandrebs ,

Not sure if I understood you correctly, but please try the below on the Fill property of the Icon:

If(
   DateDiff(
      Today(),
      Modified
   ) <= Switch(
      ThisItem.Semana1,
      1, 7,
      2, 15,
      5, 1
   ),
   Color.Green,
   Color.Yellow
)

[v-mingkz-msft]

Hi @Joaoandrebs,

Do you want to display the data in gallery which is from another list, such as when the value of column "semana1" = 1,the icon will turn green lasts 7 days?

If so, please try:

1. Set OnSelect property of button as: 

Set(BeginTime,Today());Refresh(Test1);Refresh('List Test')//Test1 and 'List Test' are my datasource

Note that: 

a. I can't determine whether the data source is updated through the form, so I use the button to determine the time when the gallery's timer starts.

b. when the button is clicked, the begin Time is determined, then it can make sure when the icon turns yellow.

2. Set the Fill property of icon as:

If((LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=1) && (Today() <= DateAdd(BeginTime,7)),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=2) && (Int(Today()) <= Int(DateAdd(BeginTime,15))),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=5) && (Int(Today()) <= Int(DateAdd(BeginTime,1))),Color.Green,Color.Yellow)

Best regards,

Kyrie Zhang

[Joaoandrebs]

@BCBuizer @v-mingkz-msft  thanks for the answers, you are very helpful!!

@v-mingkz-msft the case that satisfied me was yours, but a doubt, if they had one more time variable, for example, if week1 was = 3, reset it in 3 days? there would be no way to use another look up, right?

[Joaoandrebs]

@v-mingkz-msft actually it's almost like that, except that in the other list ('list test') the items are created and it has to be based on this to change colors, you know?

[v-mingkz-msft · Accepted solution]

Hi @Joaoandrebs,

Do you need to add one more condition to control the icon to turn green?

You can add some conditions in the If function. Such as:

If((LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=1) && (Today() <= DateAdd(BeginTime,7)),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=2) && (Int(Today()) <= Int(DateAdd(BeginTime,15))),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=5) && (Int(Today()) <= Int(DateAdd(BeginTime,1))),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=3) && (Int(Today()) <= Int(DateAdd(BeginTime,3))),Color.Green,(LookUp(Test1,ATIVO=ThisItem.ATIVO).week1=4) && (Int(Today()) <= Int(DateAdd(BeginTime,4))),Color.Green,Color.Yellow)