Answered

SharePoint not updating status

(0) Share

Report

Posted on by Chrisguff12

229

I have a gallery that displays expense items that are Pending. I have a checkbox in the form to check off what items are Approved. then a button that will update the ItemStatus field. The formula I have has a delegation error under the = sign and ".text" but the rest looks fine. When I hit the button it doesn't update the field.

"ItemStatus is a "Single line of text" type in a SP list 'Expense App List New'

Button Formula

ForAll(
 Filter(
 Pending_Expenses_Approval_Gallery_1.AllItems,
 Approve_Item_Checkbox.Value = true),
 Patch(
 'Expense App List New',
 LookUp(
 'Expense App List New',
 RequestID = ID_Label4.Text
 ),
 {ItemStatus: "Aprroved"}
 )
);
Refresh('Expense App List New')

Categories:

General Questions

I have the same question (0)

All responses (8)

Answers (1)

WarrenBelz 151,751 Most Valuable Professional on at

Like (1)

Report
Re: SharePoint not updating status

Hi @Chrisguff12 ,

I am not sure where the Delegation Warning is coming from - I assume RequestID is a Single Line of Text?

Try this as well

ForAll( Filter( Pending_Expenses_Approval_Gallery_1.AllItems, Approve_Item_Checkbox.Value ), Patch( 'Expense App List New', {RequestID:ID_Label4.Text}, {ItemStatus: "Approved"} ) ); Refresh('Expense App List New')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: SharePoint not updating status

@WarrenBelz

The ReportID is a number field. I am getting a expected a number type. I removed the .Text to fix the formula, but when I click the button it creates a new Approved record with all other fields are blank.

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (0)

Report
Re: SharePoint not updating status

Thanks @Chrisguff12 ,

You need

ForAll( Filter( Pending_Expenses_Approval_Gallery_1.AllItems, Approve_Item_Checkbox.Value ), Patch( 'Expense App List New', {RequestID:Value(ID_Label4.Text)}, {ItemStatus: "Approved"} ) ); Refresh('Expense App List New')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: SharePoint not updating status

@WarrenBelz
Hello, Warren I still only makes a new record.

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (0)

Report
Re: SharePoint not updating status

@Chrisguff12 ,

What is the actual field value behind ID_Label4? If it is the RequestID, you can do this

ForAll( Filter( Pending_Expenses_Approval_Gallery_1.AllItems, Approve_Item_Checkbox.Value ) As aExpense, Patch( 'Expense App List New', {RequestID:aExpense.RequestID}, {ItemStatus: "Approved"} ) ); Refresh('Expense App List New')

The syntax is correct to update a record as long as you have a match on the first part.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

Chrisguff12 229 on at

Like (0)

Report
Re: SharePoint not updating status

@WarrenBelz
I read your Blog “Power Apps Delegation – SharePoint” last week and I tied to follow your advice on shadow IDs. I made a simple Number field in SP and named it RequestID. Then for the “OnSuccess” property of the form when submitting a new request, I have a version of your formula.
UpdateContext({locShowSpinnerINFIN: false}); Patch( 'Expense App List New', {ID: New_Supply_Requests_Form.LastSubmit.ID}, {RequestID: New_Supply_Requests_Form.LastSubmit.ID} ); ResetForm(New_Supply_Requests_Form)
So “ID_Label4” is just has ThisItem.RequestID in the Text property.

As I am looking at your Blog again now, I think that I am missing the rest of the pieces to make the Patch function work. I’m not sure where to put the “Set(VLASTID….” piece.

Was this reply helpful? Yes No
WarrenBelz 151,751 Most Valuable Professional on at

Like (0)

Report

Re: SharePoint not updating status

Hi @Chrisguff12 ,

Assuming you have this unique numeric identifier in every record and it is also in the data forming the gallery, then the last code I supplied should work.

I don’t quite understand you last question as it does not relate to this thread.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Chrisguff12 229 on at

Like (0)

Report

Re: SharePoint not updating status

@WarrenBelz

I want to thank you for your patience but I’m still not able to get this to work and I’m sure it’s on my end and not with the formula that you provided. I am going to go another way with my status changes and use forms to update the records.

Was this reply helpful? Yes No