cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amitlalms
Microsoft
Microsoft

AI Builder - Form Processing where table has multiple rows.

Hi Expert, Members,


We have PDF documents extracted in form processing, model working fine with table and multiple page tables, AI Builder has successfully detected all the various fields we require, but does not appear capable of dealing with when the Form/model has more than a single item included in the table in loop while giving output. It creates multiple Email for each field and keep triggering Email for every field in For Loop. 

 

Is there a way to get it to loop through and grab the additional rows? 

 

amitlalms_0-1638921726034.png

 

 

 

Cheers, AmitL

1 ACCEPTED SOLUTION

Accepted Solutions
JoeF-MSFT
Power Apps
Power Apps

Thanks @amitlalms!

 

I think what is causing this is that you are using Table121 on the value column, try to remove it.

 

You should have:

 

Header Value
SystemIndicator Table121 Indicator value
Value Table121 Value value

 

JoeFMSFT_0-1639040584275.png

 

Keep us posted on the progress! 🙂

 

View solution in original post

7 REPLIES 7
JoeF-MSFT
Power Apps
Power Apps

Hi @amitlalms,

 

Indeed, sending an email for each row in the table can result in lots of emails! 😄

 

There's two things you can do:

 

1. If you want to display the table results in an email, you can use the Create HTML table action like this: 

* On the From input put: {name of your table} entries

* Set columns input to: Custom

* For each of the columns: {name of your table} {column} value

 

JoeFMSFT_0-1638954286195.png

 

2. You can also store the extracted values of the table in an array. In the following example I'm saving all the values for all the rows for the Amount column in my table. You can then use this array in successive actions in your flow. 

 

JoeFMSFT_1-1638954482513.png

 

I hope this helps!

Thanks for your inputs. I am trying both options, create HTML is more suitable! Just received this issue on simple non-tabled form processing entry.  Looks like Parse JSON body into this array variable is mandatory here. Please advise! 

 

amitlalms_0-1638976286719.png

 

JoeF-MSFT
Power Apps
Power Apps

Thanks for the update @amitlalms!

 

Can you share a screenshot on how you've configured the Create HTML table action?

 

  • In the From input, you should put a table. {the name of your table} entries.
  • In the Columns input, set it to Custom
  • Then define the different columns in your table. For each column, set it to {the name of your table} {the name of your column} value

 

JoeFMSFT_0-1638983698356.png

 

Thank you for your input. So far, little success, I would say...  And I was able to run and extract content in HTML but unfortunately every odata is coming in HTML

amitlalms_2-1639015059528.png

amitlalms_3-1639015155016.png

 

 

My Email output is big content , I just selected one field from table121.indicator.vaule field , 

amitlalms_4-1639015265441.png

 

 

Thanks in advance, Amit



This is my Table from PDF file - 

amitlalms_1-1639013330021.png

 

 

 

JoeF-MSFT
Power Apps
Power Apps

Thanks @amitlalms!

 

I think what is causing this is that you are using Table121 on the value column, try to remove it.

 

You should have:

 

Header Value
SystemIndicator Table121 Indicator value
Value Table121 Value value

 

JoeFMSFT_0-1639040584275.png

 

Keep us posted on the progress! 🙂

 

Thank you @JoeF-MSFT  Super helpful so far! I'm very close but unfortunately, I'm stuck in my internal subscription limitation, I wasn't noticing and observing it earlier. I'm trying to see if I can get it enabled again for re-running the flows 😞

amitlalms_0-1639066256406.png

 

Thanks @JoeF-MSFT !!!
Finally, I got it working as per your input earlier. Just closing this thread. Able to capture HTML format in tables
Now another issue, to get this on Power Apps with attachment (tricky part) , opening another thread. 

amitlalms_0-1640710754957.png

amitlalms_1-1640710818966.png

 

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,261)