Unanswered

Link one special sheet in excel saved sharepoint by using Powerapps

(0) Share

Report

Posted on by Community Power Pla...

I am new to powerapps. I build an app and use flow to sent the input to an existing excel file but it's directly to the sheet I choose in excel. I have saved this file excel in Sharepoint.

Can anyone help me? Thank you so much

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Could you please share more details about your requirement? I cannot find any question from your description. What problem do you need our help solving?

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have one file excel including many sheets. I need to create a button only go to the sheet I wanted of this excel.

If I use Lanuch(), it's allow me to any sheet in excel.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

See in below thread:

How do you open a specific excel sheet from sharepoint URL - SharePoint Stack Exchange

If you use the Copy Link function on the workbook (so that you get a link that looks something like this:)

https://yourtenant.sharepoint.com/:x:/s/sitename/EaPm6BD3KkVJvwjuzQdOrcEBR0YOqbFUWn10YGyL26cMKQ?e=8y1CEl

You can append &ActiveCell=Sheet1 at the end and it will open that sheet, in the browser.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

I have try your method, but it's also not working. Do you have any way other?

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

You cannot only say "not working". What result have you got? I use a Launch function on a Button in my test App and it opened exact the sheet of the Excel file I set in the URL:

BR,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Oh sorry, I have miss "ActiveCell", but when I use app in laptop it's ok, in mobile it's not working and say error.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

Try and add "&action=default&mobileredirect=true" to the URL and check if the link would work.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It's still not working ! Do you have any way?

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report

Hi @Anonymous ,

I believe it's due to iOS Safari/Chrome limitation. I tested with Edge on my iPhone, and it worked (sometimes it crashes, but refreshing the page can solve it).

Best regards,

Was this reply helpful? Yes No