Power Platform Community Forum Thread Details

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

Categories:

Linking db name to User().Fullname