cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Report the stage of a process by checking if a date has been entered

Hi,

My app records and reports where an item of work is within a process.  The data is held in a SP list with the process stages as separate columns in date format.  There are 10 such stages.  The idea is that when a work item gets to a stage of the process the operator enters the date and this updates the SP list.

I want to return the current stage for the selected record which is in a gallery.  My logic is that if I start from the end and work backwards, the first column with a date populated is the current stage.

 

So, something like If(!isblank(My_SPList.'Stage10'),"Stage10","") and then repeat that tests for each of the other stages.

 

I have 2 questions:

  1. How do I ensure I am looking at the selected record?  Gallery1.Selected?
  2. Is there a neater way of checking which stage column is the last one with a date in it.

Many thanks for taking your time to look at this.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Gallery1.Selected would give you the context of the record selected in that Gallery. You can can then reference values from that record.

 

As far as checking the values, there probably isn't a significantly cleaner approach, given the data is denormalized and stored in columns.

 

Since it's SharePoint, you could technically add a column there which calculates and returns a stage value, as a new SP column. This way, it's an actual data point on the row/in SharePoint and is consistent where ever you reference it, without having to resort to constantly evaluating it.

 

You'll then be able to easily filter, sort, etc. without as many delegation errors or needing to emulate the value.

View solution in original post

2 REPLIES 2
Super User II
Super User II

Gallery1.Selected would give you the context of the record selected in that Gallery. You can can then reference values from that record.

 

As far as checking the values, there probably isn't a significantly cleaner approach, given the data is denormalized and stored in columns.

 

Since it's SharePoint, you could technically add a column there which calculates and returns a stage value, as a new SP column. This way, it's an actual data point on the row/in SharePoint and is consistent where ever you reference it, without having to resort to constantly evaluating it.

 

You'll then be able to easily filter, sort, etc. without as many delegation errors or needing to emulate the value.

View solution in original post

Thanks,

I will take a different approach and report the stage reached through a Power BI report.  Movement through the process is not rapid and so the slight delay in refreshing a Power BI report should not materially impact the usefulness of the data.

 

Thank you for taking the time to read and respond.

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (24,443)