Hi,
So every night a .csv file gets copied across onto my personal (not business) OneDrive.
What I want to do is create a Flow that works out if any of the rows have 999 in them in the column called System.
The .csv file looks like follows:
| Date | Time | Meet | No. | Qualifier | System |
| 23/02/22 | 6.3 | KEMP | 5 | Blue Flame | Fav |
| 23/02/22 | 7.3 | KEMP | 3 | Shanko | Test-999 |
For reference, it does not come as a table as default as it is a .csv
Simply put I want it to send me an email to either:
1) open the csv file up to see the lines which contain 999
or
2) give me within the email body those rows which contain 999