cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Moosa
Advocate I
Advocate I

Excel Table headers have Arabic, Listing rows with $select gives- "Term 'أرقام ثلاثيه D' is not valid in a $select or $expand expression."

Hi Power Team,

 

I'm trying to get the only columns I need using Select Query option from excel online action (List rows present in a table).

In my case, I have Arabic text headers.


List rows with select queryList rows with select query

 

But unfortunately, I get Bad Request error on this action.

 

errorListrows.png

 

How can I resolve this?

 

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Moosa
Advocate I
Advocate I

Okay so, after some trial & errors I just found that the Select query here is not accepting 'Spaces'.

 

It's not the Arabic text but space between them, I removed all spaces and it worked just fine.

 

Capture.PNG

View solution in original post

1 REPLY 1
Moosa
Advocate I
Advocate I

Okay so, after some trial & errors I just found that the Select query here is not accepting 'Spaces'.

 

It's not the Arabic text but space between them, I removed all spaces and it worked just fine.

 

Capture.PNG

View solution in original post

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,995)