Hi I have a gallery with different reports, this reports I created them in a SharePoint list.
Then I also have the Sub Tasks of the reports, that I created in another SharePoint list.
I want when selecting a report from the gallery, navigate to other screen and in the new screen only see the related tasks with the report.
I have the first sharepoint Reports List classified with this
And in the sub task share point list I created a Lookup code
I have created this formula in an icon of the gallery:
Set(
varSubTaskFilter,
galRep_1.Selected.Code
);
Navigate('Reports Sub Tasks')
In the new screen I have this:
//Filter('Reports Sub Tasks',('Code Lookup').Value = galRep_1.Selected.Code)
But is showing different errors:
-It says is "Table Value" and it was expecting "Value" or "Number"
-Only blank gallery without errors
-Showing all sub tasks to all of the reports
