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,
Any solution to this? Any fixes?
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
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?
Hi @Expiscornovus,
My flow attaches files to an email based off of a Microsoft Forms submission.
Here is a view of the flow:
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?
Churchy
6
Chriddle
4
Super User 2025 Season 1
stampcoin
4