I am very new to Sharepoint, Forms and Flow. What I am trying to do is when a form response is submitted, automate a workflow to create a news post page on Sharepoint with datacollected from the form.
I would like to set the author of page to be the person who submitted the form.
The page title should be taken from one of the responses as well. The rest of the responses can be inside a Text webpart.
The key is automating all this in Flow (or Power Automate). No success so far after many hours of research and testing. I have only managed to collect data when a form is submitted.