Hello
In CDS
I have a table called Companies which has two fields one is called Company and the other is called user which contains the user email.
Is it possible to create a view where when the powerapp starts it filters automatically with a view of only companies which belong the user.
I dont want to create a filter at the powerapp but rather at the entity level . Is this possible
Thanks
Marco
Hi @mpezzutti ,
You can do this by adjusting your Companies entity (table) slightly. Instead of having a field that is the users email you can use the out-of-the-box Owner field which comes with each entity. Using this field, you can then create a filtered view which has a condition to filter Companies where the Owner is equal to the current user. Similar to how the OOTB "My Accounts" view works.
Then in your Power App, you can set the filtered view as part of the datasource so that Companies are pre-filtered rather than doing the filtering in the app.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
17 | |
11 | |
9 | |
6 | |
4 |
User | Count |
---|---|
24 | |
18 | |
18 | |
15 | |
11 |