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


Report
All responses (
Answers (