Modifying excel datasource

(0) Share

Report

Posted on by _arc

Hi,

I have a requirement to modify excel data source.

I have a dropdown to which I have binded a datasource by importing excel file.

When I click on 'Add Item' button is it possible to add another item to the excel datasource and refresh the dropdown.

Attachment 1.jpg

Regards,

_arc

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@_arc
Yes, it is possible. Create a new Text Input then write the word Pineapple inside it.

Next, put this code in the OnSelect property of the "Add Item" button.

Patch(excel_table_name, Defaults(), {Source: TextInput1.Text}); Refresh(excel_table_name);

Now, pineapple will appear as an option.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
_arc 34 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I tried the solution but it is not working.
I added an Id column and data is in table format also.
ItemsTable datasource has been imported from 'Import from Excel' option.

Name of excel table is

I am getting the below error I am not able to add new items.

"The datasource is readonly or does not have a primary key, so function Patch can't write to it."

I tried both the formulas below

Patch(ItemsTable, Defaults(), {Source: txtItems.Text}); //Defaults() cannot be empty expects a parameter
Patch(ItemsTable, Defaults(ItemsTable), {Source: txtItems.Text});

Regards,
_arc

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @_arc ,

Please notice that the Excel Table connected by 'Imported from Excel' connector is read-only by design. The data added to the app is static and can't be modified.

Please change to upload the Excel spreadsheet to OneDrive for business or other could storages, and connect the excel table by that could storage connector.

Hope this helps.

Sik

Was this reply helpful? Yes No