web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Make Filter which bran...

Power Apps

Answered

Make Filter which brand's maximum has total value in the same ID in the SharePoint list.

(0) Share

Report

Report

Posted on by sinanaalmac111

117

Hello All,

In the data below, there is the LineItems Sharepoint list. I can display all fields in a form, by placing a "Textinput" in an external field.
I want to calculate the Maximum total price value by BRAND. But I write down the text input which brand has the maximum value

the SharePoint list here

Here are my example Result for ID=32

Brand "Corn" Total's = 67,86 AND Brand "Mar" Total = 59,82 in the same ID.
TextIput1 or Label1 value must be shown as 'CORN'

I tried this one but I couldn't find any solution

Sum(Filter(LineItems,ReportID.Id in OpenReports.ID & openRepots.Brand=MAX))

Please help me and Thank you

Regards Sinan

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sinanaalmac111,

Could you please tell me:

1). What is the column type of the Id in LineItems? LookUp type? If not, then what?

2). What is ReportID and openRepots?

Currently, I just assume that I know the Id is 32, and I will filter LineItems based on Id 32 and Brand category 'CORN'.

Sum(Filter(LineItems,Id=32&&Brand="MAR"))

Join the conversation