Unanswered

Display list item Only if there isn't a matching ID in the list.

(0) Share

Report

Posted on by shaunloureiro

So i have a display page that shows server status. The list is pulling from a SharePoint data list. There are two types of options in the list. A "Problem" and "Resolved". Each problem item has an ID and the same goes for the Resolved. So if a problem is added to the list it will have the ID of "1234" and once the resolved for that problem comes in it also contains the same ID "1234". Its just saying that the Problem has been resolved.

Now i don't want to have every single problem and solution showing. How would i go about showing only the problems from the list if the problem hasn't been resolved. So pretty much "How would i display the problems that don't have a matching ID?"

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (25)

Answers (0)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Are resolved and problem two separate entities or are they just 2 fields in the same entity?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Was this reply helpful? Yes No
shaunloureiro 35 on at

Like (0)

Report

Yes they are two separate entries in the Sharepoint list. So the problem will always come before the resolved comes in. So i want to show the problem and when the solution comes into the list with the same matching ID, i want the problem to not be show. I attached an image. The problem ID is what i want to check.

DATA LIST.JPG

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

So your gallery of Problems should have the following items property

Filter(Problems, IsBlank(Lookup(Resolutions, Problem_ID = Problem_ID)

Replace the first Problem_ID with the column name for Problem in your Resolution entity and it should work for you. Let me know if it doesn't with the error you see so I cam help you get to the right answer.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Was this reply helpful? Yes No
shaunloureiro 35 on at

Like (0)

Report

Thank you for the quick response!
I have added another screenshot with a bit more information showing. The Problem and Resolved items come into the same list.
So if there is any items in the list that have the same Problem_ID then they must not be shown.

DATA LIST.JPG

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (1)

Report

Got it.

Change your items property of the Problems entity to something like this:

Filter(Problems, IsBlank(Lookup(Problems, Problem_ID = Problem_ID && StartsWith(Subject, "Resolved"))))

Let me know if it doesn't work and the error you get.

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Was this reply helpful? Yes No
shaunloureiro 35 on at

Like (0)

Report

I think that might have done it!!
Thank you so much for your help! 🙂 I need to do some testing now to check that it all works properly.

Thanks again!

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Awesome, glad I could help! If my reply solved your problem, please give kudos and accept it as the solution. Thanks!

Hardit(Haman)

Was this reply helpful? Yes No
shaunloureiro 35 on at

Like (0)

Report

@PowerAddict Unfortunately i am still getting some errors and it isn't working as expected. The list keep showing a random amount of items from the list. I have added some screen shots. 😞

formula.JPG

issue.JPG

Was this reply helpful? Yes No
shaunloureiro 35 on at

Like (0)

Report

Anyone got any ideas on how to make this work please?

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report

Did you use the suggested formula? If not, why are you using Lookup? What is the exact desired result?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit(Haman)

Was this reply helpful? Yes No