cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

PowerApps Portal : Entity List creation in Portal Management App is not allowing developers to choose "portal user attribute" and order by fields on secondary entity relation fields

Hi All,

 

Entity List creation in Portal Management App is not allowing developers to choose "portal user attribute" and order by fields on secondary entity relation fields

 

Scenario:

We have a requirement on process flow where at each stage multiple stakeholders can act on the same request/record, so we have created two entities A (Parent Entity) & B (Child Entity) as 1: N relationship. The request details are maintained in the parent entity and stakeholder details are maintained in the child entity at the CRM back-end.

 

To display the records based on the logged-In user, we have used the filter "Portal User Attribute" on the child entity field (where we maintained all the stakeholder details) and displayed in the table/grid.

entity list.png

 

 

But the parent entity record will always have the latest updated fields on each stage/status change. As we used the child entity as the primary entity for the above scenario we are not getting options in Portal Management App -> Entity list to sort order by modified field of Parent entity fields.

 

Please suggest if you have any solution on the same or else Power Apps Portal community should consider this scenario to make it more flexible to the developer in the upcoming releases.

 

Thanks

Shankar B 

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: PowerApps Portal : Entity List creation in Portal Management App is not allowing developers to choose "portal user attribute" and order by fields on secondary entity relation fields

Hi

 

I think instead of using the Attribute Filters, you should be using Entity Permissions

you can set parent/child entity permissions, and enable the entity list for permissions, this way it will automatically filter by the logged in user

it doesn't really matter where your lookup for contact is (as long as you have one).. if it is in Entity A, create the entity permission for Entity A and link to the contact lookup, then create another entity permission for Entity B, and set scope to Parent, setting the lookup for Entity A (this will automatically filter by contact lookup on the parent permission)

 

make sure to assign the parent entity permission to the Authenticated Web Role

 

https://docs.microsoft.com/en-us/powerapps/maker/portals/configure/assign-entity-permissions

 

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.




If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Power Apps Portals Super User


Oliver Rodrigues


 

Highlighted
Community Support
Community Support

Re: PowerApps Portal : Entity List creation in Portal Management App is not allowing developers to choose "portal user attribute" and order by fields on secondary entity relation fields

Hi @shankarbheem ,

Do you want to sort records in your Child Entity based on the Modified field in Parent entity?

 

If you want to sort records in your Child Entity based on the Modified field in Parent entity, I afraid that there is no way to achieve your needs in PowerApps currently.

 

Currently, there is no option supported in Entity List of Power Apps Portal to configure sorting records in your Child Entity based on the Modified field in Parent entity.

 

If you would like this feature to be added in PowerApps Portal, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (5,302)