Unanswered

power app filter

(0) Share

Report

Posted on by noor12

how could I use the nnn table value to filter each of these values and get the result of each of these value's sprite? and for each of these values may I get more than one row I need to select only the first desc row order by ThisRecord.TRANSACTION_DATE,
SortOrder.Descending

Categories:

Building Power Apps

All responses (14)

Answers (0)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @noor12

I create some test data in my side , you can refer to:

ClearCollect(nnn , {BILL_PROFILE_NUM : "BILL01"},{BILL_PROFILE_NUM : "BILL02"},{BILL_PROFILE_NUM : "BILL03"});

ClearCollect(FinanceView , {TRANSACTION_DATE:Date(2024,4,20),Count:1,BILL : "BILL01"},{TRANSACTION_DATE:Date(2024,4,22),Count:2,BILL : "BILL01"},{TRANSACTION_DATE:Date(2024,4,18),Count:3,BILL : "BILL01"},{TRANSACTION_DATE:Date(2024,4,25),Count:4,BILL : "BILL02"},

{TRANSACTION_DATE:Date(2024,4,20),Count:5,BILL : "BILL03"},{TRANSACTION_DATE:Date(2024,4,1),Count:1,BILL : "BILL03"});

Set(TestData , Ungroup( AddColumns(nnn , FilteredViewTable , Table( First( SortByColumns( Filter(FinanceView , ThisRecord.BILL = BILL_PROFILE_NUM) ,"TRANSACTION_DATE",SortOrder.Descending) ) )) ,FilteredViewTable) );

The end result is as follows:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
noor12 on at

Like
a
(0)

Report
Copy link

Link copied!

I think it is work but I get a blank column
VishalJhaveri 1,169 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Filter( Tablename, ColumnName1 = "FilterValue" && ColumnName2 = "FilterValue2" )
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @noor12

Thanks for your response! Can you show me your xxxx_VIEW Table in your side? Dose it contains the same "BILL_PROFILE_NUM" in your nnn table?

And dose your xxxx_VIEW Table contains these columns data?

Best Regards,

Yueyun Zhang
noor12 on at

Like
a
(0)

Report
Copy link

Link copied!

yes the xxxx_VIEW continues all the nnn BILL_PROFILE_NUM and more, I need only to show the nnn

and the xxxx_VIEW continues all theses column.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @noor12

Thanks for your response!

Or can you try to use this code if it can return code?

Set(TestData2 , Filter( xxxx_VIEW ,BILL_PROFILE_ID in nnn ))

If this can not get the data in your side,Can you show the flow configuration in your side to get the nnn table in your side?

Best Regards,

Yueyun Zhang
noor12 on at

Like
a
(0)

Report
Copy link

Link copied!

it is not working.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @noor12

I test it in my side , it can work , and this is not the error , it is the delegation warning.

And what is your Datasource in your side?

Can you try to use this code:

Set(TestData2 , Filter(xxxView ,BILL_PROFILE_ID in Concat(nnn,BILL_PROFILE_NUM,",") ));

Best Regards,

Yueyun Zhang
noor12 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the Set variable you shared and it wasn't work, so I tried to add the filter in the gallery and as you see nothing was happen.
however, I tried to add one value only and then the filter applied.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @noor12

Thanks for your response! How many rows in your xxx_View Table in your side? This may be caused by the delegation. And what's your data source?

If you have less than 2000 , you can update the data limit to 2000.

Best Regards,

Yueyun Zhang