You’re offline. This is a read only version of the page.

Power Apps

Answered

Named Formula is Unrecognized or Unsupported

(0) Share

Report

Posted on by rwittels

510

Hi. I have a Supplements table with thousands of rows. The Supplements table has a booking_id column.

Using this formula, I am able to get the price of supplement number 13 from booking 1160 without delegation issues:

LookUp(Filter(JHB_Supplements_List;Value(booking_id)=1160);supplement_nb=13).price;;

Adding this to a named formula also works:

supp13Price = LookUp(Filter(JHB_Supplements_List;Value(booking_id)=1160);supplement_nb=13).price;;

using 'supp13Price' always gives me that price.

I need to get the value 1160 (booking_id) dynamically so I have tried this formula:

suppPrice13(suppID:Number):Number = LookUp(Filter(JHB_Supplements_List;Value(booking_id)=suppID);supplement_nb=13).price;;

When I try use suppPrice13(bookingNumber) I get the error Unrecognized or Unsupported formula. Even if I type suppPrice13(1160) it doesn't work.

What am I doing wrong?

Categories:

I have the same question (0)

All responses (1)

Answers (1)

Join the conversation

Helpful resources