cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NumericDreamz
Level: Powered On

PATCH not updating Spread Sheet in OneDrive

There are posts similar to this but I haven't seen one that deals with a file in OneDrive. 

 

I created a button control that patches collection data to a spreadsheet in OneDrive.  The code was directly copied from another app that I made which works flawlessly.  Table names were the only thing changed to reflect the appropriate values for this xlsx.  However, when you run the app and hit the submit button it just constantly tries to update the tables.  It never gives an error.  Just little dots racing across the top of the app, never ending.  Looking at the target file, no changes are ever made.

 

Any ideas?

ForAll(cltnRowChkRep, Patch(RowChk, First(Filter(RowChk, Location = Location)),{
Batch_lot: Batch_lot,
FIFO: FIFO,
Item: Item,
Location: Location,
On_hand: On_hand,
Status: Status
}))
;
RemoveIf(Disc, true);
ForAll(cltnDiscrep, Patch(Disc, Defaults(Disc),{
Batch_lot: Batch_lot,
Item: Item,
Location: Location,
On_hand: On_hand,
Status: Status
}))

EDIT:  If you let the app spin long enough you get the following error message on the control.

An error occurred on the server.

Server Response: Exception received from the underlying connector. Exception Message: An error occurred while sending the request.

clientRequestId: 4b1711dd-e9bd-bc78-e040-d4b0aefa4698 

2 REPLIES 2
Community Support Team
Community Support Team

Re: PATCH not updating Spread Sheet in OneDrive

Hi @NumericDreamz,

 

According to https://docs.microsoft.com/en-us/powerapps/functions/function-forall, Forall function's syntax should be like:

ForAllTableFormula )

 

Would you explain more about the data you used in this formula? I assume that cltnRowChkRep is the excel table name, but what are these "RowChk" and "Disc"?

 

Cannot reproduce your issue if we are not clear about what is what in your formula.

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NumericDreamz
Level: Powered On

Re: PATCH not updating Spread Sheet in OneDrive

Hey v-monli, thanks for the reply.  No, cltnRowChkRep is the collection in PowerApps.  RowChk and Disc are two Excel tables.  RowChk has data that the app imports into cltnRowChkRep when the app starts, the user updates it, and then the changes are patched to the origional RowChk table.  Disc (Discrepancies) starts out initially blank and any records the user adds to cltnDiscrep are patched to it the Disc table.

 

This is just a little inventory tool to aid the guys in the warehouse.  So the syntax goes like this...  FOR ALL the entries in (the local COLLECTION, PATCH them to THIS Excel spread sheet).

 

Should be pretty simple but it never updates the origional RowChk table and on very few occasions it will actually post entries to Disc but it won't clear the table first like it should.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 90 members 3,973 guests
Please welcome our newest community members: