Gallery to pick the status column

(0) Share

Report

Posted on by jakeandsnake

Hi,

I have set up a SharePoint list to track my project status like the below scenario:

1. Columns "Step 1" to "Step 10" are boolean values.

2. I could not change the list structure.

I'm building an App and trying to use Gallery to show each project next step according to the SharePoint List data, the below is the expected table:

How can I achieve that?

Thanks in advance!

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

PTBBSolutions 691 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jakeandsnake ,

Add this to your gallery items and refer to the column "Next Step":
AddColumns( [Source name], "Next Step", If( Step1 And !Step2, "Step2", If( Step2 And !Step3, "Step3", If( Step3 And !Step4, "Step4", If( Step4 And !Step5, "Step5", If( Step5 And !Step6, "Step6", If( Step6 And !Step7, "Step7", If( Step7 And !Step8, "Step8", If( Step8 And !Step9, "Step9", If( Step9 And !Step10, "Step10" ) ) ) ) ) ) ) ) ) )
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
HI @jakeandsnake ,

You need to go backwards on this as below

AddColumns( YourListName, "Next Step", If( Step10, Complete", Step9, "Step 10", Step8, "Step 9", Step7, "Step 8", Step6, "Step 7, Step5, "Step 6", Step4, "Step 5", Step3, "Step 4", Step2, "Step 3, Step1, "Step 2", "Step 1" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jakeandsnake ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps