I have an array of items that I need to convert into a string. I need the text to go into a plain text email form which is submitted into our ticketing system.
I've tried various `join` and `concat` options but can't get the result I expect. The data comes from a multiple entries group/person field from SharePoint via a PowerApps form. I have transformed the data to an array, but this is where I am stuck.
I want to go from this:
[
{
"DisplayName": "Bob Jones",
"Email": "bob.jones@example.com",
"JobTitle": "Singer"
},
{
"DisplayName": "Jane Doe",
"Email": "jane.doe@example.com",
"JobTitle": "Lighthouse Painter"
}
]
To this:
Bob Jones - bob.jones@example.com - Singer
Jane Doe - jane.doe@example.com - Lighthouse Painter
Any help appreciated
