Unanswered

Trying to create a dynamic connection in power apps for Excel online connecter.

Like (0) Share

Report

Posted on 29 May 2023 10:21:43 by ABHIJ

We are replacing the excel file daily using power automate. The excel file is connected to Power app via the excel online connecter But after replacing the file It is gives an error in power apps for refresh of the data/ Though the Table Name & File name is same. How can i solve this issue, Is there a way to connect to excel daily dynamically.

MicrosoftTeams-im...

All responses (5)

Answers (0)

MayAnn 2 on 12 Jun 2023 at 08:39:07

Like (0)

Report

Re: Trying to create a dynamic connection in power apps for Excel online connecter.

Same with my powerapps. I need to reconnect the excel file manually because the data set name was changed after replacing the file.
ABHIJ 8 on 30 May 2023 at 07:29:37

Like (0)

Report

Re: Trying to create a dynamic connection in power apps for Excel online connecter.

Any workaround to replace large data ? apart from this
BadriPradhan 30 on 30 May 2023 at 07:22:02

Like (0)

Report

Re: Trying to create a dynamic connection in power apps for Excel online connecter.

The error occurs because the File GUID has changed, even though the file and table display names remain the same.

Before replace file name and table name
----------------------------------------

"file": "01ISE3MSWJKHBCB47T3BEJCN5GF5IGZ66B",
"table": "{96A1F152-0EE0-435C-9D61-CE33508B46D2}"

After replace file name and table name
--------------------------------------

"file": "01ISE3MSWCGKQX6L5JRND3W6RKRHGGHHRH",
"table": "{96A1F152-0EE0-435C-9D61-CE33508B46D2}"

Error Details
No table was found with the name '{96A1F152-0EE0-435C-9D61-CE33508B46D2}'.
clientRequestId: cfcbd2e6-5f24-4c70-8af3-7bf7576dc23a
serviceRequestId: 306f69f1-0566-4d84-ba20-4a344732342e
ABHIJ 8 on 30 May 2023 at 03:33:21

Like (0)

Report

Re: Trying to create a dynamic connection in power apps for Excel online connecter.

Table name & file name is also same. & i am using Power automate only to replace the data. Modifying data on more than 50 thousand rows is tedious task in PA. That is why i was replacing the file using PA.
BadriPradhan 30 on 29 May 2023 at 18:46:12

Like (0)

Report

Re: Trying to create a dynamic connection in power apps for Excel online connecter.

Regarding the issue at hand, there is no need to create a dynamic connection as the existing connection is functioning correctly. The error message indicates that the Excel table name has changed. In Excel, each table has a unique GUID name, and when you replace the file, the display name of the table remains the same while the underlying GUID name changes.

To address this error and update the data in Excel without replacing the Excel file, you can leverage Power Automate. Power Automate provides functionality to automate workflows and integrates well with Excel. By utilizing Power Automate, you can modify the data within the Excel table while keeping the existing table name intact. This eliminates the need to change the table name every time you update the data.