Hi@AmitY,
Based on the issue that you mentioned, do you want to write data to your Excel table which stored within your SP library?
If you want to update the Excel table which stored within your SP library in PowerApps, I am afraid that there is no way to achieve your needs in PowerApps currently.
For now, we could only get the File name, created time, modified time, creator, etc properties (metadata of the file) of a file stored within a SP library, we could not retrieve file content of a file stored in a SP library.
Patching data into Excel table which stored within SP library is not supported within PowerApps. If you would like this feature to be added in PowerApps, here is an idea you can vote for:
Create App from Excel file stored on SharePoint - Power Platform Community (microsoft.com)
For now, we could only get data from the Excel table firing a flow from PowerApps, then return the retrieved Excel table records back to your canvas app.
I have made a test on my side, please take a try with the following workaround.
Here is how I configure my flow:
Within the "Response Body JSON Schema" field of the "Response" action, type the following JSON schema value:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"PurchaseOrder": {
"type": "string"
},
"Country": {
"type": "string"
},
"State": {
"type": "string"
},
"City": {
"type": "string"
},
"__PowerAppsId__": {
"type": "string"
}
},
"required": [
"@@odata.etag",
"ItemInternalId",
"PurchaseOrder",
"Country",
"State",
"City",
"__PowerAppsId__"
]
}
}
On your side, please write the formula as follows:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"@@odata.etag": {
"type": "string"
},
"ItemInternalId": {
"type": "string"
},
"Column1": {
"type": "string"
},
"Column2": {
"type": "string"
},
"Column3": {
"type": "string"
},
"Column4": {
"type": "string"
},
...
...,
"__PowerAppsId__": {
"type": "string"
}
},
"required": [
"@@odata.etag",
"ItemInternalId",
"Column1",
"Column2",
"Column3",
"Column4",
...
...
"__PowerAppsId__"
]
}
}
Note: Replace "Column1","Column2",... with your real column name in the Excel file.
Then add this flow into your app as follows:
Insert a Button and set the OnSelect property as below:
ClearCollect(ExcelTableRecords,demo1.Run())
Insert a DataTable and connect to the collection, add the corresponding fields.
Hope it could help you.
Best Regards,
Qi
