Filtering in DisplayMode

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I had done a poor job of phrasing my question here:

Re: Using the results of Filter - Power Platform Community (microsoft.com)

So I am going to try again with my lessons learned.

I have a bunch of Text Input boxes in a form I have created in Power Apps. This form is getting its information from a SharePoint list called Accomplishments.

In the DisplayMode, I need to do a search through every row in the SPList to see if specific fields have any content, who made the row, and what date the row was made. Lookup is not doing the job as it stops when it finds any row that matches. (The first match may not be the right choice, trust me)

Can I use Filter in the DisplayMode of a Text Input box? I want to set DisplayMode to either View or Edit, depending on what I find using the filter.

If I can, how do I take the table created in memory and pick out key fields w/o throwing the table in a gallery. I cannot find anything about how to use Filter except when filling a Gallery.

Frank D. Puthuff
Dell Technology

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Can you provide an example formula of what you are trying to do? It is hard to discern what it is that you are trying to compare. And, more importantly, what about LookUp causes grief?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Yes...I can get one of those for you, and explain why I think LookUp is failing. I'll do that when I have a bigger time window.

But, you have not addressed my actual question this time around. Can filter be used as described above?

If LookUp turns out to be the better choice, I can go with it, but I'd like to know my options with filter too.
Frank D. Puthuff
Dell Technology
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
This is a version of the code I'm playing with:

If(
LookUp(
Accomplishments,
IsToday(Date),
IsBlank(GSEP_RITM_DBR_Complete) And IsBlank(GSEP_RITM_DBR_Rework)
),
DisplayMode.Edit,
If (
User().FullName = LookUp(
Accomplishments,
IsToday(Date) && !IsBlank(GSEP_RITM_DBR_Rework Or GSEP_RITM_DBR_Complete),
User_Name
),
DisplayMode.Edit,
DisplayMode.View
)
)

If there is a record w/ today's date and both circled boxes are blank or zero, the outline of the text box should be visible. Like here:

.
If there is a record with today's date, Current_User is the same as whomever is using the app currently, and either of the boxes in question have a number above zero. The boxes are editable and the Update Button shows up. Like here:

.

If there is a record with today's date, Current_User is NOT the same as whomever is using the app currently, and either of the boxes in question have a number above zero. The boxes should be viewable. Meaning no outline around the number. NOT like here:

Why does the third one still choose true?
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
I have found my solution. Instead of looking for all the true cases, I just need to look for the one false case.

If (
LookUp(
Accomplishments,
IsToday(Date),
!IsBlank(GSEP_CHG_EFS_Complete || GSEP_CHG_EFS_Failed) And User_Name <> User().FullName
),
DisplayMode.View,
DisplayMode.Edit
)
BOOM...Easy Peasy

Frank D. Puthuff
Dell Technology
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Glad you found it. Sorry you were still on my radar to reply to, but had a long list ahead of you for it.