Unanswered

Dataverse Table View Filter

(0) Share

Report

Posted on by sandeepganju

Hello,

I am new to the Dataverse and Model driven app however have done many things on Canvas App. I need to show users rows where their Email is present in a Single Text or Email type Column in an Table. I can see that we can filter in the view based on the Owner column but how can we do it in a customized column ?

in canvas app, we use User().Email and can filter in against any column and get out the rows .

thanks for your help.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @sandeepganju,
Is it related to any specific table?
If yes can you please share me the table name and column name so that we can share you the workaround.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
sandeepganju 15 on at

Like (0)

Report

hello ram prakash.
i have uploaded a snap shot of it. It can be any test table . the requirement is to know how we can filter view based on email of logged in user in a column other than owner

Capture.JPG

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @sandeepganju,

If you want to Use the filter in Model driven App then you want to use

RETRIEVEMUTIPLE plugin code to filter based on user login
Link for your reference : https://carldesouza.com/dynamics-365-retrievemultiple-plugin/#:~:text=In%20Dynamics%20365%2C%20we%20have,Microsoft.

if you want to filter in Powerapps then you can try below

Filter(tablename,capm = User().email)

tablename --> DV Entity Name
capm --> from the table

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No