Share
ReportI am attempting to build a PowerApp using the PowerBI Integration.
In Table 1 ('quota table'), I have a list of sales amounts for Customers A-E including sales rep IDs.
In Table 2 ('sales reps'), I have a list of values for all sales reps, including ones who haven't sold anything (Fred).
I'd like to be able to populate in a Power Apps drop down, ALL sales reps that are available, whether or not they are assigned to a customer or have sales.
However, in the Power App, when I pull these fields in ('quota table'.customer, 'quota table'.amount, 'sales rep'.name), I can only access the sales reps that have sales.
How do I access ALL sales reps? It seems like the Power App is filtering out sales reps without sales numbers.
Categories:
All responses (
Answers (
395
