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

Did I create a table nested in another table?

So a bit of exposition is required:

 

I have a single column table, TimesNoFormat, which is nested in a gallery (for reasons I'm not sure are relevent to the question so I'll leave them out).

 

What I'm trying to do is concatenate the values in this table with a value from a row in the gallery. 

 

Eg. The table items in row one in the gallery will go from 0015, 0030.... to M0015, M0030.

 

In the Items property of the table I have used:

 

AddColumns(
    TimesNoFormat,
    "RoomNumber",
    Concatenate(
        ThisItem.Title,
        TimesNoFormat.'New Times'
    )
)

Which is not throwing any errors.

 

However, when I try to display the items in the new column as text on a button I get the error:

 

"The property expects Text values, but this rule produces incompatable table values"

 

I've tired ThisItem.RoomNumber but it's still not having it.

 

Is it saying that the item in the table is a table itself?

 

I'm struggling to fathom what exactly is wrong.

 

Hopefully that is enough info for somone to assist but feel free to ask for more.

 

Cheers,

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Lewkir
Level: Powered On

Re: Did I create a table nested in another table?

Solved it b removing "ThisItem" and the table name:

 

AddColumns(
    TimesNoFormat,
    "RoomNumber",
    Concatenate(Title,'New Times')        
)

 

No idea why it worked but it does.

View solution in original post

Highlighted
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Did I create a table nested in another table?

Within an AddColumns call for the table TimesNoFormat, all members of that table are in scope - so if you want to access the 'New Times' property, you can do it directly. When you specified "TimesNoFormat.'New Times'" as an argument of the Concatenate function, then you went you went out of the record scope and back to the "global scope", retrieving a table with all values for the 'New Times' property of TimesNoFormat. If you change your expression to this:

AddColumns(
    TimesNoFormat,
    "RoomNumber",
    Concatenate(
        ThisItem.Title,
        'New Times'
    )
)

I believe you should get the result you want.

Hope this helps!

View solution in original post

3 REPLIES 3
Lewkir
Level: Powered On

Re: Did I create a table nested in another table?

Solved it b removing "ThisItem" and the table name:

 

AddColumns(
    TimesNoFormat,
    "RoomNumber",
    Concatenate(Title,'New Times')        
)

 

No idea why it worked but it does.

View solution in original post

Highlighted
PowerApps Staff CarlosFigueira
PowerApps Staff

Re: Did I create a table nested in another table?

Within an AddColumns call for the table TimesNoFormat, all members of that table are in scope - so if you want to access the 'New Times' property, you can do it directly. When you specified "TimesNoFormat.'New Times'" as an argument of the Concatenate function, then you went you went out of the record scope and back to the "global scope", retrieving a table with all values for the 'New Times' property of TimesNoFormat. If you change your expression to this:

AddColumns(
    TimesNoFormat,
    "RoomNumber",
    Concatenate(
        ThisItem.Title,
        'New Times'
    )
)

I believe you should get the result you want.

Hope this helps!

View solution in original post

Lewkir
Level: Powered On

Re: Did I create a table nested in another table?

Thanks Carlos.

 

I worked it out a mere 3 minutes before you answered but as you also explained why it worked I'll give you the accepted solution. 

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 79 members 3,682 guests
Please welcome our newest community members: