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

Anonymous
2022-11-22T13:55:17+00:00

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.

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2022-11-24T21:09:23+00:00

    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

    0 comments No comments

9 additional answers

Sort by: Most helpful
  1. Anonymous
    2022-12-15T13:26:40+00:00

    Dear Mark,

    Thanks for your updates.

    It seems that you don't indert <a href='linktofile'>linkdescription</a><br> on the multi-line text column in your flow. You may enable Use enhanced rich text in the multi-line text column and then follow the flow steps I listed above to create a flow again to see the result.

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

    Thanks for your effort and time!

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

    Sincerely,

    Cliff | Microsoft Community Moderator

    0 comments No comments