Is it even possible? Comparing two tables of information and then outputting one item from the 2nd table
I currently have a power automate flow that is working however I have asked to make a slight tweek. I can try to make a condition for every comparison (see below), however, I was wondering if its even possible to make it simpler.
Is it possible to make a table, where power automate will compare the input lets say "ABC" , go through the table until it finds "ABC" and then, with an established relationship to another table; recognize that the corresponding output would be "abc" and then output this?
There would be two data tables that would be needed and we would need to establish a relationship between the two tables so if input matches an item in table 1, we would be able to then have a choice for output for table 2. I.E
I have tried the AI building but that did not work, along with some googled answers in this forum along with other resources as well, however, I have not found a solution.