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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,260)