We have a table(Sharepoint List) that is using the Employee User().FullName as the header. Full disclosure, I did not design this table. The data in this column represent numerical rating (1-5) on skills for various products and technology. This data is entered by the employees. I need to access this column with the O365 User().FullName value of the user that accesses the Powerapp. I have this set in a global variable. Is there a way to use this variable to build a filter for this column of data? I tried referencing directly from the filter but does not seem to be valid. I see other articles saying column headers can not be referenced with a variable. Is this the case, is there another way to build this filter?
Sorry but I didn't fully understand, what exactly is the column name that you set for this column in SharePoint list? You should be able to ensure this by checking the name shown here in the list:
Is this a Person and Group column? If so, then generally, my understanding is that you want to filter the gallery where this column's value matches "User().FullName". You do not need a variable to do this. Just use below formula in the Items property of the gallery: