Filter data source and return last record

(0) Share

Report

Posted on by julijazas

820

I have a Dataverse as a datasource

What i want to do in a canvas app text field i want to filter the datasource table where ColumnName=comobox.selected.value and

then return to this combobox last submited particular column record.

For finding the last this works but i want to be sure it is the last on the particular selected project number that user is working

First(FirstN(Sort(Components,'Created On' Descending),1)).'Component Name'

But as told i want to combine it with Filtering datasource with this filter(This filters my gallery)

Filter(Components,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektas.Selected.'Projekto pavadinimas)

How do i combine these together?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
You can try using below formula
First(FirstN(Sort(Filter(Components,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektas.Selected.'Projekto pavadinimas),'Created On' Descending),1)).'Component Name'

Was this reply helpful? Yes No
Verified answer

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jja , you need the following:

First(FirstN(Sort(Filter(Components,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektas.Selected.'Projekto pavadinimas),'Created On' Descending),1)).'Component Name'

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(1)

Report
Copy link

Link copied!

@phipps0218 @NandiniBhagya20
Absolutelly love you guys!

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@phipps0218 @NandiniBhagya20
I got happy too early...

How should i now Patch a dataverse lookup field with this filtered last value?

Now my original Patch where i patch last gallery item looks like this:
Medžiaga:LookUp(Materials,Pavadinimas=Last(galleryGrid.AllItems).Medžiaga.Pavadinimas),
And i need to replace to patch last filtered record:
First(FirstN(Sort(Filter(Components,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektas.Selected.'Projekto pavadinimas'),'Created On',Descending),1)).Medžiaga.Pavadinimas
If i just replace after = it doesnt work

Was this reply helpful? Yes No
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Try replacing it with below -
Last(FirstN(Sort(Filter(Components,'Projekto nuoroda'.'Projekto pavadinimas'=FilterProjektas.Selected.'Projekto pavadinimas'),'Created On',Descending),1)).Medžiaga.Pavadinimas

Was this reply helpful? Yes No
julijazas 820 on at

Like
a
(0)

Report
Copy link

Link copied!

@NandiniBhagya20
I have error if i just replace 1:1

Was this reply helpful? Yes No