Connect excel file to power apps dynamically (e. g. via ID)

(0) Share

Report

Posted on by Nuriel

177

Dear all,

I am using a sharepoint list as data source for a power apps canvas app which serves as an edit form. Each new item creates additionally (via power automate) a folder with an excel file based on a template in a sharepoint library.

Thus I have URL, ID or whatever reference I need between the list item, folder and excel file available to use in power apps or power automate.

Now, I would like to connect that excel file via excel online business connector to my canvas app.

While I am able to connect AN excel file (e. g. by applying a fixed URL / selecting it) to my canvas app as datasource, I can't figure out how to connect an excel file dynamically based on the item in quest, e. g. by specifying the URL like this: https://url.com/folder/variable.xlsx

Is it possible at all to do this?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Pstork1 69,121 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The problem is that the schema of the table in the list is stored when you make the first connection in a flow or app. If you change that connection by dynamically specifying the excel file and table it can't change the schema on the fly. It is possible to do it in Power Automate. But it requires that you update or create the row in the table by providing a full JSON item definition. I don't think that's going to even be possible in Power Apps.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

1 people found this reply helpful.

Was this reply helpful? Yes No
Nuriel 177 on at

Like (0)

Report
Copy link

Link copied!

Thank you, this is unfortunate - I will then try to figure out, how to do what I intend to do via power automate.

Was this reply helpful? Yes No