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 the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.