You’re offline. This is a read only version of the page.
Announcements
136
Hello,
I need to split a table based on a sp column called term.
current flow has
I would like to add a space and headings again where the yellow line is
ideas?
Hi , @nattt7
According to your description, you want to add the Link break in your Html Table based on your Term column.
This is my test json and i put it in the Compose action to test:
Share
Report
All responses (
Answers (
[
{
"Term": "Summer2024",
"Week": "Week1",
"Start Date": "2023-01-01",
"End Date": "2023-01-02",
"Tasks": "task1"
},
{
"Term": "Summer2024",
"Week": "Week2",
"Start Date": "2023-02-01",
"End Date": "2023-02-02",
"Tasks": "task2"
},
{
"Term": "Summer2024",
"Week": "Week3",
"Start Date": "2023-03-01",
"End Date": "2023-03-02",
"Tasks": "task3"
},
{
"Term": "Break",
"Week": "Week1",
"Start Date": "2023-01-01",
"End Date": "2023-01-02",
"Tasks": "task1"
},
{
"Term": "T4 2023",
"Week": "Week2",
"Start Date": "2023-01-01",
"End Date": "2023-01-02",
"Tasks": "task1"
},
{
"Term": "T6 2023",
"Week": "Week2",
"Start Date": "2023-01-01",
"End Date": "2023-01-02",
"Tasks": "task1"
}
]And this is the result in my test flow:
This is my flow:
(1)The Compose action is to generate the test data which i have put above .
(2)The Compose 2 action:
{
"Term":" ",
"Week":" ",
"Start Date":" ",
"End Date":" ",
"Tasks":" "
}(3)The two initial variable actions:
string('')
(3)The Apply to each action:
item()?['Term']
items('Apply_to_each')?['Term']
(4)The last create html table action:
Best Regards,
Yueyun Zhang
