How can I pass an array of strings to a Power Automate Flow?

Like (0) Share

Report

Posted on 28 Aug 2023 06:37:13 by Binary_Tree

From PVA, I am trying to pass a Table (An array of strings, e.g. ["String 1", "String 2", "String 3"]) to a Power Automate Flow. I'm having a lot of difficulty achieving this, as there seems to be no way to convert such a table to a string? Wrapping the table with Text() does not work.

Is there actually a way to do this? Thanks

Categories:

Power Automate Flows

All responses (2)

Answers (0)

alexwu2023 4 on 29 Nov 2023 at 06:43:35

Like (0)

Report

Re: How can I pass an array of strings to a Power Automate Flow?

how to create PVA trigger which accept array? currently seems only string, boolean and number are supported
stuermer 64 on 29 Aug 2023 at 10:04:50

Like (0)

Report

Re: How can I pass an array of strings to a Power Automate Flow?

Hey @Binary_Tree !

At which point you're struggeling? Have you played around with some data operations? E.g.: Create a trigger in Power Automate that accepts an input from Power Virtual Agents. This input should be the array of strings. Once you have the array of strings as an input in Power Automate, you can manipulate it further. Use the `join` expression in Power Automate to convert the array into a single string.

For instance:
join(triggerBody()?['YourArrayInputName'], ', ')

This will join the array ["String 1", "String 2", "String 3"] into "String 1, String 2, String 3".
You can customize the separator (', ' in the above example) to whatever you wish, even an empty string or a newline (`'\n'`) or work with actions like 'Create CSV table'.

Please let me know if this was helpful!