SOLVED

Changing SharePoint Quick links automatically via power automate

Copper Contributor

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 :)

10 Replies
best response confirmed by bhavaM (Copper Contributor)
Solution

@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.

Hi @ganeshsanap, Could you please explain me how to apply json format for the list view to make it look like quick links

@bhavaM 

  1. Go to your SharePoint list view
  2. Click on view name from top right corner (Switch view options drop down)
  3. Select Format current view
  4. Go to Advanced mode
  5. Add/Paste the JSON you want to apply and click Save

Check this documentation for detailed information: Use view formatting to customize SharePoint 


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 you don't even necessarily need the JSON, just create a gallery view:

 

1.  List:
0-SP-AllItems.png

2. View filtered for today's birthdays: 

 

1-SP-TodayView.png

 

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

 

2-SP-MoreThan1.png

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

Rob
Los Gallardos

Thank you so much @ganeshsanap,
Can We change the web part of SharePoint link automatically using power automate
No you can't. Why not just have the image in the list as I did rather that in a document library or somewhere else?
Thank you so much @Rob_Elliott
I have an issue as these details are come from Api, So I need to use power automate. But power automate will not support image data type. What Can I do so. Please help me.

@bhavaM Are you asking about updating Image URL in SharePoint list for each employee (list item)?

 

You can use Image columns in SharePoint list directly instead of using image URLs from somewhere else. Check this: SharePoint Online: All you need to know about New Image column type   

 

Then you can use the images from SharePoint list image column in your JSON formatting.


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.

Hi @ganeshsanap
But My data's comes from Power automate, Where it does not support image data type.

@bhavaM Check these article for adding/updating SharePoint image columns:

  1. Add an image to SharePoint Image columns using Power Automate
  2. Update image in SharePoint/Microsoft Lists Image columns using Power Automate
  3. Add, update, or delete images in SharePoint/Microsoft Lists using Power Apps 
  4. Add/Update image columns in SharePoint/Microsoft Lists using PnP PowerShell 
  5. Add/Update image columns in SharePoint lists using CLI for Microsoft 365 

If you are already using Power Automate flow for adding/updating SharePoint list items, you can easily update the image URL in list as well. It depends on how you have configured your flow currently.


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.

1 best response

Accepted Solutions
best response confirmed by bhavaM (Copper Contributor)
Solution

@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.

View solution in original post