Unanswered

Finding Maximum Values Then Incrementing for Multiple Columns From a Sharepoint List

(0) Share

Report

Posted on by JubJub

Hello

I am currently trying to design a Sharepoint list for work permits in tandem with a Power Automate workflow. I have been trying to get a simple workflow to generate a unique value that is the highest value in the column + 1. For example I am making a new entry and the last permit number was #1002 so when I create a new entry the permit number will be #1003.

Here is the tricky part, I have different types of permits that all need to have serial numbers constantly having the maximum value generated. So I may have one entry in the list that generates the number work permit while also generating one for a special shutdown permit. Every way that i go about it just becomes an overcomplicated mess.

below are some snippets to help illustrate my problem.

I keep running into problems with data types. what is the simplest way to find the maximum value from a dynamic array variable. I can't use the order by descending then only take the first entry since I will have to search through multiple columns and not every single entry is consecutive from the last entry. I need to be able to define a variable then use the max() expression.

I would be grateful for any insight from anyone experienced with power automate.

Categories:

Building flows

All responses (2)

Answers (0)

Sort by

Unknown geen idee 1,757 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear JubJub,

I am not sure if this is the most elegant solution, but you may want to try and make it work.
What if you create another list/table seperately to hold the permit numbers.
In a seperate flow you access this number list and calculate the new number which you use in your permit list.
The key is that this seperate flow (while called from your main flow) has a concurrency setting ... it does not allow the flow to run for only 1 instance, thereby eliminating the possibility of generating multiple numbers at the same time (each wait their turn).

Alternatively, if you could change the format of your permit numbers, I would just take a Utc(Now) value and use the digits in this as your unique and increasing permit number.

Hope my logic makes sense and it works out for you.
Happy flowing,
Koen
JubJub 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Koen,

This will likely be the way I will have to execute the logic but it just seems strange to me that I can't find the max value in a column, similar to an excel spreadsheet where a cell value =Max(WP10register[Serial Number])+1.

It just seems like there is a way to be able to convert my data into a format that workflow can then use the max expression on, then increment by 1. If it turns out there is no way to accomplish it, then what you described will be my method.

Unfortunately I am not able to change the format of the permit number as the system is active with a long history but I agree that would make the process a bit simpler.

Thanks for the response.