Skip to main content

Notifications

Community site session details

Community site session details

Session Id : ZysZfhOfwF35q+olHLeUJN
Power Automate - Building Flows
Answered

Retrieve Dataverse row count (& use it) without "for each"

Like (1) ShareShare
ReportReport
Posted on 11 Jun 2024 21:52:13 by

I have a flow which adds a new row to a dataverse table called "Projects."

I need to populate one of the new fields in the Projects table with the next available incremental number from the column "Master Project #"

I can retrieve the max number in the column "Master Project #" by using "List Rows" and sorting by the column in descending order & using a row count of 1.

My trouble is that I then need to insert this number into the "new row" step without turning it into a "for each" step.

Is there a better way to retrieve and use the highest number in the "Master Project #" column plus one?

  • Verified answer
    BertP Profile Picture
    on 12 Jun 2024 at 21:27:22
    Re: Retrieve Dataverse row count (& use it) without "for each"

    Thank you so much @abm 

     

    After searching around, I seem to have found the right syntax, which was as follows:

    @{outputs('List_Master_Project_Number')['body']['value'][0]['cra6a_masterproject']}

     

    Thanks so much for setting me on the right path!

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 12 Jun 2024 at 08:49:41
    Re: Retrieve Dataverse row count (& use it) without "for each"

    Hi @BertP 

     

    Could you post a screenshot of your flow please? Since your using the List rows with row count 1 it will always put the loop even though it contains one record hence I suggested the expression. 

     

    Is here 'name' is your column, which is your incremental column?

     

    outputs('List_Master_Project_Number')?['body']?[0]?['name']' 

     

    You mentioned have a "for each" step because the flow ultimately will only be adding a single record/row (it depends on a single row JSON output from powerapps for adding a single row).

     

    Could you please explain the above?

     

    outputs('List_Master_Project_Number')?['body']?[0]?['here replace your incremental column']' 

     

     

    Thanks

  • BertP Profile Picture
    on 12 Jun 2024 at 00:11:41
    Re: Retrieve Dataverse row count (& use it) without "for each"

    thx @abm 

     

    I'm not sure I explained the difficulty well enough. I am trying to retrieve the max value (whole number) of the column "Master Project #" plus 1 in a way that I can use a single number output. My problem is that when I put in any references to the "List Rows" step, PA creates a "for each" step. I can't have a "for each" step because the flow ultimately will only be adding a single record/row (it depends on a single row JSON output from powerapps for adding a single row).

     

    I tried the code you had above, but receive the following error: " 'outputs('List_Master_Project_Number')?['body']?[0]?['name']' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names."

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 11 Jun 2024 at 22:58:20
    Re: Retrieve Dataverse row count (& use it) without "for each"

    Hi @BertP 

     

    Yes you can specify the index try the below

     

    image.png

     

    outputs('List_rows')?['body/value']?[0]?['name']

     

     

    Note: When you use "List Rows" and sorting by the column in descending order & using a row count of 1. This will return the latest record you created. So better to add another filter query to extend using the  incremental number column not equal to zero or something. This will give you the second last record not the very latest record. Not sure this is the logic you want but I just want to mention that and it may be helpful.

     

     

     

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 179 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 161 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 143

Overall leaderboard