Add Meal of the Day from Parent to Child Record using Action

[EmadK]

Hi Appsheeet Community,

I am creating a lunch-ordering app.

On the new order page, I have an action "Add Todays Item". I want to set this up to add to lookup the Menu table, search for [Item Name], referenced by the day in [Day Available] enumlist.

The action is on the Customers table. Orders are added to Orders table. I am using the following expression. It works on the Order table but when used on the Customers table, it can't find the column [Day Available]

ANY(
Select(Menu[Item Name],
[Day Available] = INDEX(LIST([_THISROW].[Day Available]), WEEKDAY(TODAY()))
)
)

How do I tweak this expression?

Thank you.
@Suvrutt_Gurjar your help is greatly appreciated!

[Steve]

Maybe this?

LOOKUP(
  WEEKDAY(TODAY()),
  "Menu",
  "Day Available",
  "Item Name"
)