cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaxDonen
Level: Powered On

xxx_Column1 issue in some formulas (renamecolumns in this example)

I have a collection column that I am trying to reference in a renamecolumns() formula. 

But when I type the column name into the formula, all I get is 'columnname_Column1'.

 

The attached may help clarify the issue. Column name is 'CBS1' in the attached example, but 'CBS1_Column1' is the only entry that comes up.  

 

What's happening here? 

 

Thanks 🙂 

3 REPLIES 3
Community Support Team
Community Support Team

Re: xxx_Column1 issue in some formulas (renamecolumns in this example)

Hi @MaxDonen ,

Do you mean that if you want to use one field in renamecolumns function, the fieldname will become fieldname_Column1?

That's really strange... I never met this kind of problem before.

So could you give me more details?

For example, tell me how do you get this collection, the renamecolumns formula?the data type of this 'CBS1' field?

What's more, if you use other fields in the collection, will you meet the same problem?

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MaxDonen
Level: Powered On

Re: xxx_Column1 issue in some formulas (renamecolumns in this example)

@v-yutliu-msft  Thanks for the reply, apologies for the delay in my own response. 

 

I have finally had some time to check out this issue, but unfortunately I couldn't fully recreate the problem. However, I did note that whilst the correct column name appears (CBS1 in this case), CBS1_column1 also appears directly below it. 

 

I've encountered this issue with other collections in powerapps...is there a reason why the _column1 suffix appears? 

 

If it helps, here's the code that generates the collection concerned: 

If(Not(Analysis_Type="SubFacility"),
    Collect(
    Col_CostAnal_Graph_Master,
    AddColumns(
        Filter(
            Col_CostAnalCompare,
            ID_Number = ThisItem.ID_Number && Project_ID = ThisItem.Project_ID && Analysis_Type = ThisItem.Analysis_Type
        ),
        "Element_Cost_Combined",
        Bespoke_Cost + CBS1_Cost + CBS2_Cost + CBS3_Cost+Element_Cost+Subfacility_Cost+DirectLevel1_Cost+DirectLevel2_Cost,
        "Element_Name_Combined",
        Concatenate(
            Bespoke,
            CBS1,
            CBS2,
            CBS3,
            Element,
            SubFacility,
            DirectLevel1,
            DirectLevel2)
            ,
        "Element_And_AnalysisType_Combined",
        Concatenate(
        Analysis_Type,
        "_",
        ID_Number 
    )
)
),
If(Analysis_Type = "SubFacility",

Collect(
    Col_CostAnal_Graph_Master,
    AddColumns(
        Filter(
            Col_CostAnalCompare,
            ID_Number = ThisItem.ID_Number && Project_ID = ThisItem.Project_ID && Analysis_Type = ThisItem.Analysis_Type
        ),
        "Element_Cost_Combined",
        Bespoke_Cost + CBS1_Cost + CBS2_Cost + CBS3_Cost+Element_Cost+Subfacility_Cost+DirectLevel1_Cost+DirectLevel2_Cost,
        "Element_Name_Combined",
        "Subfacility Elements",
        "Element_And_AnalysisType_Combined",
        Concatenate(
        Analysis_Type,
        "_"
        
    )
)


)))

I just want to know what could be causing this '_column1' entity to appear? 

 

The datatype of the CBS1 column is integer. 

 

Here's the code that calls the renamecolumns() function:

 

If(
   Sum(
       ForAll(
              RenameColumns(Col_CostAnal_Graph_Master, "Analysis_Type", "1Analysis_Type", "Element_Name_Combined", "1Element_Name_Combined","Unit","1Unit"),
             If(
                 !IsBlank(LookUp(Col_CostAnal_Graph_Master,Element_Name_Combined = '1Element_Name_Combined'  
                 
                 && Analysis_Type = '1Analysis_Type' && Unit<>'1Unit' )) 
                 
                 && CountRows(Filter(Col_CostAnal_Graph_Master, Element_Name_Combined = '1Element_Name_Combined' && Analysis_Type = '1Analysis_Type'))=2,
                 1,
                 0
            )
       
       ),
       Value
   ) >=2,
   true,
   false
)

 

Thanks. 

MaxDonen
Level: Powered On

Re: xxx_Column1 issue in some formulas (renamecolumns in this example)

Thought I'd give this issue a bump. It's still not resolved and it occurs in other app with different collections. 

 

The basic issue is that the column (eg 'xxx') is unavailable, and 'xxx_column1' appears instead.

 

Can anyone help?

 

Thanks. 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,627)