You’re offline. This is a read only version of the page.
I am trying to select a user in my database that corresponds to the User().Fullname
This way I can pull the users data into the fields in the appl.
The database [db] which has a field "Display Name" in the format - lastname, firstname.
It also has fields: firstname, lastname
User().Fullname returns text in the form firstname + " " + lastname
I can create a datatable which lists Concatenate('[db]'.FirstName, " ", '[db]'.LastName)
I've tried Filter('[db]', Concatenate('[db]'.FirstName, " ", '[db]'.LastName) = User().Fullname) - but this returns an error
I can Split User().Fullname into a datatable, but I can figure out how to reformat it to match the [db].DisplayName
I've tried Filter('[db]', Concatenate('[db]'.FirstName, " ", '[db]'.LastName) = User().Fullname) - but this returns an error
Inside a Filter expression, you don't need to specify '[db]' - you are alread in the context of the rows from the database. If you write your expression as follows it should work.
Share
Report
All responses (
Answers (
Filter('[db]', Concatenate(FirstName, " ", LastName) = User().FullName)
534
