Look up Field Power Automate

Hi rachelcackleberry 

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