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.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.