cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Advice regarding the use of 'Parent' as a non-keyword

So to put it simply, I did not know that 'Parent' is a reserved keyword within PowerApps. My table (excel data, static) contained the columns 'Parent' and 'Child' and I noticed some peculiar behaviour (some items not displaying, some pictures not loading, etc) in my app when I tried to import the table's contents into a collection, and then subsequently to a gallery.

 

After a lot of troubleshooting, it turned out that every issue/bug could be traced back to a variable that was dependent on the 'Parent' column.

 

PowerApps does not warn you that this could occur, so be warned.

 

Avoid using this keyword! If you must use the word 'Parent', write it with a typo eg 'ParentA' or something similar. I spent hours trying to figure this one out-hopefully I can spare you the same bother.

 

Cheers guys.

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User III
Super User III

Thanks @Anonymous for taking the time to share this.  These types of problem can be very difficult to diagnose, so it serves as a good reminder to all of us to avoid reserved words.

Another tip is that if you find yourself in a situation where you can't change the source column name (eg you're connecting to data source that you don't own/control), you can rename the column name client side with the RenameColumns function.

Also, another keyword to avoid is 'Location', as this conflicts the Location keyword in PowerApps.

View solution in original post

2 REPLIES 2
timl
Super User III
Super User III

Thanks @Anonymous for taking the time to share this.  These types of problem can be very difficult to diagnose, so it serves as a good reminder to all of us to avoid reserved words.

Another tip is that if you find yourself in a situation where you can't change the source column name (eg you're connecting to data source that you don't own/control), you can rename the column name client side with the RenameColumns function.

Also, another keyword to avoid is 'Location', as this conflicts the Location keyword in PowerApps.

View solution in original post

Anonymous
Not applicable

Thanks for the helpful thread @Anonymous and @timl 

 

@Anonymous 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (2,278)