Client is using SharePoint list to maintain information about products (Product Catalog). SharePoint item form is customized using PowerApp (Product Card). There is another SharePoint list Q&A with lookup column ProductSKULookup from Product Catalog list.
PowerApp has two screens - 1) Product Card 2) Q&A
Product Card screen has SharePoint Integration control wich contain text field ProductSKU. Q&A screen has Gallery control with data source from Q&A SharePoint list.
What would be the formula to filter the Q&A Gallery control so that it show only Q&A related to the selected Product?
Tried formula Filter(QA, DataCardValue6.Text in ProductSKULookup) and it retrieves error Invalid argument type. Cannot use Record values in this context.
I did get the result using text column in the Q&A list instead of lookup column and using formula Filter(QA, DataCardValue6.Text in ProductSKUText). It is important to have the ProductSKU as lookup column in the Q&A list instead of a text, moving forward. That is the reason I am asking for your help.