Answered

Filtering only records you make

(0) Share

Report

Posted on by Valentino1

111

Hey everyone, im a bit stuck, how would i make a button that when you check it, makes it so that the records shown are only your own records created?

These are the filters i currently have:

This is how im getting the persons name, to put in sharepoint:

Or is there a better way, please let me know!

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

Jiis 254 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Make a checkbox or toggle, and in the filter function add
If(Checkbox1.Value=true, YourCreatedByColumn=User().FullName)
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

I put a toggle buton, now when the toggle button is off, it doesnt show any records. When its on then it shows my records.
Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Valentino1 ,

I am assuming you are using SharePoint here - basic structure (using your checkbox name)

Search( Filter( 'Test List 1', Status.Value = "Request" && DateAndTime >= DatePicker2.SelectedDate && DateAndTime <= DatePicker2_l.SelectedDate && ( !CheckBoxName.Value || 'Created By'.Email = User().Email ) && ( IsEmpty(ComboBoxl.Selectedltems) || ComboBoxl.Selected in Domains ) ), 'Filter Search Box'.Text, "Titlel" )

If you want some Delegation capability

With( { _Data: Filter( 'Test List 1', Status.Value = "Request" && DateAndTime >= DatePicker2.SelectedDate && DateAndTime <= DatePicker2_l.SelectedDate && ( !CheckBoxName.Value || 'Created By'.Email = User().Email ) ) }, Search( Filter( _Data, ( IsEmpty(ComboBoxl.Selectedltems) || ComboBoxl.Selected in Domains ) ), 'Filter Search Box'.Text, "Titlel" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Im not sure what the "Created by" is, im getting an error here:
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Valentino1 ,

Is SharePoint your data source ?
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, the column where im putting the names in is "Requester".
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Valentino1 ,

'Created By' is a standard column in SharePoint (assuming 'Test List 1' is a SharePoint List), so I do not know why you should be getting an error there (though what you have is not the structure I posted), however what type of field is Requestor ?
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

Just one line text field.
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

I think the structure should be exactly the same now
Valentino1 111 on at

Like
a
(0)

Report
Copy link

Link copied!

By the way im not using email to store the names, im using this: