Skip to main content

Notifications

Community site session details

Community site session details

Session Id : cLbT/Wyhty3n7yEU8iuuy2
Power Apps - Microsoft Dataverse
Answered

Field Security Profiles not working

Like (0) ShareShare
ReportReport
Posted on 26 Nov 2020 22:12:47 by 513

Out of a sudden, field security profiles not working. I get this error when I want to check Field Permission

 

Microsoft Dynamics 365
To use this saved view, you must remove criteria and columns that refer to deleted or non-searchable items.

Timestamp: 
Service Request Id: 

 

I have created a ticket and it has been 5 to 6 weeks Microsoft busy checking!

I was asked to copy my environment more than 5 times for their team to inspect.

 

Poor.

 

Anyone facing such?

 

  • Verified answer
    Yahya Manasrah Profile Picture
    513 on 11 Dec 2020 at 07:44:12
    Re: Field Security Profiles not working

    It was early OCT when I created the support ticket. no success despite many sessions and environment copies etc, until recently.

     

    What I can confirm that there is a bug. Read the following: -

     

    What has caused the problem is that in one custom Table, I created an image column, and set its field permission enabled. 

     

    Microsoft suggested that I delete that Table, was a hard time for me but I did. The new Table didn't have an image field anyhow.

     

    I eventually have deleted the old Table (which enabling its image field security created the problem). 

     

    The problem would still exist.

     

    I read online to realize that fields with their field security enabled are listed in a Table called Field Permissions. No access to this Table via the portal, I accessed it via Excel add in.

     

    Weird enough the Image column that I enabled its field permission in the Table that was deleted, was still existing in the Field Permission Table.

     

    I tried to delete that record, with no success.

     

    After 6 weeks, I guided Microsoft to delete that record, was done, and then my system was working perfectly again.

     

    I had a call from the Microsoft team manager to apologize, I said its fine, the whole year was hectic by all means. I only meant to guide the team behind of this bug.

     

    Bottom line, do not enable field permission on image columns, I guess also on file columns

     

     

     

     

     

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 11 Dec 2020 at 07:01:22
    Re: Field Security Profiles not working

    Ok let me know how that goes. Field Level Security is a pretty mature feature. I'll be surprised if it's a bug.... Possible to share more info to help?

  • Yahya Manasrah Profile Picture
    513 on 08 Dec 2020 at 20:29:32
    Re: Field Security Profiles not working

    this must be a bug. i have raised a support ticket.

  • EricRegnier Profile Picture
    8,714 Most Valuable Professional on 29 Nov 2020 at 06:28:36
    Re: Field Security Profiles not working

    HI @Yahya,

    Are you still having this issue? To isolate the problem, try the following things:

    1. Does it work as a system administrator user which should by default have access to field level security?
    2. Create a dummy table with field level security enabled fields and a dummy (field security profile) FSP. Test with a user (or a test account), make sure the user is part of the new dummy FSP.

    Let me know how that goes, cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,660 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

Leaderboard

Featured topics

Loading started