You’re offline. This is a read only version of the page.
372
Hi,
I used this formula to get value from different SP List,
First(Filter(
Filter(PPIC, !IsBlank('Production Order')),
'Production Order' = First(Filter('List Job Cikupa', Order = ProdOrder.Selected.Value)).'Production Order Induk'
)).'ID Product'
If I remove IsBlank, then I got error, but If I keep using that formula, I got delegation.
Can anyone suggest me another way? Thankyou!
@firda59 There is reason that the above code is suggested by @WarrenBelz .
@firda59 Hope you are aware about with function? We can connect on call may be through Teams call or zoom call, but that too next week, however if you require urgent assistance then in that case I would suggest to create a ticket with Microsoft for further support.
Thanks,
ANB
if IsBlank in the last position, it cant work, so I move that formula in the middle position hehehehe
@firda59 ,
That is not what I posted in my last code response
Share
Report
All responses (
Answers (
With(
{
_Order:
Lookup(
'List Job Cikupa',
Order = ProdOrder.Selected.Value
).'Production Order Induk'
},
With(
{
_Data:
Filter(
PPIC,
'Production Order' = _Order
)
},
LookUp(
_Data,
!IsBlank('Production Order')
).'ID Product'
)
)
Hi @firda59 , @WarrenBelz is correct! Please use the code which is suggested by him. It is going to give you the same output.
Thanks,
ANB
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
