Unanswered

Use Html Text to get value from syntax in sharepoint list

Like (0) Share

Report

Posted on 20 May 2024 03:13:29 by ed120800

I have a SharePoint list to store string and I would like to use lookup intendent value by using "With" , "MatchAll" and "Filter" function. But it fails to look up the independent value from the string.

The String:

[{"Choices":"I have consented;I do not consent",

"ColumnType":"Choice",

"Data":"I have consented",

"Question":"“Which social media platforms do you use regularly? (Facebook, Twitter, Instagram, LinkedIn)”",

"Required":"Yes",

"Title":"Question1"},

{"Choices":"NA",

"ColumnType":"Text",

"Data":"aaaa",

"Question":"Please write down your reason if selected not consent","Required":"No",

"Title":"Question2"},

The Code:

Expect will show "I have consented" after "Topic 1 :" and "aaaa" after "Topic2 :"

Categories:

Using Apps Using Formulas

All responses (8)

Answers (0)

ed120800 66 on 20 May 2024 at 09:07:45

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

@v-xiaochen-msft
With your code I am able to get the lookup value on the html text box, but I only need to show the value of Question 1, 3 ,5 ,7 in the table below.

Any suggestion?
v-xiaochen-msft on 20 May 2024 at 08:56:26

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

Hi @ed120800 ,

Please note that the column names in the formula were automatically changed to incorrect values when I posted the reply.

Best Regards,

Wearsky
v-xiaochen-msft on 20 May 2024 at 08:53:41

Like (0)

Report
Re: Use Html Text to get value from syntax in sharepoint list

Hi @ed120800 ,

Try this

Concat( ForAll(Sequence( CountRows(ForAll(ParseJSON(ThisItem.Result),{data&colon;Text(ThisRecord.Data)}))),{Data:Index(ForAll(ParseJSON(ThisItem.Result),{data&colon;Text(ThisRecord.Data)}),Value).Data,Index:Value}) ,"Topic "&ThisRecord.Index&" : "&ThisRecord.Data&"    ")

Best Regards,

Wearsky
ed120800 66 on 20 May 2024 at 08:39:13

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

@v-xiaochen-msft

I put the code in HtmlText and it return error
v-xiaochen-msft on 20 May 2024 at 08:32:05

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

Hi @ed120800 ,

Could you show your code and screenshot?

Best Regards,

Wearsky
ed120800 66 on 20 May 2024 at 08:30:00

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

try to use it but doesn't work
ed120800 66 on 20 May 2024 at 04:00:35

Like (0)

Report

Re: Use Html Text to get value from syntax in sharepoint list

Hello @v-xiaochen-msft

Can you advise how to use your function?

Thanks
v-xiaochen-msft on 20 May 2024 at 03:42:57

Like (0)

Report
Re: Use Html Text to get value from syntax in sharepoint list

Hi @ed120800 ,

I made a sample for you with parsejson function.

Concat( ForAll(Sequence( CountRows(ForAll(ParseJSON(First(LIST60).Result),{data&colon;Text(ThisRecord.Data)}))),{Data:Index(ForAll(ParseJSON(First(LIST60).Result),{data&colon;Text(ThisRecord.Data)}),Value).Data,Index:Value}) ,"Topic "&ThisRecord.Index&" : "&ThisRecord.Data&"    ")

Best Regards,

Wearsky