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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.