cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trevorj19942
New Member

Creating Excel Workbook Flow w/ Ifs

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!! 


FNAMELNAMECODE1ACODE1BSTATUSDISCCODE2ACODE2BSTATUSDISCCODE3ACODE3BSTATUSDISCCODE4ACODE4BSTATUSDISCContracted AsContracted UnderSpecial Products
JOHNSMITHHUM2MORTACTIVEDISCRIPTION 1MSUPHGPAACTIVEDISCRIPTION 2EHIHGPAACTIVEDISCRIPTION 3HUM2WORTTERMINATEDDISCRIPTION 4   
ROBERTJOHNSONHUM2MORTTERMINATEDDISCRIPTION 1MSUPHGPATERMINATEDDISCRIPTION 2HUM2WORTACTIVESwift InternationalHUM5MECATERMINATEDDISCRIPTION 4   
MARRYSMITHMSUPHGPAACTIVEDISCRIPTION 1HUM2WORTTERMINATEDDISCRIPTION 2EHIHGPAACTIVEDISCRIPTION 3HUM5MECAACTIVEDISCRIPTION 4   
 
0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,640)