Powerapps portalAssociate current portal user vs a text field in my entity

[hmedhat]

PowerApps Portal

1-I created an entity for records I get the data from the SQL and there is a column called UserEmail in this entity type text.

I want when I user sign in to my portal i want him to see his only records according to UserEmail Field.

My issue is when I selected Associate current portal user  it's need a lookupfield and my UserEmail is a textField .

[EricRegnier · Accepted solution]

Seems like a duplicate post? I responded here: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/I-want-to-filter-the-entity-record-...

Cheers

[v-xida-msft]

Hi @hmedhat ,

Could you please show more details about your scenario?

Do you want to filter the records within the Entity List in your Portal based on the UserEmail Field?

Regarding the needs that you mentioned, I think you want to filter your Entity List records based on the UserEmail field value against the current sign in user?

Currently, I afraid that there is no direct way to achieve your needs in Power Apps Portal. As an possible solution, you could consider add a Contact LookUp field in your Entity, then bind each record in your Entity to proper Contact record. Then you could configure the "Portal User Attribute" to this Contact LookUp field under the "Filter Conditions" part of General tab of your Entity List, then your Entity List records would be filtered by the current sign in user:

please check and see if the following thread would help in your scenario:

https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/266160/how-to-filter-entity-list-r...

As another possible solution, you could consider try the Liquid expression to achieve your needs. You could use the following Liquid expression to render a Entity List in your Portal screen:

{% entitylist id:page.adx_entitylist.id %}
{% endentitylist %}

Then you could use EntityView Liquid object to render Entity records in your Portal screen (Put the EntityView Liquid object inside the entitylist tag):

{% entityview id:xxxx %}
{% endentityview %}

then you could apply metafilter to the EntityView.

Please check and see if the following article would help in your scenario:

https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/render-entity-list-current-page

https://docs.microsoft.com/en-us/powerapps/maker/portals/liquid/portals-entity-tags#entitylist

Regards,

[hmedhat]

Thanks @v-xida-msft 

Thanks @EricRegnier .

First you can't register duplicate emails second you are right i want to filter based on the login user email vs a text field in my entity .

Example :

name          email              age    role

hani	hani.ds@r.com	32	a
eric	eric.asd@df.com	31	a
alex	alex.asd@sad.com	28	b
hani	hani.ds@r.com	32	c
eric	eric.asd@df.com	31	d

I want to filter the view for the above entity with column email with the login portal user .knowing that the email is a text field.

[v-xida-msft]

Hi @hmedhat ,

Have you tried the solution @justinburch provided in the following thread?

https://powerusers.microsoft.com/t5/Power-Apps-Portals/Associate-current-portal-user-vs-a-text-field...

Please try the solution @@justinburch provided in above thread link. I agree with his thought almost. Please try it, then check if the issue is solved.

Note: Currently, I afraid that there is no direct solution to achieve your needs in Power Apps Portal.

Regards,