cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yahya
Kudo Kingpin
Kudo Kingpin

Field Security Profiles not working

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Yahya
Kudo Kingpin
Kudo Kingpin

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

 

 

 

 

 

View solution in original post

4 REPLIES 4
EricRegnier
Super User II
Super User II

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

Yahya
Kudo Kingpin
Kudo Kingpin

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

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
Kudo Kingpin
Kudo Kingpin

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

 

 

 

 

 

View solution in original post

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 (2,165)