cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

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.

Top Solution Authors
Top Kudoed Authors
Users online (13,547)