Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Patch Function

(0) ShareShare
ReportReport
Posted on by 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!

  • firda59 Profile Picture
    firda59 372 on at
    Re: Patch Function

    @v-mingkz-msft 

     

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

  • firda59 Profile Picture
    firda59 372 on at
    Re: Patch Function

    Hi @v-mingkz-msft 

     

    What RenameColumns means? Because my formula error

  • Verified answer
    Re: Patch Function

    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

  • firda59 Profile Picture
    firda59 372 on at
    Re: Patch Function

    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?

  • BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: Patch Function

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard