Calling ThisItem Dynamically in PowerApps

(1) Share

Report

Posted on by smital

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!

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

You would need to essentially have a Switch that listed all the possible variations of Columns, wit their output being changed to text (if its not already) And you would then have a Default (for the Switch) that would pick a specific column

Then you could have a Text Input, where as they type, it would use the Switch to determine what they meant (field wise) and IF it matched any it would show that value, if not it would show the default.

What I would do then is have a Help option, that would list all the "fields" they could type in.

That's how I would do it.

If this helps please mark as the answer.

Was this reply helpful? Yes No
smital 29 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the help. Since I want the user to have option to select the text for only a few of the records, I was thinking of the approach that I can create another Dataverse table, add in the column names I want the user to select and then insert a combo box for them to select the "mode" they want the subtitle to appear.

The main issue though is how do I change the formula ThisItem.ColumnName in such a way that instead of writing the ColumnName myself, it is something which is changed based on the value of the combo box.

Btw I love the idea of a help box, it'll definitely benefit the user!

Was this reply helpful? Yes No