Share
ReportHello,
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!!
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
All responses (
Answers (
237
