Get value of field from parent row

[StephenSaid]

Hi, 

I only want to show the Add button under the related records list if the Status of the parent record is set to 'Draft'. The following is always returning false. Not sure what is wrong.

ANY(
  SELECT( TransferHeaders[Status],
    IN( [_THISROW], TransferHeaders[Related Transfers] ),
    TRUE )
) = "Draft"

[Aurelien · Accepted solution]

Hi @StephenSaid 

You may want to use another path.

Here is a sample app to help you: Restrict_InlineAdd

Basically, you use a slice which is a copy of your inline table, with read-only permission.

And you create a twin-column of your [Related xxx], which will take its ref source to the slice.

Then, this is a condition to add on the show_if condition of these two columns.

Because of the restriction on the slice (which is read-only, hence without any add permission), the app won't display the "Add" button.

Result is here:

[StephenSaid]

No way I would ever thought about this solution! Works wonderful.

Thanks

[Aurelien]

Happy to help 🙂