Microsoft Translator Error

Like (0) Share

Report

Posted on 3 Jul 2023 14:14:52 by Matt-991599

149

Hi all,

I'm getting the following error when using MS Translator on a couple of Power Apps. I can't seem to find anything online that explains what it means or how to resolve it. If anyone can help me understand what might be causing the error, I'd really appreciate it.

MicrosoftTranslator.Translate failed: The method 'Translate' has an invalid value for parameter 'query'

Thanks in advance

Categories:

Connectors

All responses (8)

Answers (0)

surbhibhandari7 20 on 21 May 2024 at 06:15:12

Like (0)

Report

Re: Microsoft Translator Error

not able to add this connector into the power apps. Any solution for this? Microsoft Translator V3.

Service could not be created. Error retrieving Wadlmetadata
Matt-991599 149 on 04 Jul 2023 at 13:17:17

Like (0)

Report

Re: Microsoft Translator Error

That text label isn't being populated from selections made in the combobox though AJ. It's being populated with data pulled from the choice column in the SharePoint list.

The combobox is then being used to filter the gallery. So only items that contain the choice(s) made through the combobox are displayed in the gallery. So there will never be an instance when the text label is blank.

Sorry if I'm mssing your point and/or not explaining my issue very well.
developerAJ 2,855 on 04 Jul 2023 at 12:48:45

Like (0)

Report

Re: Microsoft Translator Error

problem is value should not be blank. so convert like this
MicrosoftTranslator.Translate(If(IsBlank(ComboBox.Selected.Value),"No Option Selected",Concat(ComboBox.SelectedItems,Value,";")),"es")

so if there is no way that value cannot be blank than thats good right it will never go to true condition i mean No option selected
Matt-991599 149 on 03 Jul 2023 at 18:33:57

Like (0)

Report

Re: Microsoft Translator Error

Hi AJ,

I think you're right. The issue appears to be with the syntax I've used on the secondary text labels. I need these to display and translate the content of various columns from my SharePoint list.

It doesn't appear to be an issue with MS Translator though. I've just noticed that even on the English version of my app I'm getting a 'This formula uses scope, which is not presently supported for valuation' error.

One of these text labels is pulling from a single line of text column in the SharePoint list. My formula for this is currently ThisItem.ListColumn. The others are pulling from choice columns in the SharePoint list. My formula for these is currently Concat(ThisItem.ListColumn,Value,Char(10)). I'm getting the same error message on both.

Is there a way I can tweak the syntax so it copies across the data successfully?

Thanks for your help
Matt-991599 149 on 03 Jul 2023 at 15:14:07

Like (0)

Report

Re: Microsoft Translator Error

Thanks AJ,

Sorry, I didn't explain very well I don't think.

The second Text Label is being used to pull data from the SharePoint list column and the selections made on the combobox on the app are then being used to filter those items. So there will never be a scenario when 'No Option Selected' is required because all items are displayed until the filter is applied.

I will also need to retain the Char(10) element of the formula if possible, because the app owner has requested that items in the text label be displayed on separate lines.

Is that feasible?
developerAJ 2,855 on 03 Jul 2023 at 15:03:47

Like (0)

Report

Re: Microsoft Translator Error

Text Label (static text) - MicrosoftTranslator.Translate("label text","es")
ComboBox (items) - AddColumns(Choices('List Name'.List Column),"temp",MicrosoftTranslator.Translate(Value,"es"))
This two are good should not throw any error

For Text Label (selections from ComboBox)
MicrosoftTranslator.Translate(If(IsBlank(ComboBox.Selected.Value),"No Option Selected",Concat(ComboBox.SelectedItems,Value,";")),"es")
or Concat(ComboBox.SelectedItems,temp,";") should do
Matt-991599 149 on 03 Jul 2023 at 14:50:57

Like (0)

Report

Re: Microsoft Translator Error

Hi AJ,

Thanks for responding. I'm converting English across the app into Spanish ("es"), Polish ("pl") and Portuguese-Brazilian (pt-br).

I'm using the following formulas:

Text Label (static text) - MicrosoftTranslator.Translate("label text","es")
ComboBox (items) - AddColumns(Choices('List Name'.List Column),"temp",MicrosoftTranslator.Translate(Value,"es"))
Text Label (selections from ComboBox) - MicrosoftTranslator.Translate(Concat(ThisItem.List Column,Value,Char(10)),"es")

The error message I mentioned is appearing when the app is launched and the 'loading' icons continually run along the top of the app.

Not sure what's causing the problem.
developerAJ 2,855 on 03 Jul 2023 at 14:19:51

Like (0)

Report

Re: Microsoft Translator Error

give the formula you are using for translator
and a sample value