Filter for LineItems for filtering ID in expenses app

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

@StalinPonnusamy ,

Hi all, hope you are doing well,

I'm working on expenses app, I tried using

(Filter(LineItems,ID=SelectedLineItems.ID))

for filtering ID (Report ID) from LineItems list, but it is not working looking for solution.

The filter should be capable of showing all Lineitems under same ID.

Kindly help me get solution for the above problem.

Thank you,

Monisha

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

What is your Datasource? And, if SharePoint, then the ID column value will be unique to each record and your results would only be one record (if at all).

You should have a column in your LineItems table that stores the ID of the ReportID from the parent record.

I hope this is helpful for you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

My data source is Sharepoint list, and it have unique report ID
For example, all lineitems in Report ID 42 should be displaying for that filter?
looking forward for the solution

Thank you,
Monisha

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
HI @Anonymous

Need to filter the ReportID which has a lookup to master SP list

Filter(LineItems, ReportID.Id = SelectedReport.ID)

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

So then your formula needs to be:

Filter(LineItems, ReportID =SelectedLineItems.ID)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy, @RandyHayes ,

Thank you very much for the above response.
I get similar error with both the codes,
Filter(LineItems, ReportID =SelectedLineItems.ID)

Filter(LineItems, ReportID = SelectedReport.ID)

Looking forward for the solution.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

What kind of column is ReportID ?

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
We assume you are filtering lineitems based on the master (Another SP selected item). And Parent is a single selection.

Filter(LineItems, ReportID.Id = SelectedReport.ID)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RandyHayes ,

Report ID, is a column from Line Items SP list which contains lookup with expenses SP list.

Thank you,
Monisha

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous

I would avoid a lookup column in this case as you only need the numeric column to store the ID.

But, your formula would be:

Filter(LineItems, ReportID.Id =SelectedReport.ID)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy ,

Thank you very much, it is working fine but getting delegation warning sir.

Was this reply helpful? Yes No