cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Set() Variable not working (Record)

 Hello to everyone, 

I am currently trying to find a work around this issue that I just started having.

In other applications I would use the 

 

Set(
    _User Details,
    First(
          Filter(
          data source,
                 condition
                )
          )
   )

 

 

To get the record from a SQL based on a user PIN input.

However that recently started giving me some issues and it will not retrieve all of the values from the record.

I've also tried a Clear Collect() but it only gives me the values from the conditions. 

collection.PNG

 

Global Variable.PNG

 

PowerApps Release : 3.20014.23

however in my other app I user the Set() and I tried it and it shows all of the data from the record:

 

Global Variable Previous Version.PNG

 

The current PowerApps Release for the other app is 3.20014.23

but I initially started this app on 3.18105.18

I'm not sure if I'm the only one having the issue but the Application with the issue is in a different environment from the application that works.

I will export and Import the application from one environment to another.

Any help is appreciated! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Set() Variable not working (Record)

I believe this has to do with how the app is optimized to only retrieve data it is using. The advanced setting "Explicit Column Selection" is likely enabled.

In your other app, there's a good likelihood that you're using some of the attributes, and therefore the record is being retrieved with all (or defined) data. I have seen this at times with my apps. I recommend adding the attributes you expect to use into Gallery labels, or other places in the app, then do a Save, Close, and reopen the Studio. See if that helps.

 

View solution in original post

3 REPLIES 3
Highlighted
Super User
Super User

Re: Set() Variable not working (Record)

I'm not having any issues with Set() on a SQL data source using the same formula you provided. Could you share more about your SQL table or anything else that may help?

Highlighted
Super User II
Super User II

Re: Set() Variable not working (Record)

I believe this has to do with how the app is optimized to only retrieve data it is using. The advanced setting "Explicit Column Selection" is likely enabled.

In your other app, there's a good likelihood that you're using some of the attributes, and therefore the record is being retrieved with all (or defined) data. I have seen this at times with my apps. I recommend adding the attributes you expect to use into Gallery labels, or other places in the app, then do a Save, Close, and reopen the Studio. See if that helps.

 

View solution in original post

Highlighted
Frequent Visitor

Re: Set() Variable not working (Record)

Great! that actually helped!

I completely forgot about the Explicit Column!

Thank you so much!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (2,808)