cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
R3dKap
Super User
Super User

SharePoint empty columns don't exist in Power Apps collection's records anymore

Hi all,

Here is the use case:

  • You have a SharePoint list myList with a custom text column myTextCol
  • You create an item leaving the myTextCol column blank

You go to Power Apps and create a new application that connects to that list. You add a button to the application that does a CearCollect(myCol, myList) in its OnSelect property.

Now look at the only record of the collection myCol: the column myTextCol is not there!?! Don't look at the collection as a whole, Look at the individual record to see that the columnm is missing. Records in Power Apps collections that have empty values in some of their columns see these columns disappear from their structure. Which means that in the same collection you can have different records with different structures!!!

And the real pain with this is that if you try to Patch the record of myCol to set its myTextCol a value, it won't work since the colummn is not there! 😫

Anyone has reported this the support? If that is the case, could you please provide here the case number please?

Thanks,

Emmanuel

7 REPLIES 7
WarrenBelz
Super User III
Super User III

Hi @R3dKap ,

What do you refer to as a Custom Text Column in SharePoint?

v-siky-msft
Community Support
Community Support

Hi @R3dKap ,

 

Once you do any modifications on SharePoint list, don't forget to refresh the SharePoint connection in your App.

Hope this helps

Sik

PaulD1
Super User
Super User

Just a thought - do you have 'Explicit Column Selection' turned on in the Advanced Settings?

If so PowerApps will make a (very bad) guess at which columns you are interested in and only fetch those columns.

I'm not sure exactly how PA decides which columns to include/exclude but the method was changed back in November 2019 - I know this because it broke a bunch of my production Apps. Previously if you 'collected' from a datasource and then referenced a column from the collection, Explicit Column Selection would make sure that column was retrieved, after Nov 2019 it only seemed to fetch in columns if they were directly referenced in the App.

If you want the performance boost of not fetching columns you don't need, use ShowColumns to specify just the columns you do want and make sure 'Explicit Column Selection' is turned off.

Thanks @PaulD1 for your insight as I have not struck this issue before.

This makes @R3dKap 's answer even more interesting.

R3dKap
Super User
Super User

Thank you all for your different feedbacks...

@v-siky-msft, during my initial tests I tried to do a refresh inside the app and reload the collection but it doesn't work. The empy columns are still inexistant.

@PaulD1, same... During my tests I tried disabling that parameters whih had no effects at all on the result (all connectors are not compatible with this parameter... I wonder how you even know which ones are).

Support tried to call me today but I missed the call. I'll keep you guys up to date if anything changes...

Have a nice day all,

Emmanuel

R3dKap
Super User
Super User

Here is the latest update on this issue...

Support team called me yesterday and a ticket has been opened. I made a screen recording to show the issue and provided the support with a detailed explanation of the problem.

Support came back to me today saying that the issue has been escalated to the backend team.

I'll let know how this goes... And if you want to watch the recording to see how it looks, here it is: ClearCollect BlankFields 2020-04-28 17-11-17.mkv

Has anyone noticed this behavior? No one has been disturbed in its developments so far 'cause of this?

R3dKap

Thanks for the update @R3dKap . I have not noticed this in my current projects but I try to avoid developing against SharePoint (it never works out well in my experience) and increasingly try to avoid PowerApps altogether due in no small part to the number of strange and random issues/bugs that we seem to regularly encounter.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

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

Top Solution Authors
Top Kudoed Authors
Users online (45,961)