Hi,
I have a field “Name of Product” in which I want values to be pulled from a table “Curtain Rod” and the fields on basis in which the values to be pulled is “Size of Curtain rod” which exists in both tables. The issue I am facing is the matching values aren’t being returned as a drop down. I have added the following formula in App formula field : ANY(Select(Curtain Rod[Name of Product],([Size of Curtain Rod] = [Size of Curtain Rod]), TRUE))
Attaching screenshot of the way field is being displayed in Form.If can guide me where I am going wrong