Hi @CU10030357-0,
Here is what you can do:
1. Execute ETL steps as usual. At the end, set a variable to grab the status say, etlStatus = "Success" or "Failed" (as you maintain)
2. Go for a condition check, add If block, If etlStatus = "Failed", proceed to error extraction (happy path for your case), Else, end the flow or send a success notification (your choice).
3. Let's do the error extraction . Use Launch Excel (with or without instance visibility). Use Read from Excel worksheet → store into a DataTable variable (e.g., etlResultTable).
4. Let's use Filter Data Table action, Input: etlResultTable, Condition: Column[Status] = "ERROR", Output: ErrorRowsTable, at this point you have only the rows with "ERROR".
5.Let's format extract rows: Employe For Each loop through ErrorRowsTable, build a string variable to store summary say errorSummary, concatenating row details (UniqueID, Message etc. what ever you need).
Set Variable errorSummary = ErrorSummary & CurrentItem["UniqueId"] & " - " & CurrentItem["Message"] & NewLine
6. Now bring action for sending email, Send Email (may be vai Outlook connector or call cloud flow), embed errorSummary in the email body. Optionally, you can attach the Excel file too.
Please let me know if these steps help?
I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!
