Use automate to find keywords in Excel and enter new data

We receive Excel data sets every day which have hundreds of lines of raw text, we need to quickly search the Excel sheet for several keywords and build a couple of new columns in that spreadsheet and enter a relative new value.

E.g. if the text were to contain say the following key words: No commitment, Safety, Threat; Then we would like to 3 new columns added showing No Commitment - Safety - Threat.

We can then use that spreadsheet to filter those logs we don't need to review and those which we do.

We would also like to search a particular column which holds post codes, and to add a new column which will add the correct District; for any district outside our borders, we want to identify this, so they would get classed as 'outside' - 'our district' or 'unknown'.

This data comes in everyday via excel and its too time consuming to just do conditional sorting, and I want to build this into a Power BI document with the objective to give the Officer an overview of what is coming in and therefore manage their time better - not just quantify the raw data for reporting.

The objective is to over-wright the data each day (its a manual import) so this filtering should ideally run automatically.

Quick Links

Leaderboard > Power Automate - General Discussion