Unanswered

Update data in excel file on OneDrive

(0) Share

Report

Posted on by ErickReris1

Hi everyone, everything fine?

I am creating an application where when clicking on an Approve button, it inserts into Excel the information that that line was approved in a Column called Status.

But when writing the function, it tells me that the Patch function has invalid arguments.

Can you help me?

The function I'm using is the following:

Patch(SchedulingTable;
LookUp(TableSchedules; PowerAppsIdSchedule = Gallery3_1.Selected.PowerAppsIdSchedule);
{
'Receipt comments': ReceiptTxt.Text
}
)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @ErickReris1 ,

You need to look up the same table you are patching to if you want to identify the correct target record

Patch( SchedulingTable; LookUp( SchedulingTable; PowerAppsIdSchedule = Gallery3_1.Selected.PowerAppsIdSchedule ); { 'Receipt comments': ReceiptTxt.Text } )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
ErickReris1 8 on at

Like (0)

Report
Hi WarrenBelz,
But in this case, isn't that what I'm doing in the formula?
In both Patch and LookUp I am referencing the same table.

I still got the message that the patch function has invalid arguments
Patch( SchedulingTable; LookUp( SchedulingTable; PowerAppsIdSchedule = Gallery3_1.Selected.PowerAppsIdSchedule ); { 'Receipt comments': ReceiptTxt.Text } )

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@ErickReris1 ,

You might have another look at the code you posted

Patch(

SchedulingTable;
LookUp(

TableSchedules;

PowerAppsIdSchedule = Gallery3_1.Selected.PowerAppsIdSchedule

);
{
' Receipt comments': ReceiptTxt.Text
}
)

Was this reply helpful? Yes No
ErickReris1 8 on at

Like (0)

Report

Sorry, I think that when I asked the question I ended up confusing the names in the table.
But the code is right at this point, see the print below:

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
@ErickReris1 ,

I cannot see your data, but does PowerAppsIdSchedule exist in the Gallery - if you put a Label with

ThisItem.PowerAppsIdSchedule

in the gallery, do you see the field value?

Was this reply helpful? Yes No
ErickReris1 8 on at

Like (0)

Report

I did the test you mentioned and it does appear. Both on the gallery screen and on the page where I have the buttons.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@ErickReris1 ,

You are still getting an error on the Table name in your screenshot (so check that). Your structure is correct providing all your references are - I cannot see your data, however Excel is a terrible data source and I would not be surprised if the issue is the size of the string you are trying to match.

Was this reply helpful? Yes No