Answered

Hiding list entry depending on issue status

(0) Share

Report

Posted on by MrBarnett

We Currently use a list in sharepoint to report any IT issues that arrise, when the issue is resolved, we change the status of the issue as resolved, the default setting is active.

Is there a way the I can filter the default view of the powerapp to only display the active issues as there are 1000's over the years to sift through otherwise/

thanks in advance

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

TimRohr 669 on at

Like
a
(0)

Report
Copy link

Link copied!

On any screen where you use a gallery to display the issues and you want to limit it to just those that are open, use a Filter(datasource,...) construction. For instance, if your datasource is named "ITIssues" and your field showing whether the issue has been resolved is named "Resolved", then your gallery Items property would read:

Filter(ITIssues,Resolved = false)

That would show you only the open issues. Elsewhere you could show a fuller, historic view of all issues, allowing the user to browse to an issue that had been completed.
MrBarnett 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for the response, I will continue to look at this, I have had a little look at what you suggested and I can’t seem to make it work. I am guessing that I put it in the bar at the top when on the gallery?
All I have done so far from the very beginning is to create a power app using existing data, I chose the ICT issues list and it made the app. I know very little about the app essentially so please forgive my ignorance.
When I choose browsegallery1 the app preview takes me to the ICT Issues page with all the issues on. When I have that selected, the bar along the top has this already in –
SortByColumns(Filter('ICT Issues', StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

Anything I do to that seems to break the app, nothing displays. I have changed the properties of the fields in the ICT Issues to show Title1 as Title, Subtitle1 as description and the one I changed was Body1 to be ThisItem.’Issue status’.Value so that on the front page it shows the resolved status in hope that I can only show the active ones from there, no luck yet.
TimRohr 669 on at

Like
a
(0)

Report
Copy link

Link copied!

Error of posting to the wrong thread.... let me try again...
TimRohr 669 on at

Like
a
(0)

Report
Copy link

Link copied!
If your field is named "Resolved" and it is a true/false, then you should be able to use this as the Items property of the Gallery:
SortByColumns(Filter('ICT Issues', StartsWith(Title, TextSearchBox1.Text) && Resolved = false), "Title", If(SortDescending1, Descending, Ascending))
Change is in orange.
Verified answer

v-sheyu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
hi @MrBarnett,

Can you show me the field type of issue status in the sharepoint list?

Do you want to display the acive issue in the browsegallery1?

I made a test.

I created a list named “test2”. “Column2”is choice type.

Set the items property of browsegallery1 to:

SortByColumns(Filter(test2, StartsWith(Title, TextSearchBox1.Text),column2.Value="active"), "Title", If(SortDescending1, Descending, Ascending))

regards,

eason
MrBarnett 12 on at

Like
a
(0)

Report
Copy link

Link copied!

i have tried this, but its not worked, i think it will be to do with the names of the colums etc, i need to investigate to find out that im working with the right names somehow.
MrBarnett 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Spoiler (Highlight to read)
this look promising, i have had a little go but nothing yet, i will have another look shortly and post some screen shots, i think it may be down to knowing what the coloumns are called as the ICT Issues list was made many years ago and we are just trying to take advantage of the power apps now.
this look promising, i have had a little go but nothing yet, i will have another look shortly and post some screen shots, i think it may be down to knowing what the coloumns are called as the ICT Issues list was made many years ago and we are just trying to take advantage of the power apps now.
MrBarnett 12 on at

Like
a
(0)

Report
Copy link

Link copied!

i think i am making some progress, however as there are over 2000 items in the list, i have to change the limit and delete some items on the list before i can tell if its now working
MrBarnett 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Done, after deleting a few of the items in the list and upping the limit, we now have a working filter. thanks