I am currently working on a Power Apps Page and in this, I have a subtitle in the gallery which has a text of ThisItem.Departments, where Departments is a column in the linked Dataverse table:
Now, I am writing Departments myself in the formula bar. However, I want to know if there is a way where the user can type in the column name they want in the text box above (highlighted), which will then change the text of the subtitle 3. Ideally, I am also looking for a way if the text box could be a dropdown (since the dropdown control is not an option in the PowerApp page) but that's not the main focus for me at the moment. I am currently just looking to call input the formula in the text of Subtitle 3 something as ThisItem.FieldSearch.Value (I know this syntax is wrong, it's just to explain what I am ideally looking for).
Thanks!