How to search for Lookup Column in a Collection , coming from DataVerse.

[bkumar]

Dear Experts,
I have a problem with below piece of code

 Working Line ( though for the collection RiskData, evaluation is not available for any lookupdata, when i click on )
Set(RiskData, Filter(ICSRisks, Year.Name = drp_Home_Year.Selected.Name && 'Sub-Process'.'Sub-Process Code' <>"" ));

Used This one from @gdiegoli  to make it working:- https://powerusers.microsoft.com/t5/Building-Power-Apps/Common-Data-Service-Returns-no-data-from-a-L...

Need Help on below , I want to do search on the lookup column 'Sub-Process'.'Sub-Process Code' , but while doing the below operation The function search has some invlaid arguments, i am not sure how to pass the lookup column as "Column to be searched" in below code

Search(RiskData,"SearchString Key ",'Sub-Process'.'Sub-Process Code'); 

Any Help will be much appreciated, Thanks and Regards

[SanmeshG]

Hi @bkumar ,

Can you share the screenshot of the collection with the items?

[bkumar]

Hi @SanmeshG , Please find the screenshot attached

[bkumar · Accepted solution]

This one from @v-yutliu-msft , solved my problem

 https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Search-Lookup-Column/td-p/494358

[bkumar]

Also to handle this column in Default of a combo box

The `Default` property of a ComboBox expects a table or a single record from the data source, but in your `If` statement, you're potentially returning `Blank()`, which is not a record or a table.

Here is a modified version of your formula:

```PowerApps
If(
varAddRiskItem = true,
{Value: Blank()},
If(
varEditRisk = true,
{Value: defaultGalleryRiskItem.'Sub-Process'.'Sub-Process Code'}
)
)
```

In this modified formula, instead of returning `Blank()` when `varAddRiskItem = true`, it returns a record with one column named `Value` that contains a blank value. This should be compatible with the ComboBox's `Default` property. It does the same thing when `varEditRisk = true`, but uses the value of `defaultGalleryRiskItem.'Sub-Process'.'Sub-Process Code'` instead of a blank value.

Please replace `Value` with the appropriate column name from your ComboBox's data source if `Value` isn't correct. Also, ensure that `defaultGalleryRiskItem.'Sub-Process'.'Sub-Process Code'` is a valid reference to a value from your data source.

Finally, if `varAddRiskItem` and `varEditRisk` are both false, the `If` statement won't return anything. If you want to handle this case, you may need to add another condition or a default return value.