Cannot set SharePoint list item columns which name is Japanese.

[yoshihirok]

I want to create items in SharePoint list which columns name is Japanese, like "部門"

Bug action: SharePoint - Create item

Error in the action. in japanese.

  "status": 400,
  "message": "列 'OData__x90e8__x9580_' が存在しません。他のユーザーが削除した可能性があります。",

and I can create item which columns name is English, like "Depr".

So, I want to the blog scenario "By Industry - Human Resources: Onboarding made easy" in Japanese.

But, stop by this bug.

Regards,

Yoshihiro Kawabata

[v-micsh-msft · Accepted solution]

Hi @yoshihirok,

The error message means "the ''' column does not exist, it may has been deleted by other user", right?

Is this error only happens with the "部門" column, or any column that named in Japanese?

Please make sure the actual Excel file is closed when configure the Flow Excel Action.

Have you tried to add another character together with the "部門", such "部門1" or "1部門"?

Check to see if this would make it work.

It might need some time for me to setup the testing environments, I will share the test results here once I finished the testing.

Regards,

Michael

[yoshihirok]

Hi @v-micsh-msft

I clear this issue, But I do not why.

At this time, Close this bug.

My test.

1. Test, the flow run now twice, and this issue happend

2. Rename the column name from  "部門" to "部門1" in SharePoint Online - List "採用情報".

3. Test, the flow run now twice, and this issue NOT happend

4. Rename the column name from "部門1" to "部門" in SharePoint Online - List "採用情報".

5. Test, this flow run now twice, and this issue NOT happend.

I will use this flow, adding more actions for testing.

Regards,

Yoshihiro Kawabata