Hello! My department has been using Power BI to identify anomalies in transactions (from a large ERP) that other groups and we need to research. We want to create a Power App interface/workflow for all of us to track follow-up & perform a root cause analysis on these anomalies. We are not technically sophisticated, but Power Query & Power Apps have been in our abilities. Because of the large number of users, we are limited to the basic version of Power Apps that I believe only allows either Excel or a SharePoint list as a backend. Basically, the Power App back-end should be one record for each unusual transaction with a number of fields from the Power BI analysis (Transaction ID, Location, Customer, Transaction Date, $ Amount) and 3 user-populated fields (Status of Research, Root Cause Bucket, Comment). How do we get the unusual transactions identified by the Power BI analytic into the Power App backend?
