cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Memorable Member
Memorable Member

Cannot set SharePoint list item columns which name is Japanese.

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

 

1.png

 

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

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Cannot set SharePoint list item columns which name is Japanese.

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

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Cannot set SharePoint list item columns which name is Japanese.

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

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Memorable Member
Memorable Member

Re: Cannot set SharePoint list item columns which name is Japanese.

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

 

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,710)