Forum Discussion
Look up Field Power Automate
Thanks again for the reply. In the SP list called “TestClient” i did rename the Title column to “Client Name”. Therefore the “Client Prefix Number” column is one I created.
Is this where my problem is. It’s still not working unfortunately. I will keep trying the (auto complete) options it offers to see if any other of those work for me.
A
hello_a_r The name of the column (which you can find if you hover within the list settings) will still be title so that's no issue. Are you able to click into the formula bar and take a screenshot with the error showing?
Thank you for all your help with this. Here is the screen shot showing the error.
The image below that shows the code in the original drop down we are trying pair up with.
Thanks hello_a_r - That's not showing me the actual error message. If you click into the formula bar so the squiggly lines are showing, then hover it will give you a message. The alternative is to click the stethoscope in the top right corner and navigate to the error message. Unfortunately your screenshot only tells me there's an error, not what the error is.
Thanks!
The entire line is underlined red and I cant seem to keep that red lines and the text that appears on hover when I go to take a screen shot. The text on hover says: "The function 'Lookup" has some invalid arguments"