cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

create views based on unique records in another entity

I am looking for a way to autocreate views based on unique records in another entity. Here's an example to hopefully show what I'm looking for:

 

Entity 1: property

Entity 2: Asset

 

Each property will have many assets, so I want to be able to create a view specific for each property that shows only the assets related to that property.

 

The end goal is to be able to pin the property asset view in a teams channel.

 

Is it possible to autocreate views? Or is there a way to automatically apply a filter when a view is pinned in Teams?

 

Given the volume of properties we are dealing with, manually creating the views is becoming unmanageable. 

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Anonymous ,

 

Yes, the following context variables from Teams are supported to pass into embedded canvas app. Hence the gallery can be filter based on which channel the app is in. Reference: Use context from Teams 

  • locale
  • channelId
  • channelType
  • chatId
  • groupId
  • hostClientType
  • subEntityId
  • teamId
  • teamType
  • theme
  • userTeamRole

Hope this helps.

Sik

View solution in original post

5 REPLIES 5
v-siky-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you please share more details on your app?  Has the 1:N relationship been established between two Entities.

If you are referring to the Entity View, I'm afraid it's not supported, there is no OOB tool to create Entity View automatically.

 

If you just want to display all assets related to specific property you selected from Gallery, please try with the following code to display in a gallery/data table.

Filter(Assets, LookupField.Property= PropertyGallery.Selected.Property)

Hope this helps.

Sik 

EricRegnier
Super User II
Super User II

Possible to share a little more details? Are you using canvas app with a CDS backend or model-driven apps? Cheers

Anonymous
Not applicable

Hi @v-siky-msft and @EricRegnier 

 

It's a model driven app at the moment.

 

The relationship is a 1:N and has been established.

 

The end goal is to be able to have each view pinned to a channel in Team - Each property has its own channel. The asset views are not the only ones we would need to create, there are other similar situations.

 

With the goal of teams in mind, if we used a canvas app, is it possible to easily have it filter the gallery based on which channel it's pinned to? Or would it be a case of manually creating a gallery for each property?

 

Thanks for your help!

 

Hi @Anonymous ,

 

Yes, the following context variables from Teams are supported to pass into embedded canvas app. Hence the gallery can be filter based on which channel the app is in. Reference: Use context from Teams 

  • locale
  • channelId
  • channelType
  • chatId
  • groupId
  • hostClientType
  • subEntityId
  • teamId
  • teamType
  • theme
  • userTeamRole

Hope this helps.

Sik

View solution in original post

Anonymous
Not applicable

Hi @v-siky-msft 

 

This looks promising. Canvas isn't the first choice, but it could work for what we need.

 

I have heard it could be possible to create views using an api. We are looking into that first, but if we can't get it to do what we need, canvas looks like a good back up plan.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,650)