Forum Discussion
Look up Field Power Automate
Hi Alyne
Your formula is an exact copy of mine for the dropdown you are referencing. If I'm viewing everything correctly, on the Client Prefix Number formula, change dropdown.selected.value to DataCardValue25.selected.value and it should all work.
If it doesn't double check the column you're referencing is the title column and not one you have created.
Rach 🙂
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!