Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Under review by Community Managers

Under review

Thank you for your post! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

How to show Line Items data in View Form Invoice

Posted on by 75

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!!

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard