Patch Function

(0) Share

Report

Posted on by firda59

372

Hi,

I want to patch column 'Masuk Apps' which has the same 'No. PO'.

I used this formula,

Patch(
'Recap SOW',
LookUp(
Filter(
'Recap SOW',
'No. PO' = ThisItem.'SO/PO/WBS'
),
'No. PO' = ThisItem.'SO/PO/WBS'
),
{'Masuk Apps': "Proses sudah dilewati"}
)

but, cant work. Can anyone help me? Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

BCBuizer 22,565 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @firda59 ,

If I understand correctly you want to update all items in your data source that match a certain value in the 'No. PO' column, correct?

If correct, consider using the UpdateIf function:

UpdateIf( Filter( 'Recap SOW', 'No. PO' = ThisItem.'SO/PO/WBS' ), {'Masuk Apps': "Proses sudah dilewati"} )

Depending on your data source, this may not be delegable, which will cause issues if you go over 2000 items in your data source. In that case a ForAll loop should be combined with Patch.

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @BCBuizer

Yup, I want to update all items in my data source which has the same 'No. PO' .If my data source over 2000 items, how to make the formula?

Was this reply helpful? Yes No
Verified answer

v-mingkz-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @firda59,
You can try the following expression.

UpdateIf('Recap SOW','No. PO' = ThisItem.'SO/PO/WBS',{'Masuk Apps': "Proses sudah dilewati"})

Best Regards,
Kyrie

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mingkz-msft

What RenameColumns means? Because my formula error

Was this reply helpful? Yes No
firda59 372 on at

Like (0)

Report
Copy link

Link copied!

@v-mingkz-msft

thankyouuuu!!!!!! it can work now!

Was this reply helpful? Yes No