In SQL Server, I am having two tables: Project_Data(Project_ID, Customer, Project_Number) and Task_Data(Task_ID, Project_ID, Task_Number, Details, Date) where Project_ID and Task_ID are Auto_Generate ID's.
Now, In Powerapps:
I am having ProjectListGallery(Items Property to Project_Data Table) in which I am showing Project_Number, Customer. Along with these two Fields I need to show Count of Tasks for Particular Project.
As Task_ID is not there in Project_Data Table, How should I get Count of Tasks for Particular Project from Task_Data Table.