Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Purchase Order Display in Datatable from Collections


I have googled this requirment from numerous link where i could not get proper response. Thought of  sharing here for the better knowledge gaining from the Power Apps Community Team.

My requirement is to populate the purchase order line items in to the datatable .

I have collections from flow where json schema is calling from API.


1.Button for collecting the data from flow using power automate. Clear collect formula follows.


2. Inputbox for PO entry. Screenshot below. Based on the PO search poline item will be displayed in datatable.



Now datatable

Pointer 1 Datasource is collection name . Pointer 2  is the PO line items is aggregated instead of individual line items.



To bring all the line items do we need enter any items formula in data table or in datatable polines column any formula required ThisItem.


Guidance is well apprecated.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,530)