Cloud Flow
Neil Haddley โข February 26, 2024
A Topic that uses the Business Central Connector
Power PlatformMicrosoft DynamicsBusiness CentralPower Automate and integrationcloud-flowpower-automatebusiness-centralconnector
I created a Topic that used the Business Central Connector to retrieve the list of "Evaluation" Company Customers. I used a Cloud Flow to workaround an issue.
Under the hood: From text to a table
The flow returns the body of the response as text, using the string() function. The Topic cannot loop over text, so I used Parse value with a schema that I made from sample JSON, and saved the result in a table variable. Then Concat(Topic.Var1,displayName,", ") joined the customers' display names into one message.































