Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only

get first record of list rows from Excel

  • 1.  get first record of list rows from Excel

    Posted 17 days ago
    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
    ------------------------------