I need Help with Actions?

[Admir0110]

Hi guys,

I need help with my flow specifically, choosing the actions. I have an Excel spreadsheet in which I save the date and email. Now I want to use Power Automate to automatically find matches. I want to match the dates that are the same but have unequal emails and write an email that they have the same date.

Currently I have 2 loops and then an if condition where I compare the date and email from the current loop with the one from the outer loop. But I just get false as a result of the If-Condition.

Can Someone help out? and maybe guide me into a right direction cause thats my first flow i created ^^.

Down here you can see my table and my flow.

[Chriddle · Accepted solution]

No need for loops and complicated conditions 😉

• Create an array of distinct dates (in the Select's From)
• Map the emails for this date using xPath
• Filter for records with more than one email

Select

From:

union(
	xpath(
		xml(json(concat('{"root":{"item":', outputs('Data'),'}}'))),
		'//item/Date/text()'
	),
	json('[]')
)

Map Date:

item()

Map Emails:

xpath(
	xml(json(concat('{"root":{"item":', outputs('Data'),'}}'))),
	concat('//item[Date="',item(),'"]/Email/text()')
)

Filter

From:

@body('Select')

Filter:

length(item()['Emails']) is greater than 1

Output:

[
  {
    "Date": "2023-05-02",
    "Emails": [
      "jim@example.com",
      "joe@example.com",
      "jane@example.com"
    ]
  },
  {
    "Date": "2023-05-03",
    "Emails": [
      "jim@example.com",
      "jane@example.com"
    ]
  }
]

[Chriddle · Accepted solution]

From this result, you can write the emails

To: 

join(item()['Emails'], ';')

Subject:

You have a date in common (@{item()['Date']})

Results:

and

[Admir0110]

Thanks for the help it works really well, but I can't use an array, I have to use an Excel file, because I get data from a Power App into Excel and want to process it further. Can I somehow create an array from my Excel file and keep the rest of the Flow? And how do I make sure that you don't get an email for old matches anymore?

[Chriddle · Accepted solution]

The output of your "List rows in a table" action is the array you need:

outputs('List_rows_present_in_a_table')?['body/value']

Either replace all occurences of "outputs('Data')" in my flow with the above

or simply use the following:

Additionally your date column is called "Datum", mine is called "Date", you also have to change this (in "Map Emails" and "Select From")

[Admir0110]

Thank you very much it works great! Is there a way to show my thanks by giving u a good review or something like that?

[Chriddle]

No, but I appreciate your kindness 👍