pjandshelly
Board Regular
- Joined
- Jan 25, 2017
- Messages
- 61
I have a SharePoint List that I am wanting users to be able to use as a dashboard. I am trying two different avenues.
1. Export list to Excel based off filtered conditions, but limited due to only being able to filter each field how I would like it.
2. Using Power Query, I can filter how I would like to. However, on the SP Export, my form title hasa hyperlink to the form. I can click onthe hyperlink of the form, update the form, and then my spreadsheet will update. With Power Query, I can add that same fieldto my report and the hyperlink doesn’t work.
I would prefer to use Power Query due to the toolsavailable. Is there a way to make thathyperlink available still to the form?
1. Export list to Excel based off filtered conditions, but limited due to only being able to filter each field how I would like it.
2. Using Power Query, I can filter how I would like to. However, on the SP Export, my form title hasa hyperlink to the form. I can click onthe hyperlink of the form, update the form, and then my spreadsheet will update. With Power Query, I can add that same fieldto my report and the hyperlink doesn’t work.
I would prefer to use Power Query due to the toolsavailable. Is there a way to make thathyperlink available still to the form?