Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Community Champion
1 year ago
Solved

Power Query treating embedded URLs from Excel file strangely...

Hi!  And welcome to my issue...would appreciate any help you might be able to provide.  ðŸ™‚  This is very strange and I've been unable to figure this out.   Importing data from an Excel file, and th...
Need Help
  • shafiz_p's avatar
    shafiz_p
    1 year ago

    Hi littlemojopuppy  Try use table.transformColumns :

    ReplacedNonLinks = Table.TransformColumns(#"Changed Type", {{"Helpful Report Links", each if Text.StartsWith(_, "https://") then _ else null, type nullable text}})


Where #"Changed Type" is the previous steps.

     

    Output:

     

     

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution and a kudos!!

     

     

    Best Regards,
    Shahariar Hafiz

lbendlin's avatar
lbendlin
Super User
1 year ago

please provide a sample Excel file and indicate the expected outcome.