Skip to main content

Notifications

Power Platform Community / Forums / Building Flows / Creating a hyperlink t...
Building Flows
Suggested answer

Creating a hyperlink to an Excel cell populated by MS Form data

Posted on by
Hi all,

I'm trying to link an Excel row/cell in an Email that directs the user to the newest MS Form submission that corresponds with the Excel data. 

For example:

MS Form is submitted, submission details are entered into Excel, and finally I want to have an email that links the user to those new submission details on the workbook. 

If anyone could help or has any suggestions on a workaround, that would be great!

Best,
AP
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,047 on at
    Creating a hyperlink to an Excel cell populated by MS Form data
    Hi,
     
    As alex mentioned, it is possible to provide url to a excel row directly using excel online. So other options which can be looked at is -
     
    1. Provide the URL to the workbook file in email
    2. Also specify the row position so that user can lookup there.
     
     
    Hope it helps !
     
    Thanks & Regards,
    Nived N 
    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs
     Found my answer helpful? Please consider marking it as the solution!
     Your appreciation keeps me motivated. Thank you!

     
  • AlexEncodian Profile Picture
    AlexEncodian 4,117 on at
    Creating a hyperlink to an Excel cell populated by MS Form data
    I'm not sure you can link to specific rows in an Excel. However, you could link to the workbook and provide the response ID in the email so the user knows which submission to look at

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 141,122

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,414

Leaderboard

Featured topics