Hi Power Platform Community, do you know if it is possible to access a collection property dynamically in power apps?
I have the following myMonth property that I want to use to dynamically access the value of a property.
and accessing it simply gives me an error like this:
I am basically trying to reproduce a transposed table.
Happy for any workaround to being introduced. Thank you.
Thanks for your suggestion. I tried something like you suggested, but still not getting the right value.
Basically, I want to get this value:
But I am getting the following value instead:
Is there anything that I did wrong.
I tried without the Text function too.
You can't pass the column name dynamically into the function. you would need to use the If or Switch function to change the formula for all of the months, but this isn't really scalable. I would have probably done it a bit differently by having a "Date" column rather than a new column for every year. This would allow you to filter the database based on a date and return the values you need, which would all be in one column. Concat() would then work as expected.
In that case i think you are unlikely to get an app that works for them through PowerApps. By doing it the way i suggested you will still get the correct data, it will also allow you to filter much better and your table will not be so large. you have to remember that if your table is growing in columns year on year you will get to a point where its not useable. i can't see this being a scalable approach.
if you google "powerapps select column dynamically" you will see lots of threads where this has previously been talked about. Good luck
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.