Unanswered

French translation producing error in Power Automate

(0) Share

Report

Posted on by LucasDaniel

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?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
LucasDaniel 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

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

Here is a view of the flow:

Was this reply helpful? Yes No
Expiscornovus 33,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
LucasDaniel 4 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus,

This column is configured as a single line of text.

Was this reply helpful? Yes No
Expiscornovus 33,757 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No