Answered

Filter Canvas app list unique varilable

(0) Share

Report

Posted on by Ben_C

I have two canvas app list gallery which pulls from a SharePoint list of messages between project team and clients. the first filters the list depending on the current user like this:

Filter('Source', AssignedUser.Email = User().Email)

If the client replies I have set the app to create a new list item for further messages from the project team.

I'm attempting to get the list second gallery item to filter the assigned users column but only list the new reply list items.

Filter('Source List', AssignedUser.Email = User().Email || Not(IsBlank(ReplyID))

However this as expected brings back all items assigned to the user, regardless if it is a first response or a follow on response.

Any suggestions would be most helpfull.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Ben_C ,

It is not clear from your post how you identify the "follow on response", but if you want the latest response

LookUp( Sort( 'Source List', ID, Descending ), AssignedUser.Email = User().Email || !(IsBlank(ReplyID)) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Ben_C on at

Like (0)

Report

Hi @WarrenBelz, sorry I forgot to mention I have a lookup column to the client reply list which looks up the ID pof the reply. The second response list item is created when the client submits a reply and that lookup column is populated.

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @Ben_C ,

So is that still not the newest response? If not what attributes will it have? Also I suggest you think hard about using Lookup columns - they are generally not needed and will cause you more unnecessary grief than you need.

Was this reply helpful? Yes No
Ben_C on at

Like (0)

Report
I've just realised I have used the wrong operator. I don't want OR I wanted to use AND.

Filter('Source', AssignedUser.Email = User().Email && Not(IsBlank(ReplyID.Value)))

This still dosen't bring back just the current replies however.

---EDIT---

Also realised that the test data I was using wasn't assigned to anyone. So it was working afterall.

Was this reply helpful? Yes No