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

The requested operation is invalid. Server Response

Good evening, I have a problem with a power app that connects to an online excel sheet.
It reads the first 300 rows, but if I add more rows the app doesn't read them and issues this error


The requested operation is invalid. Server Response: Table6 failed: Expression "Employee eq null" is not supported.

 

Table6 is the table I am going to read;
Employee is the column in the sheet 

The Employee column does not have any null records.

 

This error is displayed for all the new rows I have added.

 

do you have an idea how to bypass this error?

thanks

 

1 REPLY 1
Drrickryp
Super User
Super User

@Fischio 

Excel can be quirky.  Don't add additional rows to the table in Excel.  If you need to append records to the table, do it through PowerApps.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,882)