Email not recived

[JoachimHodnelan]

Hi, 

Can anyone see any obvious reasons why i dont recive the email from the flow, as the end action? 

My flow is about -> Get items that equals <today> in column "Publisertdato" -> Make a list view of the items -> send email. 

Test and running is succeded (several times), and output from get items is correct. 

Before i composed, the email gets through as single one and one email with the output. 

Troubleshooting done without any results: 
-Building the flow new from the scratch 

- Trying to send the "message" in teams 

- Trying different emails 

- Trying to put the rows in a excel sheet (works) 

- Log in log out 

Thanks for any input 

[SanshubhLubal]

Hello @JoachimHodnelan 
What is the output of get items?

[Pstork1]

The main thing I see is the Filter query in the Get Items.  SharePoint always stores Dates as a combination of Date and Times. Even Date only columns are stored as a date at midnight UTC time. So when you check to see if the SharePoint date is equal to today its never going to match because the time portion of the date will be off.  Check the results of a recent run and I suspect you will find that your Get Items isn't returning any results.  You'll probably need to change the filter to use a range less than or equal to today at midnight and greater than yesterday at midnight.

[JoachimHodnelan]

@Pstork1 I tought initialize variable from date format to string would solve this, and then also read the get items as string, for the match. If this was the issue, it would be confirmed if get items isnt returning any results right? 

It returns the correct items from the list. 

@SanshubhLubal It returnes every value from the Sharepoint list. Maybe a dumb theory, but can the output be to big? There is a lot of values in the output. 

[Pstork1]

So is the problem that you aren't getting any emails or that you are expecting one email with all the items and instead getting one email for each item? If its the latter then its because the send an email action is inside the loop. If you want all the items in one email then use a Data Select to pick the columns you want form the Get items and then create an HTML table from that output. Then put the html table in the email. If you only want one email you don't need the loop.

But if its that you aren't getting any emails then I'm not sure what the problem is if Get items is producting the list of data you want.