{"id":2390,"date":"2025-04-03T18:31:58","date_gmt":"2025-04-03T16:31:58","guid":{"rendered":"https:\/\/blog.kodono.info\/wordpress\/?p=2390"},"modified":"2025-04-03T18:32:11","modified_gmt":"2025-04-03T16:32:11","slug":"power-fx-dynamically-access-an-object-propery-with-a-variable","status":"publish","type":"post","link":"https:\/\/blog.kodono.info\/wordpress\/2025\/04\/03\/power-fx-dynamically-access-an-object-propery-with-a-variable\/","title":{"rendered":"Power FX: Dynamically access an object property with a variable"},"content":{"rendered":"

I’m kind of new with Power Apps, and it’s been very difficult to find how to access an object property using a variable.<\/p>\n

In a nutshell, here are to access it:<\/p>\n

\r\nWith(\r\n  { tempData: ParseJSON(JSON(ThisItem, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)) },\r\n  Concat(\r\n    ForAll(\r\n      ColumnArray As ColumnName,\r\n      ColumnName.Value & \"=>\" & Column( tempData, ColumnName.Value ) & \"<br>\"\r\n    ),\r\n    Value\r\n  )\r\n)\r\n<\/pre>\n
I’m transforming my record ThisItem<\/code> to an UntypedObject to make it work with Column()<\/code>, using JSON<\/b> and by removing the problematic properties (thanks to JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes<\/code>).<\/p>\n
Then I iterate my array (a.k.a ColumnArray<\/code>) that contains the property I need, and I use Column( tempData, ColumnName.Value )<\/code> to extract the column from the record!<\/p>\n
My use case<\/strong>: I defined a collection with a list of columns, then I have a Gallery in which I have an HTMLText component that must display the columns from ThisItem<\/code> based on the collection I defined before.<\/p>\n
So, in App<\/code> screen, I defined my collection like that:<\/p>\n
\r\nClearCollect(ColumnArray,[\"ID\", \"Title\", \"Description\", \"Target_x0020_Start_x0020_Date\", \"AssignedTo\"]);\r\nClearCollect(UserColumns, [\"AssignedTo\"]);\r\n<\/pre>\n
Then in my Gallery, I have an HTMLText object with the below content:<\/p>\n
\r\n\"<div style='display:grid;grid-template-columns: 100px 50px 1fr 1fr 100px 150px;gap: 0px;height:65px;max-height:65px;overflo:hidden'><div style='\"&cssTdStyle&\";display:flex;justify-content:center;'><button type='button'>Edit<\/button><\/div>\" &\r\nWith(\r\n  { tempData: ParseJSON(JSON(ThisItem, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)) },\r\n  Concat(\r\n    ForAll(\r\n      ColumnArray As ColumnName,\r\n      \"<div style='\"&cssTdStyle&\"'>\" &\r\n  If(\r\n    ColumnName.Value in UserColumns,\r\n    Column( tempData, ColumnName.Value ).DisplayName,\r\n    Column( tempData, ColumnName.Value )\r\n  )\r\n  & \"<\/div>\"\r\n    ),\r\n    Value\r\n  )\r\n)\r\n& \"<\/div>\"\r\n<\/pre>\n
This way I can make my display dynamic, based on a list of columns (that can be populated using a Power Automate Flow). I’ll have to identify which columns are User type, or similar ones, in order to access to the next property (like .DisplayName<\/b>).<\/p>\n","protected":false},"excerpt":{"rendered":"
I’m kind of new with Power Apps, and it’s been very difficult to find how to access an object property using a variable. In a nutshell, here are to access it: With( { tempData: ParseJSON(JSON(ThisItem, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes)) }, Concat( ForAll( ColumnArray As ColumnName, ColumnName.Value & “=>” & Column( tempData, ColumnName.Value ) & “<br>” ), […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","hide_page_title":"","footnotes":""},"categories":[15,23,170,13,33],"tags":[153,156,123,152,158],"class_list":["post-2390","post","type-post","status-publish","format-standard","hentry","category-astuce","category-debug","category-english","category-niveau-intermediaire","category-programmation","tag-astuce","tag-debug","tag-english","tag-niveau-intermediaire","tag-programmation"],"_links":{"self":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/2390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/comments?post=2390"}],"version-history":[{"count":8,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/2390\/revisions"}],"predecessor-version":[{"id":2398,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/posts\/2390\/revisions\/2398"}],"wp:attachment":[{"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/media?parent=2390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/categories?post=2390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.kodono.info\/wordpress\/wp-json\/wp\/v2\/tags?post=2390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}