This is a detailed tutorial covering how to deal with multi-value fields, creating hyperlinks directly to SharePoint item records, calculating whether items are overdue, and more.
Here is the concatenation formula we used in a calculated column the table: Stakeholder Names = CALCULATE(CONCATENATEX(Stakeholders, Stakeholders[Stakeholder Name], ", "))
If you're using the SharePoint list to manage requests, you may like this article that goes into detail on the topic: https://christine-payton.com/request-managment-in-m365-lists/
⏲️ TIMESTAMPS
0:28 Why SharePoint
3:30 Connecting to the list data
5:00 Cleaning the data
6:34 Getting people profile data
8:45 Dealing with multi-value fields
10:51 Hyperlinking to the SP item record
15:16 Relating our multi-value dimension
15:52 Creating visuals
16:49 Changing the date format
17:31 Configuring the item hyperlink
18:30 More visuals
19:38 Custom-sorting text axis labels
22:55 Date table
24:26 Creating a button to link to the "new item" form in SP
26:46 Calculating the "overdue" record count
?️ RESOURCES
- Blog article on the v2 vs v1 SharePoint Online List connector: https://christine-payton.com/sharepoint-v2-connector/
▶️ RELATED VIDEOS
- UPDATED version of this video here: https://youtu.be/ofQFAZ7jrbc?si=N5Is_lyrBTPI1R5Q
- Create a task list in Microsoft Lists: https://youtu.be/gYwkfwyRIxI?si=LUT_NFLFdZeviEOS
- How to create a SharePoint list to act as a form: https://youtu.be/Lnl8jKx1THI
- How to embed a Power BI report in SharePoint: https://youtu.be/3oXKWOfP3GE?si=y10g6UCGBRGb5kVy
CONNECT WITH ME
? Get new videos via email! - https://bi-ome.kit.com/youtube
? Blog - https://christine-payton.com/
? LinkedIn - https://www.linkedin.com/in/christinehpayton/
? Questions? Drop them in the comments! Your question could help others too.