You’re offline. This is a read only version of the page.
Announcements
Hi!
I am building a flow where email received in outlook inbox, triggers the flow that would find last row with populated information in Excel Table1 and would add it as new row in Table 2. I tried to search for last row using "List rows present.."+ compose action (last(body("List_rows_present_")). This technically should find last row in Excel table 1. However, when i use action "Add a row" for Excel table 2, it asks me to populate arguments for each column in Excel table 2. I was wondering how i can map values found in last row of Excel table 1 to specific columns in Excel table 2?
Hi @rosszhuk
Pls use expression to get the column value. Here is an example, if the column name is 'Employee Name' then the expression to get the value of that column is:
Share
Report
All responses (
Answers (
15,091
outputs('Compose')?['Employee Name']
likewise, you can get the value of other columns using expression: outputs('Compose')?['<column name>']
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
