Hi @psrini20
See the below demo flow
This is the table with sample data in excel file
Demo flow
1. For this, you have to create a scheduled flow which runs every day at particular time (at start of day for example)
2. Use compose action to write an expression which helps to get the previous date in format d-MMM
Expression: formatDatetime(addDays(utcNow(),-1),'d-MMM')
2. Use list rows in table to list all rows present in table
3. use filter array to filter the previous date column where value not equals to Y
4. Use select action to select required columns for html table
you have to add the column details like below for first 3 columns as shown below item()?[column name] format
for last column to be added , follow same appraoch as well
5. use Create html table to create html table out of select action output
use send email to send email to supervisor like below
below expression is used to add borders to html table
replace(body('Create_HTML_table'),'<table>','<table border="1">')
Results would be like below
Hope it helps !
