Feedback by UserVoice

Walter Pelowski

My feedback

  1. 448 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Walter Pelowski supported this idea  · 
    • 381 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        Walter Pelowski commented  · 

        Having regex capabilities would dramatically simplify a lot of the daisy-chaining of M functions or Excel functions I have to string together as well as providing capabilities that I can't even achieve (or don't know how to achieve) with current methods.

        I hope that if/when you implement regexs that you consider a flavor that supports positive and negative lookbehinds and lookaheads.

        Walter Pelowski supported this idea  · 
      • 366 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          Walter Pelowski supported this idea  · 
          Walter Pelowski commented  · 

          I've had an issue the past couple of months where occasionally I'm unable to use the Modern Copy interface in SharePoint online (link here: https://techcommunity.microsoft.com/t5/Microsoft-SharePoint-Blog/Announcing-File-Copy-Move-for-SharePoint-Modern-Document/ba-p/4884) to copy some spreadsheets over to another library. I get a really lousy and unhelpful error of "1 item wasn't copied". https://www.screencast.com/t/PEc6XaXJaC In finding a Excel 2017 and Excel 2010 article about this limitation I figured, "What the heck? Why not try it?" and lo and behold, by reducing the directory name in SharePoint Online by a few characters, it fixed the issue! I too am shocked that in today's day and age that this is still a limitation. (Literally the file is only 2 folders deep.) It is even trickier to troubleshoot when there is nothing in SharePoint Online to indicate that this was the limitation that was experienced.

        • 6 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            Walter Pelowski commented  · 

            I REALLY wish we had this. It would allow me to create reports that are much more valuable and useful to our company. Ultimately, I wish that Hyperlinks would become first-class citizens in the Excel PowerPivot data model as well by allowing calculated columns to use the Hyperlink function.

            This is one of those areas where I feel Excel is almost there. Since I believe usage cases are more motivating, I'm including an example of a report I've recently written that can be viewed via the hyperlink below. (I've trimmed it a bit and anonymized the information.) The report shows card records from Trello grouped by the email address of the person for whom we're doing some work. I'm able to do almost everything I want in Excel including using Power Query to dynamically pull the data from Trello via the API, group it together by both Card and Checklist, and give a report for those checklist items that are still due. It's so close to being valuable to people over our current process, however, being able to quickly give the person a hyperlink to click to complete the task is both more readable and actionable than trusting them to copy and paste a URL from the report.

            https://www.screencast.com/t/6EAQLv5eR6

            Walter Pelowski supported this idea  · 
          • 393 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              Hi Ken,

              Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

              thanks
              ash [MS XL]

              Walter Pelowski supported this idea  · 

            Feedback and Knowledge Base