You’re offline. This is a read only version of the page.
6
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.
Hi,
Send me error details.
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
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
