Hello Everyone,
I have two SharePoint list,
Invoices, that have these columns:
- Invoice Number
- Invoice Date
- Vendor
- Billing Entity
- Gross Amount
- GST
- Net Amount
Invoice Line Item, which has:
- Invoice Number (Title)
- Description
- Quantity
- Unit Price
- Total Amount
I made a gallery (Invoices SP List) which when one invoice is selected, it will show the View form of that Invoice.
The DataSource of the View Form is the Invoices SP List.
My problem is I don't know how to show the Line items of that particular Invoice.
I tried adding a blank card which has a gallery (Line-Gallery).
I've set the Item property of the Line-Gallery as below:
Lookup (Invoice Line Item', Title = Line-Gallery. Selected.' Invoice Number')
This do show some data, but only one line.
Some of the Invoice have 2 or more lines and the other lines are not showing.
Thank you for helping out!!
