Modern Control Table not showing data

(0) Share

Report

Posted on by Seth18

146

Hello PAC,

I'm using a modern control table where I want to display items from the Invoice Master SharePoint list. Specifically, I'm trying to filter the list so that it only shows records where the 'Request ID' (a single line of text field in Invoice Master) matches the ID (a number) from a different SharePoint list.

Here's the formula I'm currently using:

Filter(

'Invoice Master',

'Request ID' = DataCardValue70.Value

)

This formula works perfectly in a Gallery—it shows only the records linked to the selected ID. However, when I use the same formula in a modern control table, no data appears.

I want the modern table to only display items from Invoice Master that are linked to the currently selected request ID from the other SharePoint list. Could you help me understand why it's not working in the modern control?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Seth18 Hi，

You said Request ID' (a single line of text field in Invoice Master) matches the ID (a number).

Then please try this first.

Filter( 'Invoice Master', Value('Request ID') = DataCardValue70.Value )

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Seth18,

I replicated the same logic by adding text input control and gallery and table control.

Gallery :

If(IsBlank(TextInput1.Text),Test, Filter(Test,Title=TextInput1.Text))

Table

// Same formula

If(IsBlank(TextInput1.Text),Test, Filter(Test,Title=TextInput1.Text))

I created one label and checking whether it returning any rows or not to ensure my query is right.

I didn't experience issue like you stating, may i know why you used datacard and all are u using the form ?

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
Seth18 146 on at

Like (0)

Report
Copy link

Link copied!

hi stampcoin,

I tried your method but it still not working.

Was this reply helpful? Yes No
Seth18 146 on at

Like (0)

Report
Copy link

Link copied!

Hi MS.Ragavendar,

what i meant is this as below this is the old used way where this sharepoint contain only the basic info.

and when moving to the invoice screen as below once the user create the invoices and save the invoice (which is submitting the form) then i used the code on item as below

Filter(

'Invoice Master',

'Request ID' = DataCardValue10.Text

) (Datacardvalue10 here is the ID from the first screen)

Then i wanted to change to the modern control table as i mentioned above in which it not showing the data.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Seth18,

Based on understanding, I am sharing this suggestion revert me it doesnt work for you.

Inside the form, i am getting the last item Id of submitted records and setting to the global variable.

In the Items property

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

Was this reply helpful? Yes No
MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Seth18,

Did u sort it out or still looking for any challenge in the implementation?

Was this reply helpful? Yes No
Seth18 146 on at

Like (0)

Report
Copy link

Link copied!

Hi MS.Ragavendar,

I tried your proposed but it not working as well

Was this reply helpful? Yes No
MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Seth18,

Can you please help us with the schema and detailed approach which you tried, so that we can able to replicate it from our end and proposed solution accordingly.

Was this reply helpful? Yes No