Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
Back to discussions
Expand all | Collapse all

get first record of list rows from Excel

  • 1.  get first record of list rows from Excel

    Posted Sep 20, 2022 07:28 AM
    Hi Everyone,
    i have a Excel table with one row and i would like to get the value of the 'Total' column :


    i created a listrows action (thats workf fine) and i added a compose action, but my code is wrong (he returns the same text value) :

    @body('ListRows')?['value'].[0]?['Total']



    This is my JSON return :

    Do you know whats wrong in my input compose ?

    Thanks

    ------------------------------
    LAURENT SANCHEZ
    Formateur Consultant
    laurent@sanchezconsultant.com
    LE HAVRE
    662527022
    ------------------------------