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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery is blank after...
Power Apps
Answered

Gallery is blank after changing sharepoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

My gallery will no longer load the items. I went to my sharepoint list and changed a column to include date and time instead of just the date and then deleted it and made another column with the same name. Now I am getting an error for everything that uses the date like this UpdateContext({varHasrowsforToday:Filter('CCB Voting',Date = Text(Today(),ShortDate))}) , it is in my on visible for browse screen1. I am also getting an error here now et(varlastSubDate,First(collUserVoting).Date);
ClearCollect(collPrevUserVoting,Filter('CCB Voting','Created By'.Email = varUser.Email And Date = varlastSubDate));. Is there some kind of setting date was on in my sharepoint list? The entire gallery is just blank now. This is my items in the gallery Filter(
collCCBMasterData,
If(
IsBlank(ComboBox1.Selected.Result) || ComboBox1.Selected.Result = "All",
true,
'Functional Area' in ComboBox1.SelectedItems
) && If(
IsBlank(Filter.Text),
true,
Filter.Text in 'Requirement Source'
) && If(
IsBlank(Search_.Text),
true,
Search_.Text in Name
)
). Nothing in the app actually changed and the only thing I did was delete the column and create it again with the same name. Was there some kind of setting in the column?

Categories:
  • WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    Hi @Anonymous ,
    You can use

    IsToday(Date)

    however if Date is the actual name of your field, it is Reserved Word in Power Apps and can cause Ambiguity. You need to delete it and add a new one with a different name. If this not not fix the issue, I am happy to look further.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    My column is called date_. I am getting an error saying incompatible type for this Set(varlastSubDate,First(collUserVoting).Date); in my on start. The only thing I changed is the column in sharepoint, I never altered anything in powerapps. It has to be some kind of setting for the date in sharepoint. @WarrenBelz 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Every place it says date it says the name is not recognized.

  • Verified answer
    WarrenBelz Profile Picture
    156,528 Most Valuable Professional on at

    @Anonymous ,

    That is because SharePoint never changes the "initial" name - it is the same if you rename "Title". It is still looking for Date, which is a Reserved Word. You need to delete the column and put in a new one. After you do this, change to references in Power Apps and see if that works.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 395 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 260 Most Valuable Professional

Last 30 days Overall leaderboard