Answered

Excel table update with patch function

(0) Share

Report

Posted on by pal95

264

Hi,
I would like to update my table by Patch function, so if someone clicks on the item, it should be an update with a click date transferred to Excel.

I have the following issue (you can see it on a screen). It is written: The data source is either Read-Only or has no primary key.

Any ideas on how to solve it? Thank you for your time!

Categories:

Building Power Apps

pr1.png

PR2.png

I have the same question (0)

All responses (8)

Answers (1)

eka24 20,923 on at

Like (0)

Report

Your criteria at "Bridlington" is a Column Name not a Text inside the column. So use:
Patch( Table1, First( Filter(Table1, Bridlington = "Clean Low Level Probe" ) ), { ‘Last Check’: Now() } )

Or
Patch( Table1, First( Filter(Table1, ID = 1 ) ), { 'Last Check': Now() } )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
pal95 264 on at

Like (0)

Report

It does not make any change, still the same error appears

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

If you have calculated Columns or the SubTotal as you have shown in your table, remove them.
Also does your excel table have a PowerApps_id column?
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
pal95 264 on at

Like (0)

Report

No one of them helps. I literally copied an example from https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch#examples now and it still shows me the same primary key or read-only error on an IceCream table.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report
Hi @pal95 :
Could you tell me:
Did you close this excel file before updating the data?(Known Issues and Limitations)
What is the connection?Excel or OneDrive?(Excel table read-only data cannot be saved)
Do you consider using other data sources?
Using excel as a data source has the following restrictions:
1\An Excel file may be locked in OneDrive for an update or delete up to 12 minutes(OneDrive) since the last use of the connector.
2\You should not have the Excel workbook open in OneDrive when you are trying to update it, or you will receive the error “The requested resource is locked.
3\You can only edit the formatted table that in the Excel file. Format the Excel data as a table
4\If your Excel data includes a calculated column, you can't use it to build an app, and you can’t add that data to an existing app.
5\The maximum size of an Excel file that is supported by the Excel Online (OneDrive) connector is 5 MB.
Best Regards,
Bof

Was this reply helpful? Yes No
pal95 264 on at

Like (0)

Report

Thank you, The solution was just to use OneDrive instead of Excel

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @pal95 :
Has your problem been solved?Do you still have any questions?
If the problem has been solved, I suggest you mark your solution as a solution, so that more people can see it.
Best Regards,
Bof

Was this reply helpful? Yes No
ndujilo 2 on at

Like (0)

Report

hello, can you please explain?
i am actually stuck with this

Was this reply helpful? Yes No