web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / The schema for your da...
Power Apps
Answered

The schema for your data sources have been updated...gallery filter using 'in' function

(0) ShareShare
ReportReport
Posted on by 185

Hello all, quick question about the app notification while loading saying "The schema for your data sources have been updated" and then filter functions that use the 'in' function stopping to work. 

trstrean_0-1715775235853.png

 

  I've been working on a Power App with Dataverse tables as the data source for a few weeks now.  Last Thursday everything was working perfectly, and then I just resumed work on it today and was confronted with the mentioned load notification and "Save and Reload" or "Skip" as my options.  I've tried both options more than a dozen times now, and it continues to come up every time I open the app.  While this is annoying, the bigger problem is that every instance in my application where I use the 'in' function with a Dataverse choice column (optionsetvalue) leveraging a global choice, I'm now getting an error (Coordination Status Choice is the global choice used by Coordination Status): 

trstrean_1-1715775302531.png

Here is an example for one of my galleries that has stopped working:  

Filter(
 'Requested Coordinations','Coordination Status' in [
 398440001,
 398440002,
 398440004,
 398440005,
 398440006,
 398440007,
 398440008,
 398440009,
 398440010,
 398440011
 ])

My suspicion is that Microsoft broke something with an update and that it will magically start working one of these days.  I also received a notification about modern and classic controls that needed to be applied. As I've already made the mistake of trying to publish to see if that it would get me around the issue, is there a way to revise this approach that might get me around the error?  I'm still relatively new to working with Dataverse tables, so I'm also curious if there is a way to draft these that allows me to use the label instead of the value.  I had thought that 'Coordination Status'.Value or 'Coordination Status'.Label would be the appropriate way to format these, but those aren't options that the Power App provides as I tried things.  The approach I was using (until it stopped working) also avoided any delegation issues.  Appreciate any feedback on how to get around this issue.  App is pretty much dead in the water until it starts working or I find a workaround.

 

Categories:
I have the same question (0)
  • Verified answer
    trstrean Profile Picture
    185 on at

    I found a solution to this problem so I'm posting it here in case anyone else runs into the same problem in the future.  I'm currently on the GCC  environment, so this could be an environment issue as things always work differently in the GCC.  

     

    For this situation, I just needed to switch to an approach that is more commonly used when working with SharePoint of enclosing each value with "" and then the 'in' worked without issues.  Sucks in execution having to update 81 formulas containing lots and lots of items requiring "", but it got the app working again.  My only concern is that Microsoft changes back to how things worked before and then I'll need to remove all of those "" to get things working again. 

     

    I hope this helps someone else out there.

  • v-qiaqi@microsoft.com Profile Picture
    on at

    HI @trstrean,

    Thanks for your sharing.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard