update excel table

[ppp345678]

我正在尝试更新一个excel table。

使用table中的“编号”列作为查找需要更新的record依据。但是出现了下面的错误：

Thanks in advance.

[v-bofeng-msft · Accepted solution]

Hi @ppp345678 :

I suggest you check whether there is a column named ‘__PowerAppsId__’ be automatically generated in your excel table. If it does not exist, then you can create it manually, which may solve this problem.

Best Regards,

Bof

[ppp345678]

when i change  编号 to ID, it worked.

Thank you for your help!

[v-xiaochen-msft · Accepted solution]

Hi @ppp345678 ,

Please check if there is a "__PowerAppsId__" column in the table.

If there is no such column, please try to rebuild a table or use onedrive connector.

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.