Creating Excel Workbook Flow w/ Ifs

[trevorj19942]

Hello,

Working on a test project to provide proof of concept at work.

We have an Excel table with multiple columns and hoping someone can point me in the correct direction.

Our Excel input is outlined in the table below. 

My goal is to have Power Automate Desktop output a new Excel sheet with the breakdown as follows.

John Smith in the new sheet would be:

"Contracted As": Delegated  -- Due to CODE1A and CODE1B being HUM2 MORT and Status Active

"Special Products": Walk Ins Welcome -- Due to CODE3A and CODE3B being EHI HGPA and Status Active

Robert Johnson in the same new sheet would be:

"Contracted As": Lotus Trained -- Due to CODE3A and CODE3B being HUM2 WORT and Status Active

"Contracted Under": Swift International -- Due to CODE3A and CODE3B being HUM2 WORT and Status Active and DISC 3 would be copied into the "Contracted Under" column

Marry Smith in the same new sheet would be:

"Contracted As": Brokerage User -- Due to CODE4A and CODE4B being HUM5 MECA and Status Active

"Special Products": Walk Ins Welcome -- Due to CODE3A and CODE3B being EHI HGPA and Status Active

The major snag is that the same codes may appear in different code rages 1,2,3,4 for each person.

Meaning HUM2 MORT may not always be in CODE1A and CODE1B...

Any guidance or answers you can provide would be a great help!! 

FNAME LNAME CODE1A CODE1B STATUS DISC CODE2A CODE2B STATUS DISC CODE3A CODE3B STATUS DISC CODE4A CODE4B STATUS DISC Contracted As Contracted Under Special Products JOHN SMITH HUM2 MORT ACTIVE DISCRIPTION 1 MSUP HGPA ACTIVE DISCRIPTION 2 EHI HGPA ACTIVE DISCRIPTION 3 HUM2 WORT TERMINATED DISCRIPTION 4       ROBERT JOHNSON HUM2 MORT TERMINATED DISCRIPTION 1 MSUP HGPA TERMINATED DISCRIPTION 2 HUM2 WORT ACTIVE Swift International HUM5 MECA TERMINATED DISCRIPTION 4       MARRY SMITH MSUP HGPA ACTIVE DISCRIPTION 1 HUM2 WORT TERMINATED DISCRIPTION 2 EHI HGPA ACTIVE DISCRIPTION 3 HUM5 MECA ACTIVE DISCRIPTION 4