Hi,
I am creating a flow that is trying to do convert data from an invoice and populate an excel sheet saved on Sharepoint.
- It triggers when an invoice PDF is saved to a Sharepoint folder
- An AI Model analyses the file and outputs certain fields to an excel sheet
The AI Model is working as expected and is detecting the fields that I require. Amongst these fields is a table that contains 3 columns.
An example of the table is below:
The issue I am facing is the flow is creating multiple rows for each invoice. For example, when the flow pastes the "HSN/SAC" column it, outputs as follows:
How do I get it to output only one row and exclude all the rows where the values are null?
Screenshot of my flow is below:
Thanks for your help

Report
All responses (
Answers (