cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yoshihirok
Level 10

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 Team
Community Support Team

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 Team
Community Support Team

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

yoshihirok
Level 10

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,370)