Alternative to "IN" function

(0) Share

Report

Posted on by Arturs

Hello,

How can I replace "IN" function to avoid delegable warning in this function:

Patch(SharePointList,
First(Filter(SharePointList, FTitle.Text in Title)),
{
Title: FTitle.Text,
Email: FEmail.Text,
Details: FDetails.Text,
IsSelected:FSelect.Value});

Collections this time is not an option, Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

Hi @Arturs

Use LookUp Function:

Patch(SharePointList,
LookUp(SharePointList, Title = FTitle.Text ),
{Title: FTitle.Text,
Email: FEmail.Text,
Details: FDetails.Text,
IsSelected:FSelect.Value});

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

https://www.youtube.com/channel/UCjkyqaAf_ww8T98V99lkfow/

Was this reply helpful? Yes No
Arturs 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you! It works!

Was this reply helpful? Yes No