How to set Rectangle fill color based on previous and current row of gallery in power apps ?

Like (0) Share

Report

Posted on 2 Apr 2024 06:13:21 by mkmaheshKumar

Suppose I have a gallery with one rectangle and one status label. The gallery has four rows. If the previous row's status is 'approved' and the rectangle is filled with color Orange, then the current row's status is 'approved' and the rectangle will be filled. If the previous row's label status is 'pending' and the current row's status is 'approved', then I want the rectangle to not fill. See in the image, the first row is 'pending' but the others are 'approved' with the rectangle filled. I want the user to restrict step by step when the first row's status is 'pending

Categories:

Microsoft Dataverse

All responses (1)

Answers (0)

v-yueyun-msft on 02 Apr 2024 at 06:32:08

Like (0)

Report

Re: How to set Rectangle fill color based on previous and current row of gallery in power apps ?

Hi , @mkmaheshKumar

You need to add an index row in your collection.

This is my test data:

ClearCollect(col2, {Name: "Himanshu Singh" , Status : "Pending"},{Name: "Mahesh Kumar" , Status : "Approve"} , {Name: "Varun Updhyay" , Status : "Approve"},{Name: "Satyam Pandey" , Status : "Pending"} );

We can use this code to add an index row:

ClearCollect(col3,ForAll(

Sequence(CountRows(col2),1,1),

Patch({LineNo:Value},Index(col2,Value))

))

We can use this code in the rectangle-Fill:

If( CountIf( Filter(col3,ThisRecord.LineNo<=ThisItem.LineNo) , Status<>"Approve") >0 , Color.Gray , Color.Orange)

The result is as follows.

If the first is Pending:

If the first is Approve:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang