Hi
I'm trying to set up an alert if there is a duplicate in a Sharepoint list once it has been modified.
This is what I've tried, but it's not working, it sends the email but doesn't tell me what has been duplicated, so I can't get the HTML table to work, I think.
Trigger:
Initialize Variables:
Get Items from List:
Append to Array Variable:
Close HTML Table:
Check for Duplicates:
Send Email:
the concat should go inside loop
and to check open flow run page...and open the output of the final compose activity you would be able to see
for detailed explanation check my reply here https://powerusers.microsoft.com/t5/Building-Flows/Compose-an-Html-table/m-p/2806423
cheers
Thanks for your reply:
" Can you check the final html format created from the last append to string variable activity..from there we can see if html is proper"
I'm not sure how to do this?
and this "also here it should be like this with expression concat('<tr><td>',items('Apply_to_each')?['ID'],'</td></tr>')"
Where should the concat go? in the condition or somewhere else?
1. First check flow run history and check if get items is retreiving the right items
2. Can you check the final html format created from the last append to string variable activity..from there we can see if html is proper
also here it should be like this with expression concat('<tr><td>',items('Apply_to_each')?['ID'],'</td></tr>')
cheers
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1