Creating a HTML table from filtered Sharepoint List
1: Get Items
2: Select - from body/value items above
3: Create HTML Table from outputs of Select
4: Compose : replace(replace(replace(body('Create_HTML_table'),'<','<'),'>','>'),'"','"')
5: Send Email
Issue in Step 2: Select
If i use the following value for Item Link
concat('<a href="', item()?['{Link}'], '">Link to item</a>')
It works and I get the hyperlink in the email
But If i use a custom column value for Item Link
concat('<a href="', item()?['{JobItemLink}'], '">Link to item</a>')
The email link shows this
concat('<a href="', item()?['{JobItemLink}'], '">Link to item</a>')
Don't know if it is the Compose part that is wrong or the Select value. It works if i use Link but not if i use JobItemLink
Thanks