Power Automate – Translate Languages in Bulk

There may be a time where a business needs to translate multiple words, sentences, or paragraphs into different languages, and needed in a table format. You can do them in bulk using Power Automate. Follow the blueprint below on how to carry out this task.

Step 1:

Create an Instant cloud flow with manual trigger.

Step 2:

Add Get items (SharePoint)

Site Address

[Site where 'Language Translations' is located]

List name

Language Translations

Note: Expand ‘Show Advanced options’

Filter Query

Copy the code below and paste it in the Filter Query field.

Created lt '@{utcNow()}'

The pasted result should look like the one below.

Created lt ‘

utcNow()

‘

Note: The filter query here does not really filter anything. It just removes the warning pane whenever you test the flow.

Step 3:

Add Translate text (Microsoft Translator V2)

Target Language

German

Note: Leave the Text field blank for now. This is for the next step

Step 4:

On the same action (Translate text), fill out the Text using Dynamic content.

Text

English

Note: Once you selected the dynamic content of ‘English’, an ‘Apply to each’ loop will automatically be applied.

Step 5:

Add Update Item (SharePoint) inside the ‘Apply to each’ loop.

Site Address

[Site where 'Language Translations' is located]

List or Library Name

Language Translations

Id

ID

German

Body

Note: Sometimes, the dynamic content shows as “Translated Text” instead of “Body”.

Step 5:

Add another Translate text (Microsoft Translator V2) inside the ‘Apply to each’ loop.

Target Language

Filipino

Text

English

Step 5:

Add another Update item (SharePoint) inside the ‘Apply to each’ loop.

Site Address

[Site where 'Language Translations' is located]

List or Library Name

Language Translations

Id

ID

Filipino

Body

  (choose the one from the last Translate text)

Note: Sometimes, the dynamic content shows as “Translated Text” instead of “Body”.

Run and test the app. Once testing is successful, go to the SharePoint list Language Translations. The translated text should appear in the ‘German’ and ‘Filipino’ columns.