Forum Discussion
Trying to create a user forum on a SharePoint Online site
fred_valaris if a Yammer community wasn't suitable (which it probably would be) what I would probably do in this scenario is to have a form on your SharePoint site that saves the response to a list in SharePoint via a flow in Power Automate. You would create a view of the list and format that view with JSON to make a nice-looking forum-type section on the page. I've done this one one of my sites for a suggestions forum-type situation.
Come back to me if this looks like what you want and you need the detailed flow steps and the JSON code. But you'll see we are also using a Yammer community.
Edit: Steven Andrews the discussion board can't be used in the modern experience, so Yammer or my solution above with a form, flow and list are the available - and very good - options.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- How do we get the flow steps?
JohnH710 have a look earlier in the thread, I posted up a screenshot of all the steps in the flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
This is very interesting. I am looking for something like this.
User to submit question.
Wil you be able to share the JSON for the view.
Thank you
bbsin The user submits a question using a form from Microsoft Forms embedded on a page and that form triggers a simple flow in Power Automate:
The suggestion is added to the list and any response is added separately. The view of the list that we display on the page is shown below:
..and the JSON view formatting for that is:
{ "$schema": "https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json", "hideSelection": true, "hideColumnHeader": true, "rowFormatter": { "elmType": "div", "_comment_": "MAIN DIV", "attributes": { "class": "ms-bgColor-themeLight" }, "style": { "display": "flex", "flex-wrap": "wrap", "align-items": "stretch", "flex-direction": "row", "padding": "20px", "margin-bottom": "16px", "max-width": "400px", "border-radius": "10px", "background-color": "#660066" }, "children": [ { "elmType": "div", "style": { "flex-grow": "1", "display": "flex", "flex-direction": "column", "flex-wrap": "nowrap", "align-items": "left", "max-width": "400px", "min-width": "205px" }, "children": [ { "elmType": "div", "style": { "display": "block", "font-size": "15px", "font-weight": "normal" }, "children": [ { "elmType": "span", "txtContent": "=[$Title]", "style": { "display": "=if([$Title] == '', 'none', 'block')", "color": "white" } }, { "elmType": "span", "txtContent": "[$SubmittedOn]", "style": { "display": "=if([$SubmittedOn] == '', 'none', 'block')", "color": "white" } }, { "elmType": "span", "txtContent": "='Suggestion: ' + [$Suggestion]", "style": { "display": "=if([$Suggestion] == '', 'none', 'block')", "padding-top": "20px", "margin": "0 20px 20px 0", "color": "white" } } ] } ] }, { "elmType": "div", "_comment_": "DIV TWO", "style": { "flex-grow": "1", "display": "flex", "flex-direction": "column", "align-items": "left", "max-width": "310px", "min-width": "155px" }, "children": [ { "elmType": "div", "style": { "display": "block", "font-size": "15px", "txtContent": "='Comment: ' + [$Comment]", "font-weight": "normal", "color": "white" }, "children": [ { "elmType": "span", "txtContent": "='Comment: ' + [$Comment]", "style": { "padding-right": "5px", "display": "=if([$Comment] == '', 'none', 'block')" } } ] }, { "elmType": "div", "style": { "display": "block", "font-size": "15px", "font-weight": "normal" } } ] } ] } }Rob
Los Gallardos
Microsoft Power Automate Community Super User- Hello RobElliott.
I was looking for this exact solution, I had suggestions directed only to an email but wanted to make them visible to everyone who views the website.
I was trying to apply your "Create item" solution but I don't know what the "List Name" is refering to and I don't get any suggestions either.
Is is a precreated list on the website? Don't know what I'm missing..
Thank you in advance.
Alexandre
This looks very interesting, thanks for posting this.. If fred_valaris doesn't want to learn more I certainly do! I'd be interested in the steps you mention.
