Creating a Progress Bar That Resets for each Record in Loop

[robgar]

Hello-

I am not here asking how to create a progress bar per say.  I have one what works.  However, for my application I need the progress bar to reset at the conclusion of each record being created.  Here how my app works ...

Our HR department fills in a form in powerapps that will be used to create an O365 user.  When they submit the form, it writes that record to a gallery.  They can add multiple people to that gallery by submitted the form more than once.  Once they click SUBMIT ALL, a power automate flow is run that performs about 6 steps to create each user in Azure AD etc etc.  That works.  Every user is created successfully.

What I'd like to do is create a progress indicator for EACH RECORD.  It goes thru 6 steps for record #1, resets the progress indictor for record #2 and so on.  Most progress indicator posts talk about performing 1 process from 0-100% .. I'm talking about resetting for each record and I'm at a loss.

The progress indicator I am using works for record #1, but it will never reset for any further records as the "apply to each" loop works it's magic .. it just shows 100% while it churns thru every record.  I'm looking for help on how to reset the progress indicator each time thru the loop.

My progress indicator uses a dataverse table to document which step of the process has started.  After step 6, the flow deletes all rows in the dataverse table and the "apply to each" loop continues and new "stages" are written to the dataverse table.  However, in powerapps, the indicator never visually resets (which uses the Fill property for each step when the dataverse table includes that "stage"). It just shows every stage as being done.

I'm willing to rebuild my process indicator method to make this work, so instead of being bogged down by the details above, if you think you have a similar solution, I'll all ears!  

For people who like picture, I provided 1 of the progress indicator and 1 of the flow.

Appreciate any thoughts.

[turnerj3]

Since you are already tracking the stages, could you set variables true or false for which stage you are currently on and use the variables in your fill property?

Something like: If(stage1, Set(varStage1, true) And Set(varStage2, false), stage2, Set(varStage2, true)) etc…

Just set 2-6 false at Stage 1 and it should work.

[robgar]

Appreciate the response.  I see where you are going with that.  Attached is my Fill code now on the circle shape.  I'm doing a lookup to the stage in the Dataverse table and changing the color based on if that row is present or not.  I thought by removing the row(s), that would reset my Fill .. but no.  I may fool around with your idea which is a slightly different approach.

[turnerj3]

In theory it looks like it should work. How are you looping through the gallery. I’m guessing on the submit all, the whole gallery or collection is going to power automate for the loop? 

[robgar]

So, when a HR specialist enters the user in the form and submits it, I am writing that information to a 2nd dataverse table.  The gallery is just disapplying that table.  In the actual power automate flow,  I am doing a List call for all rows of the dataverse table. 

Here's a pic of where I am calling the dataverse table that contains every new user to be created and then applying each step in a apply to each loop. As I mentioned, my flow works/loops perfectly ... it's just the progress indicator will not reset on each cycle of the loop.  Honestly, I think it's something within the powerapp that isn't able to register the current stage properly, so I'm going to look at your idea around variable usage to see if that would create a different behavior.

[turnerj3]

@robgar ,

Before you get too far. What I’m thinking now is On submit you are sending all items to power automate, but is it possible it is only taking the first thisitem into account from powerapps? 

[robgar]

The submit button is not sending anything other than 2 variables which are used in the flow.  It is simply calling the flow. The flow then pulls in the dataverse table that holds all of the new users to be created that were submitted by HR using the form in the app, and it cycles thru each record.  Here is an example of 2 new users created and you can see it cycled thru both of them .. and as proof, but users were created in AzureAD as expected.

What I am doing at the end of each loop is resetting the 1st dataverse "stage" table I spoke of which sets the values for the shape Fill that I pasted above.  Once those values are deleted, theoretically the Fill should reset the progress indicator shapes .. and when the 2nd users goes thru the loop the stages are recreated in the dataverse table and the Fill should do just like it did for the 1st user ... but it's not.  It's never resetting .. it's like the shape Fill is ignoring the formula of when to fill a shape or not.

Maybe I will post a video for you to visually see it?  Not sure if I am allowed to in the forum.

[Acropolis9064]

I don't know if this would work properly or not and it's just off the top of my head, but I'm wondering if when you are checking for the stages it's not refreshing the data source properly maybe?

How about adding a Processing 1/6 to the bottom maybe? set a var to 1 /countrows in gallery, then increment the var by 1 each time the loop is completed.

As for updating the circular, i'd be tempted to go with a check against the stages table that if the row value for the stage is true then green otherwise orange, and refresh the data course every few seconds within that somewhere.

Hopefully that makes some sense, but it's the end of a very long day and my brain isn't working properly!

[turnerj3]

It’s an odd one, it is obviously talking between the two platforms or it wouldn’t work the first time. Almost like the data needs to refresh or something.

[robgar]

@turnerj3 ,

BTW:  My progress indicator is based on this article if that helps.  The article uses ShrePoint .. I'm using Dataverse.  The problem with this article (and every other one I can find) is that folks are suggesting how to create a singular 0-100% progress indicator, but NOT a indicator that resets and restarts.  Thats what I'm trying to work out.

How to implement a Power Automate progress indicator in Power Apps (m365princess.com)