web

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

News and Announcements icon

Power Platform CommunityForums Power Apps in textinput Filter wh...

Power Apps

Answered

in textinput Filter which brand's maximum has total value in the same ID

(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 (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-mingkz-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @sinanaalmac111,
Do you want to display the Brand whose Total is greatest at the same ID?
You can use group by and add column function to create a collection.
Set the onselect property of button:
ClearCollect(collection,AddColumns(GroupBy(Filter('0726',Title = 32),"brand","TotalItems"),"Sum",Sum(TotalItems,Total)))
Set the text property of TextLabel as:
First(SortByColumns(collection,"Sum",SortOrder.Descending)).brand

Best Regards,
Kyrie
sinanaalmac111 117 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi there @v-mingkz-msft .Thank you. I applied your solution it is working on one of pages and its SharePoint list
But on the other page, I get This warning and it does not update the collection

It only shows warning - this predicate is a literal warning and not reference the input table.

Join the conversation