Power Platform Community Forum Thread Details

I am using a Vertical Gallery to select items from a sharepoint list, to view in a Form control. I now wish to add a Text control to search the Vertical Gallery as there will be many entries there to select from

The Gallery and Form operated properly together, until I added the highlighted Search operation below. I now get an error on the Form: "Invalid formula. Expected a value compatible with DataSource." I'm not sure what to do now, because the Gallery and Form are using the same DataSource.

Would appreciate help on getting the Form to now show a selected item from the gallery, that has been searched by a Text control. Thank you!

Gallery glyReportSelect > Items:

// Sort in descending order by Modified date
SortByColumns(
    // Filter on text entered to txtProjectSearch
    Search(
        // 'Project Name' is a lookup field in source sharepoint list and cannot be used for searching. Add new text column with the value of the 'Project Name' to use for search
        AddColumns(
            'Project Status Reporting',
            ProjectNameText,
            'Project Name'.Value
        ),
    txtProjectSearch_2.Text, 
    ProjectNameText, 'Report Month'
    ),
    "Modified",
    SortOrder.Descending
)
 
Gallery glyReportSelect > OnSelect:

// Clear any fields in the Form, and set the form mode to View
ResetForm(ProjectReportForm1_2);ViewForm(ProjectReportForm1_2)
 
Form ProjectReportForm1_2 > Items
// Display the item selected in Gallery
glyReportSelect.Selected
 
Additional context
Data source: Sharepoint List 'Project Status Reporting'