Guru-G

Often times, when you get data from a source, there will most probably be something incorrect that needs to be fixed using an ETL process of Power Query. And most of those transformations would require either Replacing or Removing string's that are not necessary. For example, if you extract any financial data from a source which has multiple currency symbols, there's a chance that the numbers get extracted along with the currency symbols like "$700"/"€700" instead of 700. And these type of cases makes it tough to Transform the Data to our wish as the value will be considered as a text instead of a number. In those type of cases, we would most likely have to create multiple steps to remove the multiple currency symbols from the Column. But thanks to the solution provided by Marcel for one of the questions posted on Stack Overflow, with a little manipulation of the Query language (M), we can replace/Remove multiple strings in one step using the List.

You might have seen moving spotlights in a lot of videos. How cool would it be if you can do that in Powerpoint for one of your presentations in School/Office? The above GIF is a fast-forwarded recording of PowerPoint slides. You can replicate this effect using a combination of Crop and the Transitions feature of the powerpoint. Below is a video which explains that process to achieve the above result.

    With the addition of Windows Ink Workspace in Windows 10, we can now take screenshots and draw over the screenshot easily. You can simply click on the Windows Ink Workspace button in the taskbar or press Win+W shortcut to open the Windows Ink Workspace and click on "Screen Sketch" to take a screenshot and start editing it.    But if you would like to have a shortcut to open screen sketch directly without having to open the Ink workspace, you can create one manually using the following simple steps as suggested in the following link : Go to your PC Desktop Right Click and select New > Shortcut In the Next window that appears, copy and paste the following text and click Next ms-penworkspace://Capture Choose a name for the shortcut in the next window and click finish Now, right-click on the shortcut that is created on the desktop and select Properties. Go to Web document tab in the properties window and choose your desired shortcut in the "shortcut key&qu

    Windows Ink Workspace is a new feature added in Windows 10, which allows us to take screenshots, sketch on whitespace and draw or take notes in sticky notes. We can have the Windows Ink Workspace button handy in the taskbar notification area. If you don't see the button on your taskbar, you can right click on the Taskbar and check the option that says "Show Windows Ink Workspace button". To open the Windows Ink workspace, you can click on this button or use the shortcut Win+W. The tools available in the Ink Workspace are Sticky Notes, Sketchpad & Screen Sketch. Sticky Notes :     Sticky notes have been available in Windows for very long. The Sticky Notes in the Ink Workspace are the same. You can also open sticky notes simply by searching for it in the windows search. Sketchpad :     Sketchpad is simply a whiteboard feature which allows you to sketch anything you want and save it in your PC/Tablet. It has various tools like Pen, Pencil, highlighter

     While you are in a presentation or hosting a webinar, you might want to write/highlight a part of your screen to draw the attention of your audience on something important. Although you can use the tools from powerpoint to scribble in the PPT file, you might want to write something on other apps as well.      That's where these awesome apps come into play. Although these apps have similar features, you might prefer one above the other. ZoomIt :       ZoomIt is an application developed by Microsoft which can be installed from the following link . It is a free tool with features like Text, Shapes, whiteboard, blackboard, zoom . When activated, the tool converts the current screen into a static image and allows you to draw/write on it. One the tool is activated, you can also choose to create a whiteboard/blackboard screen on your PC to draw on. Although the colors are limited to 6 colors: Red (R) , Green (G) , Blue (B) , Orange (O) , Yellow (Y) , Pink (P) , it should be

    If you have a small set of files in a SharePoint Library, which has too many folders, using MS Flow to copy all files from one specific folder is easy. But if you want to pick a small set of files from multiple folders and copy them all using one Flow, it might be tricky. If you open any document from SharePoint in a web-browser, you'll notice a text like " Listitemid = #### " where #### is a number. That is a unique ID of that file in that SharePoint. You can use this to get the details of that file. Example: https://testsite.sharepoint.com/:x:/r/sites/test123/_layouts/15/Doc.aspx?sourcedoc=%7Bb8exxx66-2f8a-486a-9426-6cd93abcd22097b%7D&action=default&uid=%7BB8EFG30666-2F8A-486A-9426-6CD93A22097B%7D& ListItemId=671204 &ListId=%7B7BDD3AD3-36BCDE-4E43-BB21-9B68136E8091%7D&odsp=1&env=prod You can store a set of those values as an array variable in the Initialize Variable step (blue box in below screenshot) in MS Flow and use those to Ge

To get a QR Code for a File/Folder/Page in a SharePoint, follow the following steps. Click on any file/folder/page and click Manage Access  (Image 1) . Click on " Advanced " on the next pane to open the Advanced settings. In the next window, click on Grant Permission in the Permissions ribbon to open the share settings window  (Image 2) . In the Share Settings Window, click on " Get Link " and select the desired access level from the drop-down  ( Image 2) . Click on the small mobile icon (Open this link on Phone) beside the Remove button  (Image 3) . A new window pops up with a QR Code for the specified File  (Image 4) . Image 1 Image 2 Image 3 Image 4