Hello @abm I am trying to create an app which is connected to two SharePoint lists with same column names and column types. One is forecasted expense and the other is actual expense. I wanted the user to be able to compare the two SharePoint lists on a click of a button and the variance to be displayed in PowerApps. Eg. resource A was supposed to claim 500 USD as per the forecast for the month of Jan 2021 but in actuality he claimed 200 USD in Jan 2021 then the table in power app should show the details: resource name, month, forecasted and actuals and variance.
The SharePoint lists contains columns: Resource Name (people picker), Expense Amount (Number), Expense Description (Single text), Expense type (choices), Billable/Non billable(choices), Month(Choices), Year(Choices).
Also, there can be more than one entries for a resource with difference expense types, expense description and expense amount for a month. The comparison should be done according to the total expense amount claimed by the resource for that particular month (irrespective of the expense type/expense description).
