I have a business requirement to SharePoint column data divided into multiple rows by project.
|Project Name||IT Lead||Date||Text column|
Now based on the above data i want to create a collection that displays data in the below format.
severity is assigned as per column. So for date if it is blank severity 3 will be provided and if text column is blank then severity should be 5.
|Project Name||IT Lead||Column||Severity|
|ABCD||ABCD||Date is blank||3|
|XYZ||XYZ||date is blank||3|
|XYZ||XYZ||Text is blank||5|
How can I accomplish this?
Thanks in advance!
Solved! Go to Solution.
@v-bofeng-msft i have completed this requirement through multiple if condition and Patch method that patches the record to a collection and thus i am using that collection to view the data.
Thanks for your input.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks