How to setup SharePoint 'bullet list' column with JSON format?

Question

I have a SharePoint list which data gets fetched from an MS Forms via Power Automate. Some of the columns are set to be 'Multiple lines of text'/'enhanced rich text' in order to be able to capture and keep the data in that specific column.

Now, my problem is that this data is kept in a sequence and not under each other in an ordered 'bullet' form.

How can I set the 'bullet list' form for a column in a SharePoint list? - So that every time a data gets extracted from MS Forms it would be in a 'bullet list'.

(I am no developer, but I read that this should be feasible via JSON).

Attached a picture for reference where 'Sample' is the desired outcome and 'Sample 2' is the current default format.

Answer 1

Dear Mark,

Thanks for your updates and letting us know the current situation in your environment.

Yes, you can create a survey or form instead of Microsoft Forms. You can embed the PowerApps for on the SharePoint site page as well.

As you can click on Integrate>PowerApps>customize the form to create the form and the form is already connected and synced to the SharePoint list, each data you type and select in the form field will be automatically populated to the SharePoint list.

Here is an article about how to start with PowerApps for your reference, hope it helps in your environment.

Customize a Microsoft Lists or SharePoint form by using Power Apps (contains video) - Power Apps | Microsoft Learn

Welcome to share any updates when you have time if you need further help on this issue.

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator

Answer 2

Hi Cliff,

Thanks for your help.

Would you also be able to help me with the following?

• If I make an attachment field mandatory in MS Forms, how do I make it visible on the SharePoint list? Because in the list the field remains empty.

(I'd like to setup an approval process via Power Automate, so if the attachment is enclosed then the 'approval' (me) can review the attached file and either approve or deny access to a SharePoint folder/library.
The condition - start and wait for an approval, create item, grant access to an item or a folder, I've already figured out, but I still don't see the attachment).

Thanks and best regards,

Mark

Answer 3

Dear Mark,

Thanks for your updates.

The built-in Attachment field will not show attachments by default.

You may create a multi-line text column and use Power Automate to show attachments on the column.

For the detailed steps, you can refer to Attachments from Mircosoft Form to Lists - Microsoft Community.

If you want to attach files in the approval app in Power Automate, you can refer to the way mentioned in Can the Power Automation Approvals Flow attach a file into the - Microsoft Community.

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator

Answer 4

Dear Bende13,

Welcome to the form here.

I'm afraid that the multi-line text column can't be formatted as the array format (bullet list). You can only use the Choice column to format the bullet list.

So if you want to apply the format, I suggest you create the Choice column and use Power Apps to customize the form instead of using Power Automate to append the data from Microsoft Forms to the list as a workaround. You may apply the JSON code only on the Choice column and the choice question.

You can customize the form as you like and embed it on a SharePoint page for users to fill like the following.

And then you can apply the following code on each Choice column to see the result in your environment.

{

    "$schema":

    "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

    "elmType": "div",

    "txtContent": "='•'+join(@currentField, '\n•')"

 }

Thanks for your understanding and have a nice day!

Sincerely,

Cliff | Microsoft Community Moderator

Answer 5

Hi Cliff,

Thanks for your prompt reply.

Unfortunately, I have no experience with PowerApps. Would that be also possible to setup a survey in PowerApps instead of MS Forms or link PowerApps to MS Forms? (With the lack of PowerApps knowledge, I don't fully see the picture here).

Would you be able to elaborate a bit on this?

• The most important thing here is that I have 30+ questions which data (answers) need to be automatically captured and stored somewhere. (That's why I figured using MS Forms and showing data in a SharePoint list is a fairly easy option). However, if there's a better way to do so, I'm open for suggestions.

Best regards,

Mark