Forum Discussion
bhavaM
Aug 07, 2023Copper Contributor
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...
- Aug 07, 2023
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.
- Create a SharePoint list for storing the birthdays and details
- Create a list view using filters so that only current month birthdays are visible
- Apply JSON formatting for your list view to make it look like quick links
- Create a SharePoint modern page
- 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:
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.
ganeshsanap
Aug 07, 2023MVP
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.
- Create a SharePoint list for storing the birthdays and details
- Create a list view using filters so that only current month birthdays are visible
- Apply JSON formatting for your list view to make it look like quick links
- Create a SharePoint modern page
- 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:
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.
- bhavaMAug 07, 2023Copper ContributorHi ganeshsanap, Could you please explain me how to apply json format for the list view to make it look like quick links
- Rob_ElliottAug 07, 2023Bronze 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 - ganeshsanapAug 07, 2023MVP
- Go to your SharePoint list view
- Click on view name from top right corner (Switch view options drop down)
- Select Format current view
- Go to Advanced mode
- 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.
- bhavaMAug 07, 2023Copper ContributorThank you so much ganeshsanap,
Can We change the web part of SharePoint link automatically using power automate