Unanswered

If Statement for Table Column Value

(0) Share

Report

Posted on by PatrickMcLeanGL

I am making a procurement tracker and have a component that progresses through 19 steps.

Right now the varCurrentStep is just 1, 2 ,3 etc.

But I want to make it so that when an item moves to step 2, the varCurrentStep will move automatically. I was going to do this by changing the "Status" column in my table to "Step 2" and then doing an if statement (If Status = Step 2, set value to 2).

What is the syntax for this? I have If('Status (Tracker Table)'.Value = "Step 2", 2) but that doesn't seem to be working.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @PatrickMcLeanGL ,

If you are navigating using button/icon as progress stages (used in PowerApps template) or moving through stages then use this on the button.

Concurrent( If('Status (Tracker Table)'.Value = "Step 1", Set(varCurrentStep, 1)), If('Status (Tracker Table)'.Value = "Step 2", Set(varCurrentStep, 2)), If('Status (Tracker Table)'.Value = "Step 3", Set(varCurrentStep, 3)), If('Status (Tracker Table)'.Value = "Step 4", Set(varCurrentStep, 4)), If('Status (Tracker Table)'.Value = "Step 5", Set(varCurrentStep, 5)), If('Status (Tracker Table)'.Value = "Step 6", Set(varCurrentStep, 6)), If('Status (Tracker Table)'.Value = "Step 7", Set(varCurrentStep, 7)), // ... so on );

Your variable will be updated,

Hope this helps

Was this reply helpful? Yes No
PatrickMcLeanGL on at

Like (0)

Report
Copy link

Link copied!

I'm still sort of new to powerapps, where would I put this?

In addition is it possible to update the edit form with new fields for each stage? For example, stage 2 is review sample documentation, so I wanted to have a box that they could tag the date it was reviewed and would add it into the dataverse table, then when they progress to stage 3 (issue sample PO), that field would disappear and different fields (sample PO issue date) would appear instead.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @PatrickMcLeanGL ,

Can you show how is the App setup, as there can be many ways of approach.

Also, is can be possible to update the form but I need to check your app.

Was this reply helpful? Yes No
PatrickMcLeanGL on at

Like (0)

Report
Copy link

Link copied!

Very early stages obviously.. trying to get the functionality working first.
So left side is a Gallery of items from a Table, Right side is the editable form. I want the progress to next stage button to change the stage of the item to its next stage (stage 2 to stage 3) which in turn would update the progress bar at the top to the correct stage.

Was this reply helpful? Yes No
PatrickMcLeanGL on at

Like (0)

Report
Copy link

Link copied!

This is the component.

Was this reply helpful? Yes No