Friday, September 13, 2019

Iterate SharePoint list items and send an email to recipient using MS Flow


In this blog, we are going to learn how to iterate the Sharepoint list items and send an email to the recipient using MS Flow and if you are looking a solution to send an email using Sharepoint workflow then you can refer this blog.

I am going to create custom list in modern site and planned to create multiple column in different data types like people picker, lookup column, data & time field to check whether I can get the value from respective column.

As a first step, I just changed the title column as non-required and you can see the remaining columns with data types on below image


And I have filled some information’s in the list, here I can create only two items since I am having only two valid users in my tenant.


Now, we are going to create a flow to send all the list item to any of the recipients. You can go the flow designer either using Flow option from the List ribbon or you can use Tiles from app launcher.


So, as an initial step. We need to create a trigger point. So, I chosen recurrence action and set Interval to run every month in India’s timing.


Second action, selected Sharepoint-get items and provided Site address and List Name



Third action, selected Data operation – Create HTML Table and mapped List items in From column and selected columns as a custom. Then under Header I just typed column header manually like employee name, employee type and so on.

And under Value column, you can use dynamic content option to select the respective values and always prefer to select column values like highlighted below. Otherwise you will not get proper email body.



Fourth action, you can select Compose to convert RAW data with table content and in inputs you can choose replace expression and add below given formula to generate the table border

replace(body('Create_HTML_table'),'<table>','<table border="2">')

And finally, send an email action and add your output in email body (make sure selecting output value under compose category). In this blog I am sending list items to my email ID


And recipient will receive email like below format.




Wednesday, September 4, 2019

How to create secure list in OneDrive

As we are thinking that OneDrive can offer only document library to store our personal documents, but technically OneDrive comes from SharePoint family. So, it can offer lots of feature like SharePoint.

So, in this blog, we are going to learn how to create a new list in OneDrive using GUI. And I am going to create a new list to store my upcoming event information and in future I will setup MS Flow to send a reminder email to me.

Most of the SharePoint techie knows, how the SharePoint URL designed and Basically, OneDrive URL formation will be like following format

So, in the above URL just replace Onedrive.aspx to viewlsts.aspx at end of the URL, it will take you to the Site Content page, where you can view and create List, Library, sub-sites and adding SharePoint Apps.


As highlighted in above image, just click new button and select List and on next screen just provide your list name. in my case I just given like MyList and checked Show in site navigation checkbox.


One thing we should know, OneDrive home page has some customized left navigation, so your newly created list will not be displayed.


Once list created, click GOG icon from top right and click List setting to customize your newly created list



I have created Some columns and items in the list


Now if you go to your OneDrive home page, you can’t see your newly created list on Left navigation, so you can copy your List URL and add it in your default library as item. Click new and select link option.



Then, provide your list URL and provide file name for it. And it will store like a bookmark for you


And finally, you can see your new list added in the root library as an item, so you can setup a separate permission for that URL items.