'How to have dynamic columns (like for weeks w1, w2, w3...) to contain number value as score in Sharepoint list
See attached spreadsheet screenshot.
How to incorporate dynamic / ever increasing columns with custom labels such as W1, W2, W3 to contain number value (score 0-4). Presently I have spreadsheet to record score. How is it possible to achieve via SP list using SP List or Powerapps?
- One way is I can have Title as text but how can I save week values? How will I increment column name at runtime?
Solution 1:[1]
No easy way using just SharePoint, except to prebuild all of the "W" columns. You could use unpivoted data (Title, Wnumber, value) in a SharePoint list and then use an embedded Power BI report to display the data.
The Power Apps solution would be similar to the Power BI.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Mike Smith - MCT - MVP |