Answered

Dynamic Column name

(2) Share

Report

Posted on by RamK

Hi,

I'm new to powerapps. Would like to know is there any way to pass the column name dynamically? We have 50+ columns and 3000+ records(varies on each column) in SP List. Suppose lets say If user selects a value from the list of 50 distinct values and the dropdown should display the values from the respective column.(Column name and the User selection list are having same values)

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like (3)

Report
Copy link

Link copied!

Hi @RamK

Dynamic columns is not currently possible
Your option would be to call Flow and pass column name, flow can perform query and send response back to PowerApp (but that would be an overkill)

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @RamK ,

I'm afraid it's not supported to change fieldname dynamicly.

For now, you need to clearly state which field that you want to display.

I suggest you express your views on PowerApps Ideas Forum. Your precious advice will be very helpful for our work.

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

As an alternative way, you could try If statement to change displaying fieldname.

For example, set the drop down2's Items:
If(dropdown1.Selected.Value="fieldname1",listname.fieldname1,

dropdown1.Selected.Value="fieldname2",listname.fieldname2,

dropdown1.Selected.Value="fieldname3",listname.fieldname3,.......)

Please replace fieldnames with the names that you use.

Was this reply helpful? Yes No
RamK 9 on at

Like (0)

Report
Copy link

Link copied!

Thank you Reza.

Was this reply helpful? Yes No
VK2 29 on at

Like (0)

Report
Copy link

Link copied!

Anobody update on this?
Would be helpful.

Was this reply helpful? Yes No
Suggested answer

NickTT 236 on at

Like (1)

Report
Copy link

Link copied!

This is possible. In one of my projects, I had a column for each test environment, and I needed to read the value from that column based on what environment my project was deployed to. Below is a simplified table of what I my table looked like.

Task Dev Test Prod

LogWriteDelay 10 20 30

What I did was use Power Automate to get that row from the table. Then I converted the data to XML and then used XPATH to dynamically select the column name based on an Environment Variable the workflow was deployed to. It worked perfectly.

Compose - Convert to XML:
xml(json(concat('{ "root": ',body('Select'), ' }')))

Output of the compose looks something like this:
<root>
            <Task>LogWriteDelay</Task>
            <Dev>10</Dev>
            <Test>20</Test>
            <Prod>30</Prod>
</root>

Compose - Get Dynamic Column:
first(xpath(outputs('Compose_-_Convert_to_XML'), concat('/root/',parameters('Environment (new_Environment)'),'/text()')))

You could easily expand on this idea to pick the value based on what was selected in a drop-down menu or something.

1 people found this reply helpful.

Was this reply helpful? Yes No