Power Platform Community Forum Thread Details

Hello, I am creating a button on the Contact main form.

I am getting the associated Account (renamed to Household in my environment).

I can get the Name and Account fields of the associated Account record, but it seems none of the fields that include spaces can be retrieved.

E.g., columns 'Engage ID', 'Start Date', 'Final Delivery Method' all have (non-null) values for this record, but appear blank when printed in a Notify call.

The notification bar appears as follows, with blanks for any column that is referenced with single quotes ' ' because they have spaces.

Categories:

Building Power Apps

While this still does not work as expected, I found a different approach for retrieving the desired fields from the parent account (household).

I used a LookUp instead of relying on AsType alone.

Before
AsType(Self.Selected.Item.Household, Households).'Engage ID'

This failed to retrieve anything, even when using the logical name instead of 'Engage ID'. The result was always blank.

After
LookUp( Households, Name=AsType(Self.Selected.Item.Household, Households).Name ).'Engage ID'

This works. As mentioned in the OP, for some reason I am able to retrieve the name with

AsType(Self.Selected.Item.Household, Households).Name

so I just looked up the appropriate record (the same as the current household the user is viewing) and THEN specified the column I wanted to grab.