Power Platform Community Forum Thread Details

hi Expert

i have a dropdown

i have a screen where i am trying to display a gallery which is a relational table.

situation: 1. from based on the client id i am trying to get the policy details which is in separate table.

i have three different type of policy and those policy type is mentioned as a dropdown

code used to get the policy number. but no record is displayed even though i have a policy.

If(PolicyTypeDD_1.Selected.Value="CP Policy Info",Sort(Filter(POLICY_CP_INFO,CLIENT_POLICY_INFO_ID=LookUp(CLIENT_POLICY_INFO,POLICY_INFO_ID=LookUp(CLIENT_INFO,Source_Client_ID=selected_Case.Case_ID).ClientInfo_ID).ClientInfo_ID),PolicyNumber),PolicyTypeDD_1.Selected.Value="RC Policy Info",Sort(Filter(POLICY_RC_INFO,CLIENT_POLICY_INFO_ID=LookUp(CLIENT_POLICY_INFO,POLICY_INFO_ID=LookUp(CLIENT_INFO,Source_Client_ID=selected_Case.Case_ID).ClientInfo_ID).ClientInfo_ID),PolicyNumber),Sort(Filter(POLICY_RI_INFO,CLIENT_POLICY_INFO_ID=LookUp(CLIENT_POLICY_INFO,POLICY_INFO_ID=LookUp(CLIENT_INFO,Source_Client_ID=selected_Case.Case_ID).ClientInfo_ID).ClientInfo_ID),PolicyNumber))

error: