cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SharePoint rows into column

Hi All,

 

I have a business requirement to SharePoint column data divided into multiple rows by project.

Example: 

Project NameIT LeadDateText column
ABCDABCD ABCD
XYZXYZ  

 

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 NameIT LeadColumnSeverity
ABCDABCDDate is blank3
XYZXYZdate is blank3
XYZXYZText is blank5

 

How can I accomplish this?

 

Thanks in advance!

12 REPLIES 12
Anonymous
Not applicable

@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.

Hi @Anonymous :

Thanks for your feedback.

I'm glad to hear that you have solved this problem.

Best Regards,

Bof

Anonymous
Not applicable

@v-bofeng-msft actually i need help with one issue. I have posted the question but no feasible solution found for it.

Link to the question:

Extract Datetime from string 

 

it would be great if you could help me out in this please.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,303)