I just noticed this error on our app today:
"A cycle is detected in the component. This can result in undefined and erroneous behavior. It will eventually be marked as an error."
As far as I can tell, the app is still functioning correctly.
A couple of weeks ago, I did add a variable("Assigned Driver") to a user role security function (see italics):
IFS(
ANY(Current_User[Role]) = "Admin",
TRUE,
ANY(Current_User[Role]) = "Manager",
[Reassign Driver].[Branch] = ANY(Current_User[Branch]),
ANY(Current_User[Role]) = "Project Manager",
OR(
[Reassign Driver] = USEREMAIL(),
AND(
[Reassign Driver].[Branch] = ANY(Current_User[Branch]),
[Reassign Driver].[Role] = "Driver",
[Job Type] = "Project"
)
),
TRUE,
OR(
[Reassign Driver] = USEREMAIL(),[Assigned Driver]= USEREMAIL(),
IN(USEREMAIL(), [Assigned Team])
)
)
Here is the original expression:
IFS(
ANY(Current_User[Role]) = "Admin",
TRUE,
ANY(Current_User[Role]) = "Manager",
[Reassign Driver].[Branch] = ANY(Current_User[Branch]),
ANY(Current_User[Role]) = "Project Manager",
OR(
[Reassign Driver] = USEREMAIL(),
AND(
[Reassign Driver].[Branch] = ANY(Current_User[Branch]),
[Reassign Driver].[Role] = "Driver",
[Job Type] = "Project"
)
),
TRUE,
OR(
[Reassign Driver] = USEREMAIL(),
IN(USEREMAIL(), [Assigned Team])
)
)
Is this something I should be worried about? If so, how can I correct it keeping the same intent as edited formula?
If a driver is "Assigned Driver" of a customer and the customer's "job" has be reassigned to another driver ("Reassign Driver"), the "Assigned Driver" can see who has been reassigned to the job.
As the first expression written, it works. I am not sure why the error message is just now popping up.
Please advise.
Thanks,
Lee
LinkedIn
Twitter
