filter and Patch error???

(0) Share

Report

Posted on by bbsin

1,994

Can anyone help on this? There's error...

I want search by PO number and patch the GR no on the record selected in the gallery Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
hi @bbsin,
Could you share the error message what you see on the patch if it data mismatch convert the value as below:
you don't need the forall and change the Patch as below:

Patch(list/TableName,ThisItem,{GRNo:GRnoUpdateInout.Text})

Write this onSelect property of the edit icon on the gallery

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@bbsin

In the context of your formula, your GRnoUpdateInput is prepended with ThisRecord. ThisRecord in your formula refers the the Patch record.

Please consider changing your Formula to the following:

Patch(yourList, ForAll( Filter(UpGRNoGal_1.AllItems, IsBlank(GRnoUpdateInput.Text)) As _item, {ID: _item.ID, POno: _item.GRnoUpdateInput.Text } ) )

Note: ForAll is a table function - it produces a table. It's not a developer For/Loop, so in the above, the table is created and then sent to the Patch function to perform the Patch from the table records.

I hope this is helpful for you.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

hi @RandyHayes,

Do I copy and paste the sytnax in ? What is _item...

I follow and copy mine from a tutorial in YouTube 🙂

Regards

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

Hi @KrivshnaV,

Noted with thanks

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

Hi @bbsin ,

If the issue is not resolved let me know happy to help you anytime

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Hi Randy,

I copy your syntax, it not running. the patch is a number field in SP list.. do I have to add anything?

Thanks

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
Hi @bbsin ,

Try this:

Patch(yourList, ForAll( Filter(UpGRNoGal_1.AllItems, IsBlank(GRnoUpdateInput.Text)) As _item, {ID: _item.ID, POno: Value(_item.GRnoUpdateInput.Text) } ) )

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

hI @KrishnaV

I input this

Patch('list',
ForAll(
Filter(GalGRno.AllItems, IsBlank(GRnoUpdateInput.Text)) As _item,
{ID: _item.ID,
POno: Value(_item.GRnoUpdateInput.Text)
}
)
)

it's not running? no error message.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
My bad try this to update only one record:

Patch(list/TableName,ThisItem,{POno:Value(GRnoUpdateInout.Text)})

I hope you are applying this formula onSelect property of the gallery.

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

hi

is it
Patch('lst', Gallery, ThisItem,{POno:Value(GRnoUpdateInout.Text)})

if it is .. there's errror..

Was this reply helpful? Yes No