Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Progress bars per service

(0) ShareShare
ReportReport
Posted on by 192

Hi all,

I have a SharePoint list and I want to do a few progress bars that will show the progress of every service.

Because all of the services are displayed in one list, I am going to use the text label at the beginning of each question to identify the service that it is attached to. That way, I can sort by service type and create a progress part that will identify how many questions have been submitted per service. (exmple: VM_ , EDR_ )

 Is it possible?

 

Thank you for your help!

  • lidor_dayan Profile Picture
    lidor_dayan 192 on at
    Re: Progress bars per service

    @madlad thank you!!

  • madlad Profile Picture
    madlad 2,637 on at
    Re: Progress bars per service

    The formula I sent earlier should store a collection with the progress for each item. To view it within a gallery, you just have to reference that item's record in the completion progress collection, and you'll be able to any item's progress.

     

    For example, in a gallery you'll want to use a lookup, something like

    LookUp(completionProgresses, Title = ThisItem.Title).Count

    Which will return the # of completions for that item.

     

    As for keeping this data up to date as you make changes, you can just rerun the clearcollect every time you make a change. It's not necessarily the absolute best solution but it should work.

     

    Please keep in mind the formulas I've been sending are general and will have to be customized to your data.

  • lidor_dayan Profile Picture
    lidor_dayan 192 on at
    Re: Progress bars per service

    Hi @madlad ,

    I have a screen in the canvas app that have a gallery that is connected to sharepoint list.

    I want to do in the gallery view the progress bars / present progress for every service that I have.

    it is project managers screen so they will need to see the progress of every service...

     

    and the user who is filling the form is also entering from gallery and the item data is opened in other screen with edit form.

    if you need more information please ask. 

  • madlad Profile Picture
    madlad 2,637 on at
    Re: Progress bars per service

    To start, you likely can run this function at the app's start, and you'll likely want to rerun it, or at least update the collection, every time you'll be changing an item on the Sharepoint List. 

     

    In this collection, the progress is stored for each record. To find the progress for any one record, you'll want to use a LookUp function - note I stored the item's title  as well(and this could be expanded to store ID, ect. ), and then you could find the # of completed questions for that record. 

     

    To get into more specifics I would need some more details on how the app and data functions specifically. 

  • lidor_dayan Profile Picture
    lidor_dayan 192 on at
    Re: Progress bars per service

    Hi @madlad,

    Where do I need to put this formula?

    And how do I extract the count to column?

     

    Thank you for your help!

  • Verified answer
    madlad Profile Picture
    madlad 2,637 on at
    Re: Progress bars per service

    Hi!

     

    As I understand, you need to go through a SP list, and check which columns have answers, and which don't, and then you want that value compared to the total  number of questions? If it's not like this and I'm misunderstanding please let me know.

     

    Assuming your table is set up like this, you could do something like:

     

    ClearCollect(
     completionProgresses, 
     ForAll(
     *YourTable*, 
     {
     Title: ThisRecord.Title,
     Count:
     CountIf(
     [
     {completed: IsBlank(ThisRecord.Q1)}, 
     {completed: IsBlank(ThisRecord.Q2)},
     {completed: IsBlank(ThisRecord.Q3)},
     ect.
     ], 
     completed
     )
     }
     )
    )

     

    This will create a collection which will have the title and count of each question column which does not contain a blank value (no answer). You'll just have to swap in your own datasource and column names here.

     

    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard