create a flow with forms, sharepoint e excel!!

Like (0) Share

Report

Posted on 16 Nov 2023 18:06:10 by CampBraz017

I created a workflow with the goal of:

I created a registration form for courses.

On one side, I am trying to create an Excel file based on the course (if a file doesn't exist yet).

On the other side, I want to search for this file and add a row with the information from the form.

In terms of creating a spreadsheet, I am thinking of limiting it to a single creation. During the process, all responses will be stored in this course spreadsheet.

My idea is to automate all of this so that every time a new form is submitted, it repeats this process, creating an Excel file on one side and adding rows with new participants on the other.

Can someone help me? I'm new to this...

All responses (1)

Answers (0)

Rhiassuring 8,688 Moderator on 16 Nov 2023 at 23:07:14

Like (0)

Report

Re: create a flow with forms, sharepoint e excel!!

Well, first you'll need to add a "Get Response Details" so that you can read the content from the newly submitted form. That will give you dynamic content that you can access and put into your sheets.

After that, I mean, I can't see into your actions so I can't really tell what's happening - it looks mostly logical, but I can't see into the Apply to Each.

Let me know where you hit errors once you've created the Get Response Details (immediately after your trigger.)