Power Platform Community Forum Thread Details

Hi guys, I'm looking into sending an email that contains ONLY the newly added data from the excel file. The data in the excel file is illustrated in the following screenshot below:

So for example, the newly added data into the excel file are ['Key'] = 1235, ['Date'] = 9 July 2024 and ['Level'], illustrated in a red circle in the screenshot below:

The data in the ['Key'] column are all unique. When all the newly added data is added into the excel sheet, all newly added ['Key'] is added and in ascending order shown in the screenshot above. So each time there is a newly added data into the excel sheet, the data in ['Key'] column would be in an increasing order.

Therefore the scenario is, whenever there is a newly added data into the excel file, it would trigger the flow to run in Power Automate through using the SharePoint's "When an item or a file is modified". Referring to the screenshot that was marked with a red circle, after that a condition would be derived in the "Filter Array" action such that if the latest newly added data in the ['Key'] column (denoted as 1235 in a red circle in the above screenshot) is greater than the previous data (denoted as 1234 located in the second row in the screenshot above), then it would proceed to send ONLY the newly added data in the email.

The issue is that I'm not sure how to derive it as a condition in the "Filter Array" such that if the latest newly added data in the ['Key'] column (denoted as 1235 in a red circle in the above screenshot) is greater than the previous data (denoted as 1234 located in the second row in the screenshot above) and then send email with the newly added data of ['Key'], ['Date'] and ['Level'].

This is my flow in Power Automate so far: