cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TrulsB
Advocate II
Advocate II

Power automate with Odata query on wharepoint list with Nordic letter in query

Hi,

Here in Norway we are using the characters æ,ø and å.  Im using ODATA Query to filter a Sharepoint list, and it fails because of the special character. 

 

This Query fails:

Avviksdato lt '@{formatDateTime(addDays(utcNow(),-14),'yyyy/MM/dd')}' and (Saksfase ne 'Lukket' and Saksprioritet eq 'Ordinær')

 

This QUery Works well and do not fail:

Avviksdato lt '@{formatDateTime(addDays(utcNow(),-14),'yyyy/MM/dd')}' and (Saksfase ne 'Lukket' and Saksprioritet eq 'Haster')

 

The difference in the Query is the Word "Ordinær" With the special Nordic character "æ".

 

I

 

Any idea.

0 REPLIES 0

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,622)