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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.