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
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
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
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (7,891)