Skip to main content

Notifications

Community site session details

Community site session details

Session Id : IsFSe6XlvQs3ZTI1hUPXvX
Power Automate - Building Flows
Unanswered

French translation producing error in Power Automate

Like (0) ShareShare
ReportReport
Posted on 4 Nov 2022 15:16:38 by 4

My flow is failing on the "Get File Content" action for a French translation of a sentence. 

I have a Microsoft Forms that has French translations for some of the answers. 

It has the word d'origine in it, and the ' is causing the error (BadRequest). 

 

 "status"400,

 "message""The expression \"column eq 'xxxx | xxxx d'origine xxxx'\" is not valid. Creating query failed.\r\nclientRequestId: 41211ebe-0125-416a-bc47-4548481e15cf\r\nserviceRequestId: 41211ebe-0125-416a-bc47-4548481e15cf"
 

Any solution to this? Any fixes? 




  • Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 08 Nov 2022 at 15:35:16
    Re: French translation producing error in Power Automate

    Hi @LucasDaniel,

     

    Thanks for sharing.

     

    Can you explain to me what the idea is behind the filter query. It looks like you are comparing a single line of text ERG column value with a ERG tags column value from the same library? Where does the answer of the form question come into play?

     

    To avoid special characters of terms/tags you could use the TaxCatchAll/IdForTerm and filter on the id of the taxonomy term. This way you will get the correct term and also don't have an issue with translation of the label of the term.

     

    If you do want to use the label of the term you could use the encodeUricomponent function. This would turn the query into a valid query. This does mean that the value of the ERG column needs to be written as D%27Origine to return a match.

     

    ERG eq '@{encodeUriComponent(item()['Label'])}'


    On a side node, you could also use TaxCatchAll/Term for your filter. However, I do not prefer that because duplicate labels could exist in a taxonomy.

     

    Mikael Svenson has a great blog about the TaxCatchAll filtering:

    https://www.techmikael.com/2016/05/workaround-to-filter-on-taxonomy.html

     

  • LucasDaniel Profile Picture
    4 on 08 Nov 2022 at 14:58:05
    Re: French translation producing error in Power Automate

    Hi @Expiscornovus

    This column is configured as a single line of text. 

    LucasDaniel_0-1667919473729.png

     

  • Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 08 Nov 2022 at 14:51:08
    Re: French translation producing error in Power Automate

    Hi @LucasDaniel,

     

    Thanks for sharing. That already clarifies a couple of things.

     

    I do have a follow-up question. This ERG is a column of type managed metadata, correct? If so, does the column allow multiple values?

     

    ergcolumn.png

  • LucasDaniel Profile Picture
    4 on 08 Nov 2022 at 14:14:54
    Re: French translation producing error in Power Automate

    Hi @Expiscornovus

    My flow attaches files to an email based off of a Microsoft Forms submission.

    Here is a view of the flow:

    LucasDaniel_0-1667916813604.png

  • Expiscornovus Profile Picture
    31,652 Most Valuable Professional on 08 Nov 2022 at 09:41:56
    Re: French translation producing error in Power Automate

    Hi @LucasDaniel,

     

    Can you share a screenshot of your flow setup? This will help us with the troubleshooting.

     

    Just to double check. Are you trying to retrieve an uploaded file from one of the questions of the Microsoft Forms?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Churchy Profile Picture

Churchy 6

#2
Chriddle Profile Picture

Chriddle 4 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 4

Overall leaderboard
Loading started