Hi,
When I search for some text it is giving me the result from SharePoint. Now am stuck with the split formula (which I used in powerapps gallery to display the data from power automate to gallery in proper format) For 2 column am able to split but am stuck with other 3 columns. Can you please help me with this.
For the above output am using the below formula:
ClearCollect(
VarCollection,
ForAll(
Split(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
Substitute(
SearchData2.results1,
"[",
""
),
"]",
""
),
Char(34),
""
),
"},{",
"#"
),
"{",
""
),
"}",
""
),
"#"
),
{
Title: If(
First(
Split(
First(
Split(
Result,
","
)
).Result,
":"
).Result
).Result = "Title",
Last(
Split(
First(
Split(
Result,
","
)
).Result,
":"
).Result
).Result,
Last(
Split(
Last(
Split(
Result,
","
)
).Result,
":"
).Result
).Result
),
Author: If(
First(
Split(
Last(
Split(
Result,
","
)
).Result,
":"
).Result
).Result = "Author",
First(
Split(
Last(
Split(
Result,
","
)
).Result,
":"
).Result
).Result,
Last(
Split(
First(
Split(
Result,
","
)
).Result,
":"
).Result
).Result
)
}
)
)
This formula is working for 2 columns but how to do it for 5 columns?


Report
All responses (
Answers (