Answered

Get data from List rows present in a table from previous step

(1) Share

Report

Posted on by htrieu2

Hello,

I have one flow which would like to compare the two excel file and then sent an email to assigned users. The flow as below image:

In the condition, I would like to compare the data from table 1 and table 2. For table 2, it's fine to select the items. However, I cannot select items from table 1. I tried to used the expession outputs('List_rows_present_in_a_table_1')?['body/value/COLUMN NAME'] and outputs('List_rows_present_in_a_table_1')?['body/COLUMN_NAME'] but look like the string return is empty. I think it's not correct. I tried to search on our forum but not see the solution yet. Could anyone help me to have some recommend?

Thank a lot.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

sandeepstw 312 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi THere,

You need to ensure that you're referencing the correct path to the data within the output object. After the 'List rows present in a table' action for table 1, add a "Compose" action and use the expression 'outputs('List_rows_present_in_a_table_1')?['body/value']' . This will allow you to see the full output structure in the run history. un the flow and inspect the result of the "Compose" action in the flow's run history. This will give you the exact path to the column you want to compare. Update expression with correct path.

Please give kudos and mark as solution if it helps.

Thanks,
Sandeep Mishra

Was this reply helpful? Yes No
htrieu2 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you Sandeep. However, It's not work for me. It's show errors when get the results in the compose step.

Was this reply helpful? Yes No
sandeepstw 312 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Send me error details.

Was this reply helpful? Yes No
htrieu2 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Sandeep,

Sorry for my late reply. The problem solved.

Thanks

Was this reply helpful? Yes No