extracting data from PDF and then running switch case?

[RPate28]

Hello, I'm very new to power flow and want to automate a tedious process. While I have several issues, the one I'm looking at right now is this: 

I am using the AI model to extract text from a filled PDF form.  - No issues there. 

I can bring in the extracted text to the flow as dynamic content - No issues. 

However, I want to run a switch case on the dynamic content and this is where I'm running into issues as the power flow options are not intuitive to me as opposed to just inputting the code directly. 

Basically, from the pdf I have extracted the airport - expressed as three letter airport designation IE: EWR (dynamic expression : Airport) and Flight Carrier / Number (dynamic expression: Flight Carrier and Number). The latter populates on the form as the two letter carrier designation / flight number. IE: UA / 1886.  

What I want to do is to build a case that checks the airport code, and then looks at the carrier designation to determine what terminal the flight would be coming into. 

The value would populate into sharepoint which could then be utilized in word as quick parts. - This part I understand how to do. 

Let's say I have flight VS 183 from JFK the extracted portions from the pdf look like: 

Airport : JFK

Flight Carrier and Number: VS / 183

For determining the airport terminal, I tried a simple if(Airport="jfk" and contains(Flight Carrier and Number, "VS"), "Terminal 4", "null") in power flow to see if that would at least work. I get invalid expression. 

Even if I were to get it to work, I think it would be pretty ugly since I would have a bunch of contains and or functions within the if function to determine the terminal for each carrier. 

So I'm wondering would it be best to initialize a variable called "terminal" and then in power flow start a switch function that first switches between the three airports I'm looking at, and then another switch within each of those for the different flights with the operation being to fill in the value of the variable? 

Or is there a cleaner, better way to do this or is this not possible? I'm using flow from sharepoint rather than desktop. For reference I'd be looking at three airports: jfk ewr and lga. I'm looking at about 7 different carriers.

[grantjenkins]

What are you trying to do with each outcome? For example, If the airport was jfk and the carrier was VS, what would you do it that case that's different to another airport/carrier?

[RPate28]

The terminal would change. Ie: If it's JFK and VS the output would be Terminal 4. If its EWR and VS the output would be Terminal B. The outputs would be similar to different carriers/airports.

Essentially, I just want to create a statement that would populate the sharepoint list with the correct terminal so I can then bring it into word in separate documents pertaining to the flight. <- I didn't have a problem creating this in sharepoint calculated column (though it was ugly), however I'm unable to pass the calculated column into word.

[grantjenkins]

I would recommend creating another SharePoint List that contained at least three columns for Airport, Carrier and associated Terminal. Then in your flow, use Get items with a Filter Query on Airport and Carrier to get the item which would allow you to get the Terminal. Since you would only expect a single row returned, I'd also set Top Count to 1.