Power Platform Community Forum Thread Details

Hi all, I have a Power Automate flow that involves a Select block outputting a list JSON objects with key "N"! I would like to extract and concatenate the values of those objects into a single string. I process the output of the "Select" block with a "Compose" block within a "For each" that extracts the value.

The "Compose" works as expected! The issue is that I've added a "Join" block after the "For each" with input `@outputs('for-each')?['Compose']`, and testing it results in error:

"Unable to process template language expressions in action 'Join_1' inputs at line '0' and column '0': 'Required property 'from' expects a value but got null. Path ''.'."

Am I use the wrong input for the "Join" block"? Alternatively, is there an easier way I can extract and concatenate the results of a "Select" block?

Categories:

Building flows

Hi there!

If I understand correctly, you can do something like this:

suppose you have some "N" values like this.

[
  {"N":"AZ"},
  {"N":"CA"},
  {"N":"NV"}
]

and the desired results are AZ, CA, NV

no apply to each required.

join(
  xpath(
    xml(
      json(
        concat(
          '{"root":{"item":',
          string(outputs('Compose_N')),
          '}}'
        )
      )
    ),
    '/root/item/N/text()'
  ),
  ', '
)

I hope this helps you keep going tonight!

------------------------------------------------

💡 If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom   ~ LinkedIn - tomrice.ai

⭐ MICROSOFT CERTIFIED ⭐

AI & Copilot: AB-100 | AB-730 | AB-731 | AI-900
Power Platform: PL-600 | PL-500 | PL-400 | PL-200 | PL-100 | PL-900
Fabric, Power BI & Data: DP-700 | DP-600 | PL-300 | DP-900 | MCSA | 70-778 | 70-779
Dynamics 365: MB-210 | MB-240 | MB-910 | MB-920
Security: SC-900
Azure: AZ-900
Microsoft 365: MS-900
Excel: 77-728 | 77-888
Applied Skills: 19