Answered

How to get the last entry of each unique item from SP

(0) Share

Report

Posted on by Ycrad

Hi All,

I want to get the last record of each Tag (Only Lines with red cross at the front) and display them in a Gallery. My data are stored in a SP list.

I tried with ForAll loop but i didn't get the expected result.

Maybe someone could help me.

Thx for any help you will bring me.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I think that the only way is this:

Set(varTagsAlreadyIn, "");

ForAll(

Sort(DataSource, ID, Descending),

If(!(Tag in varTagsAlreadyIn),

//IT IS THE FIRST ONE

Set(varNewTag, varTagsAlreadyIn & " ," & Tag);

Set(varTagsAlreadyIn, varNewTag),

//IT IS NOT THE FIRST

)

I am creating 2 vars because you cant self reference in Power Apps.

You can always try with Concat or Concatenate but I am not sure how to do it

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

Buy me a coffee!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Ycrad 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you Nogueira 1306 for your response,

But it seems that Set function could not be called in ForAll function. The system returns an error and i don't know why... 😞

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Ycrad

I disagree with the approach. Much simpler without variables:
Use GroupBy(Sort(SPlist,ID,Descending),"Tag","Info") as your Items property of the gallery.
Then inside the gallery put labels with text property as "Tag", First(ThisItem.Info).Posted, First(ThisItem.Info).'Eqpt Name', etc.

Was this reply helpful? Yes No
Ycrad 9 on at

Like (0)

Report
Copy link

Link copied!

Dear Drrickryp,

Thanks a lot for your answer. That is exactly what i was looking for.

God bless U,

Thank you.

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

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Ycrad 9 on at

Like (0)

Report
Copy link

Link copied!

Drrickryp,

So, if i want to get between these unique last entries only those match with some criteria as TestStatus="Fail" or TestStatus="Succes" but DateDiff(Created;NextTest)<0 how can i Do?
My Collection is called Lune :
ClearCollect(Lune;GroupBy(Sort(Filter(TestsData;Site=CombSite_2.Selected.Title);ID;Descending);"TagEquipement";"Info"));
When i tried to get the result into another Collection called LuneResult with :
Clearcollect(LuneResult;Filter(Lune;Info.TestStatus="Fail" || (Info.TestStatus="Success" && DateDiff(Created;NextTest)))<0 ;
I don't get the expected result.

Could you help please ?

Thank you.

Was this reply helpful? Yes No