filter a sharepoint datasource to only show user() details

[duckettj1]

I have a Sharepoint data source with Name, address, email and car reg details.

I want to be able to display this datasource in a table / gallery / view form - but only data relating to the signed in user - i've tried this code

Filter(HENG_VehicleInformation,'E-Mail' = (User().Email))

but i am getting delegation errors - presumably because my 'Users' table has more than 2000 users?  The datasource only currently has 2 records - but the potential to have 100's.

[Pstork1 · Accepted solution]

Save the Current user's email to a variable in the OnStart property for the App.  Then filter on that variable.  The delegation issue will go away.

Set(CurrentEmail, user().Email)

Filter(DataSource, 'E-Mail'=CurrentEmail)

[duckettj1]

Many thanks for your help, the delegation error has vanished! 

Need to know how to display the fields I need from the datasource, but i'll fathom it out, cheers.

[Pstork1]

Just add the filter statement to the Items property for the Gallery.  THen you can edit the fields to display the fields you want.