Hide action in parent table basis the value in child table

[Aditya_K1999]

I have a parent table by the name of service booking with the action "Send Feedback". I want this action to be visible to the user only when, the status field of all the child records is equal to "Checked Out".

Please assist on the same.

[Suvrutt_Gurjar · Accepted solution]

In the parent table "service booking" , you should have a system generated reverse reference column titled something like [Related Child_Tables] where "Child_Table" is the name of the child table.

In the "Send Feedback" action's condition setting , please enter an expression something like 

ISBLANK([Related Child_Tables][Status] -LIST("Checked Out"))

Where [Status] is the column in the "Child-table"

[Aditya_K1999]

I actually figured it..

I created a VC matching the count of all services with checked out services. If the count is same, I assigned a text to it. And using that same text reference, I am keeping the action hidden or available.

Thank you though!

[Suvrutt_Gurjar]

Great. Could you share more details of your implementation? 

I am requesting this  because depending on your VC expression, we could evaluate if the VC will be sync time expensive.

[Aditya_K1999]

Sure Suvrutt.

IF(
COUNT(
SELECT(
Services Availed[Status],
[Booking ID] = [_THISROW].[Booking ID]
)
) = COUNT(
SELECT(
Services Availed[Status],
AND([Booking ID] = [_THISROW].[Booking ID],
[Status] = "Checked Out")
)
),
"All Checked Out",
"Not All Checked Out"
)

[Suvrutt_Gurjar]

Thank you.

My request will be to try the expression I suggested. This is so because my suggsted expreesion makes use of system generated rev ref columns. So the sync overheads are minimal. Also it is directly compured in the action condition rather than in a VC. A VC is calculated in each sync of the app.

On the other hand,  the VC you have created has two SELECT() statements that iterate over the entire "Services Availed" table. As the table grows that  VC will become increasingly sync expensive.

[Aditya_K1999]

Okay Suvrutt will do the same. Thank you!