Hello all,
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
Table 1 | Table 2 |
ABC | abc |
DEF | def |
GHI | ghi |
JKL | jkl |
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.