Lookup column in SharePoint to link with Form and related Data using Table

(1) Share

Report

Posted on by schithambaran

138

Good Day!!

A Form created to display the Invoices ( Invoice List) and corelated data stored in seperate List( Invoice sub items). Refer the below form and Table.

Lookup columns created in both SharePoint Lists. "Summary of Invoices" & Invoice ID. How to display the respective data in Invoice Sub Items table with respect to the Invoices displayed in the form.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (7)

Answers (0)

Sort by

NA-31100700-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

To filter the Invoice Sub Items based on the selected invoice and bind it to your gallery, you can use the following formula:

Filter('Invoice Sub Items', InvoiceID.Id = YourFormControl.Selected.Id)

Replace YourFormControl with the actual name of your form's invoice id control. This will ensure that only the sub-items related to the selected invoice appear in the gallery.

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi schithambaran,

Looks like you are using the Data Table control to display the Sub Items, use the following code in the Items property:

With( {Records: 'Invoice sub items'}, Filter( Records, lookupColumn.Id = LookUp( //Modify to include the right lookup column and //update the LookUp part with form Item property (for e.g. Gallery.Selected.ID) Invoice List, ID = 1 ).ID ) )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi schithambaran,

Looks like you are using the Data Table control to display the Sub Items, use the following code in the Items property:

With( {Records: 'Invoice sub items'}, Filter( Records, lookupColumn.Id = LookUp( //Modify to include the right lookup column and //update the LookUp part with form Item property (for e.g. Gallery.Selected.ID) Invoice List, ID = 1 ).ID ) )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
schithambaran 138 on at

Like (0)

Report
Copy link

Link copied!

Hi Nandit

Good Day!!

Thank you so much for the response.

Refer the below snapshot.

Summary of Invoices Lookup column in MSInvoicesList referring MSinvoiceSubItems List -> Invoice ID. can you pls guide me the coding.

Gallery created with a Table to display the MSInvoiceSubItems List details.

Was this reply helpful? Yes No
schithambaran 138 on at

Like (0)

Report
Copy link

Link copied!

Hi

Drafted the coding as per the below. But still showing error. Appreciate your help.

With(

{Records:MSInvoicesSubItems},

Filter(

Records,

SOI.Id = LookUp(MSInvoiceSubItemsTable.Selected.ID, MSInvoice,ID=1

).ID

)

)

Was this reply helpful? Yes No
schithambaran 138 on at

Like (0)

Report
Copy link

Link copied!

Hi Good Day!!

Appreciate your assistance.

A Home page created to display the invoices. Once click on the Individual invoice it will redirect to another form (Refer the below snapshot)

In the below form Invoice details will display. Once we select the Summary of invoices, the below table should display with subitems of the invoices. Please assit.

Was this reply helpful? Yes No
schithambaran 138 on at

Like (0)

Report
Copy link

Link copied!

@Nandit

Hi

Drafted the coding as per the below. But still showing error. Appreciate your help.

With(

  {Records:MSInvoicesSubItems},

  Filter(

Records,

SOI.Id = LookUp(MSInvoiceSubItemsTable.Selected.ID, MSInvoice,ID=1

  ).ID

)

)

Was this reply helpful? Yes No