Forum Discussion
Look up Field Power Automate
Hi hello_a_r !
You're on the money there. You will be able to achieve that with a lookup.
Keep in mind I am guessing your list/field names, you could try something like:
LookUp('Client Name List', Title = Dropdown.Selected.Value, Client Prefix Number)
This is essentially saying in my Client Name List, I want you to pull all the titles that equal this dropdown, and return the corresponding Client Prefix Number.
Hope this helps!
Rachel
Thank you very much for your suggestion, but may I ask if you could review my attempt below. It doesn't seem to work for me. Thank you in advance.
This is the SP list connected as a data source.
List Name: TestClient
ID: is the SP generated ID
Client Name: single line of text
Client Number: number
Active: choice (my hope with this (later) is to only populate the "Active" clients in the dropdown)
The SP list name we are adding entries to is called: TestP
The list above "TestClient" is added to "TestP" as a connected data source
This is the formula in the "Client Name" field (Dropdown) which is pointing towards a column in a SP list data source with the Client Names.
TestClient.'Client Name'
Note: I did start this with the "LookUp" function but it must have shortened the code to the above automatically. This results in a drop down list which allows me to select the client name.
This is where it shows how new I am to all this. I'm having trouble getting your code to work, I think its starting to breakdown at the "Title" and I am guessing it needs to be a value in the "Datacard" perhaps? The next image shows the error with your suggestion.
Thank you for your time Rachel, it is much appreciated.
Alyne
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 🙂
- Hi Rachel,
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.
Ahello_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?