Look up Field Power Automate

Hi hello_a_r ,

I was just wondering if there's a reason you're not using the built-in SharePoint lookup column in your TestP list? That is, in the TestP list, make ClientName a lookup column (in SharePoint) to the TestClient list's Title column, and also tick the box in the lookup settings to include the Client Number. That way, when someone enters a new item in the TestP list, they can select the ClientName from a dropdown, and the Client Number will also automatically be populated.

This works whether or not you're using Power Apps to customize the form. That is, if you use the standard SharePoint new item behavior, you'll get that dropdown experience for the Client Name, and the Client Number will be automatically populated also. Or, if you still want to customize the form in Power Apps for some other reason, then the lookups are already done for you. Power Apps would automatically use a formula such as Choices([@TestP].ClientName_x003a_ClientNumber) for the Client Number - but you wouldn't even need to display that on your New Form, since it'll be provided automatically by the SharePoint lookup.

Could this make sense for your scenario...? I apologize if I've missed something about what you're trying to achieve...

Sandy