Forum Discussion

bhavaM's avatar
bhavaM
Copper Contributor
Aug 07, 2023
Solved

Changing SharePoint Quick links automatically via power automate

Hi, hope all are doing well.

My requirements is,

 1. I have a list named Birthday wishes where it has column such as Name, Birthday_date, Emp_No, and image. where the image column contains a URL of an employee's image. This list would be changed daily as per the birthday of employees.
 2. I have a page in my SharePoint site, where I have a quick link web part or link web part.
3. My need is to add the image URL in quick link web part or link web part automatically whenever the URL changed.
4.These functionalities can be done through power automate or without power automate
Please Help me to solve my problem. Thanks in advance 🙂

  • bhavaM I will suggest you to try below SharePoint out of the box approach instead of using Quick Links web part and Power automate flow/PowerShell/custom solution for updating the links/image URLs.

     

    1. Create a SharePoint list for storing the birthdays and details
    2. Create a list view using filters so that only current month birthdays are visible
    3. Apply JSON formatting for your list view to make it look like quick links
    4. Create a SharePoint modern page
    5. Add list web part on page --> select your list  --> Edit web part settings --> select your list view showing current month birthdays.

    Check below SharePoint JSON view formatting samples which will help you:

    1. Birthdays 
    2. Icon Link Tiles 
    3. Modern Event Tiles 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

  • bhavaM I will suggest you to try below SharePoint out of the box approach instead of using Quick Links web part and Power automate flow/PowerShell/custom solution for updating the links/image URLs.

     

    1. Create a SharePoint list for storing the birthdays and details
    2. Create a list view using filters so that only current month birthdays are visible
    3. Apply JSON formatting for your list view to make it look like quick links
    4. Create a SharePoint modern page
    5. Add list web part on page --> select your list  --> Edit web part settings --> select your list view showing current month birthdays.

    Check below SharePoint JSON view formatting samples which will help you:

    1. Birthdays 
    2. Icon Link Tiles 
    3. Modern Event Tiles 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    • bhavaM's avatar
      bhavaM
      Copper Contributor
      Hi ganeshsanap, Could you please explain me how to apply json format for the list view to make it look like quick links
      • Rob_Elliott's avatar
        Rob_Elliott
        Bronze Contributor

        bhavaM you don't even necessarily need the JSON, just create a gallery view:

         

        1.  List:

        2. View filtered for today's birthdays: 

         

         

        3. Web part added to a page showing how it displays if more than 1 person has a birthday on the same date:

         

        You could then build a simple flow to run on the 1st of January each year to update the birthday column.

        Rob
        Los Gallardos

Resources