Power Platform Community Forum Thread Details

I created an app that depending on the selection in the first gallery, displays the values to allow the admin group to update or add new. I was able to get the drop down (fact vs dimension) to display correctly, but when I click the table to display the values from the fields, it will not work. I've tried several different methods consulting with ChatGPT and cannot get it it to display the value. In troubleshooting, it recognizes the count of values, but does not display the value. The goal of the app is to display field values that we can edit OR add new values to that table. We can do this if I create multiple galleries, but I was trying to minimize the amount of work by creating dynamic galleries/forms.

Layout:

3 Containers

Drop Down
2 Galleries : Admin Selection Fact and Admin Selection Dimension
2 Galleries and 1 Form: Gallery_Reference, Gallery_Fact, Form_Editor

On the app onstart, I created a list of tables and fields (example of format below)

ClearCollect(
    colTableFields,
    { TableName: "Service Area", Fields: ["Service Area Name"] },
    { TableName: "Sub-Service Area", Fields: ["Sub-Service Area Name"] },
    { TableName: "OU Portfolios", Fields: ["Portfolio Name"] },
    { TableName: "OKR Vision Houses", Fields: ["Vision House Name"] },
)
 
I have a drop down that is for fact and dimension onchange setting is this:Set(vartabletype,Dropdown2.Selected.Value)
 
I'm trying to use the switch function to display the value when
AddColumns(
    Switch(
        varSelectedTable,
        "Service Area", 'Service Areas',
        "Sub-Service Area", 'Sub-Service Areas',
        "OU Portfolios", 'OU Portfolios',
        "OKR Vision Houses", 'OKR Vision Houses'
    ),
    "FieldValue",
    Switch(
        varSelectedTable,
        "Service Area", 'Service Areas'.ServiceAreaName,
        "Sub-Service Area", 'Sub-Service Areas'.SubServiceAreaName,
        "OU Portfolios", 'OU Portfolios'.PortfolioName,
        "OKR Vision Houses", 'OKR Vision Houses'.VisionHouseName,
        "OKR Vision Strategies", 'OKR Strategies'.StrategyName 
)
 
The errors I'm getting are:
Error on Service Area Name Unexpected characters. The formula contains 'Service Area Name' where 'Ident' is expected. Expected operator. We expect an operator such as +, *, or & at this point in the formula. Name isn't valid. '_' isn't recognized., Unexpected characters. The formula contains 'BracketOpen' where 'Ident' is expected., Unexpected characters. The formula contains 'BracketOpen' where 'ParenClose' is expected., Unexpected characters. Characters are used in the formula in an unexpected way.
 
Is this something that is not possible?