Power Apps

Using LookUp on a Collection blanks out data in fields

(1) Share

Report

Posted on by Keng.Ng-AUS

1. Add Environment Variable data sources.

2. Wrote code to extract some fields from the Environment Variables:

and confirmed Collection has data:

3. Tried to use LookUp to retrieve the value for "bt_DebugMode"

and the Collection is now missing data for the EnvValue and EnvVariableName columns:

Why is that?

I can use LookUp ok with Collection that got data from a JSON payload, etc, but somehow Environment Variables are behaving differently.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

MS.Ragavendar 6,334 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@KN-27030838-0,

// Build the collection

ClearCollect(

    colTest,

    AddColumns(

        'Environment Variable Values',

        "EnvSchemaName",    'Environment Variable Definition'.'Schema Name',

        "EnvVariableName", 'Environment Variable Definition'.'Display Name',

        "EnvValue",         Text(Value)

    )

);

// Read just the value you need

Set(

    gblDebugMode,

    LookUp(colTest, EnvSchemaName = "bt_DebugMode", EnvValue)

);

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Keng.Ng-AUS 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks, Ragavendar. I tried your suggestion:

//Get Environment Variables

ClearCollect(colTest,

ForAll('Environment Variable Values', {

'EnvSchemaName': 'Environment Variable Definition'.'Schema Name',

'EnvVariableName': 'Environment Variable Definition'.'Display Name',

'EnvValue': Text('Value')

})

);

Set(vEnvTest, LookUp(colTest, EnvSchemaName="bt_DebugMode",EnvValue));

It didn't work. vEntTest has not value:

And the data for two columns in the Collection colTest was erased:

Very confusing.

Was this reply helpful? Yes No
Suggested answer

Kalathiya 1,690 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @Keng.Ng-AUS,

Try using EnvValue: 'Value' without wrapping it in Text(). Sometimes the environment variable is a complex type and wrapping it in Text() won’t work. Try it without Text() should work as expected.

Try this formula:

ClearCollect( colTest, ForAll( 'Environment Variable Values', { EnvSchemaName: 'Environment Variable Definition'.'Schema Name', EnvVariableName: 'Environment Variable Definition'.'Display Name', EnvValue: 'Value' } ) );

LookUp Filter specific value:

LookUp(colTest, EnvSchemaName="cr1bf_Test",EnvValue)

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No