I have created a Microsoft SQL Server connection in PowerApps (we are using AX 2009 on premises), where I generated an app out of SMMBUSRELTABLE (CRM Business Relations Table).
However, I can see that the data source contains data from all the company.
How do I specify in my data source the company that I want to get data from?
Thanks in advance!
Is this issue in regards to security and hiding specific data from specific users, or would this issue be solved with a dropdown that users can select to filter the data?
If you can use a dropdown list with all the different company names, you can use the Distinct function in the Items property of the dropdown list:
Am I misunderstanding?
Sample Expression: Filter(DataSource,Company Name = "Company1")
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
This is an issue of permission and "limitation". There are very few people who have permission to access all companies.
Additionally, I also only want to create an app from one specific company so filtering does not really help?
I suppose my data source will still contain data from all companies despite filtering because it simply "hides" it in PowerApps, is that correct?
Thanks in advance.