There is Proper functions in Power Apps to converts any first letter of a word to Uppercase. But there is no Proper case function in Power Automate yet. Reference to a blog post written by Paul Murana to achieve the same result. Below is the Input. and here is the Output. Follow the steps below: […]
Continue reading
Working on Power Automate aka Flow to retrieve result from Execute a SQL query (V2). Wondering where is Dynamic Content for Execute a SQL query (V2) ? Execute a SQL query (V2) response: Add Compose action underneath and go to expressions and paste this in. body(‘Execute_a_SQL_query_(V2)’)?[‘resultsets’][‘Table1’][0][‘Approved’] It just work like a charm ! This […]
Continue reading
For IRM protected document library, you will see this error while uploading protected or digitally signed PDF files. Something that working fine for Sharepoint 2010 but NOT for SharePoint Online. According to Microsoft article: IRM protection cannot be applied to protected documents as SharePoint needs to open the documents on upload This is most demanded […]
Continue reading
Excited to know that there are way to restrict downloading on SharePoint Online Document Library. But where is the Read Only permission ? Follow the steps below to Activate it. Navigate to Site Settings > Site Collection Administration > Site Collection Features. Look for SharePoint Server Enterprise Site Collection features Click Activate. Here you go. View Only […]
Continue reading