Power Platform Community Forum Thread Details

How to structure the information tables

Hi,

I'm trying to figure out a way to extract the information shown in the screenshot attached. The problem is that a document could have 20/30+ invoices on it. I was considering creating a table for Invoice 1, 2, 3 etc but I dont know if that would work well. I want to pull the information in to a table like the below. I've covered the Schedule# but have included a random number in the table as an example.

What would be the best way to go about this. When i could have 2 or 3 pages of these small invoice summary tables with multiple schedules on each coming through?

INVOICE #	DATE	SCHEDULE #	DESC	REBAR WEIGHT	REBAR VALUE	MESH WEIGHT	MESH AREA	MESH VALUE	SUNDRY VALUE	DEL CHG	TOTAL
143516	27/10/2023	1	ZONE 1 - FIRE STAIR	10641.6	$20217.85	0.0	0.0	0	0.0	600	$20217.85
143892	9/11/2023	2	ZONE 1 -EASTERN	7511.2	$14270.55	0.0	0.0	0	0.0	600	$14270.55
143962	9/11/2023	3	SITE REQUEST	1267.9	$2400.23	0	0	0	0	600	$12400.23
143962	9/11/2023	4	ADDITIONAL	352.3	$666.90	0	0	0	0	600	$666.90
143962	9/11/2023	5	TOWER CRANE	5294.9	$10075.62	0	0	0	0	600	$10075.62