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?"
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.
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.
@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. 😞
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.