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
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Don't miss the call this month on June 16th - 8a PDT