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
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.
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |