Unanswered

Filtering of Information for Viewing

(0) Share

Report

Posted on by Signified

Hi I need some help I am creating a PowerApps visualization and I can't seem to make someone's list appear in PowerApps.

I am using a Data table from SharePoint to pull information. Is my formula correct or is there something I need to add?

If(IsBlank(TextInput1.Text),
Sort(
Filter('CRP Knowledge Management Tracker', TextInput1.Text in 'Program Code', Substitute(varUser, " ", "") in Substitute("Lead_x0020_CRP", " ", "")),
'Program Code',SortOrder.Ascending
),
Sort(
Filter('CRP Knowledge Management Tracker', TextInput1.Text in 'Program Code'),
'Program Code',SortOrder.Ascending
)
)

I need to make all of John Doe's information the default view whenever he logs-in and still has the ability to search other people's item when he types in the search bar.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Rahman1005 109 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Please refer below article based on logging user display view.
https://davidlozzi.com/2018/11/08/creating-a-user-friendly-sharepoint-view-using-powerapps/

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Signified

can you try this please:

If( IsBlank(TextInput1.Text), Sort( Filter( 'CRP Knowledge Management Tracker', If( varUser = "John Doe", Substitute("Lead_x0020_CRP", " ", "") = Substitute(varUser, " ", ""), TextInput1.Text in 'Program Code' ) ), 'Program Code', SortOrder.Ascending ), Sort( Filter( 'CRP Knowledge Management Tracker', TextInput1.Text in 'Program Code' ), 'Program Code', SortOrder.Ascending ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Signified 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry it didn't work all it did was show entries including Jane Doe

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey @Signified

sorry i copied the wrong text, the first one was hard coded with Jane Doe.

try this instead:

If( IsBlank(TextInput1.Text), Sort( Filter( 'CRP Knowledge Management Tracker', If( !IsBlank(varUser), Substitute("Lead_x0020_CRP", " ", "") = Substitute(User().Email, " ", ""), true ) ), 'Program Code', SortOrder.Ascending ), Sort( Filter( 'CRP Knowledge Management Tracker', TextInput1.Text in 'Program Code' ), 'Program Code', SortOrder.Ascending ) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Signified 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm sorry it still doesn't work. It still won't show entries made only by John Doe

Was this reply helpful? Yes No