Hello everyone,
I need to create a flow that does the following when a response from MS Forms comes in:
- Create a new excel file in SharePoint based on the current date of the response (i.e. "CurrentDate_Responses.xlsx") where CurrentDate is a dynamic object
- For any new responses,
- Flow will check if response date matches CurrentDate. If it matches, it puts the response in CurrentDate_Responses.xlsx
- If response date does not match CurrentDate, it will create a new excel file in SharePoint "NewDate_Responses.xlsx" and puts the response there
Please note that CurrentDate and NewDate are only placeholders and they're meant to actually represent a date format. For example, if a response is taken on March 14, 2025, the excel file created will be called "14032025_Responses.xlsx". If a response from a new date is taken, say March 15, 2025, the excel file will be "15032025_Responses.xlsx".
Hope that makes sense!
- I'm not sure how to dynamically link the form response date to the excel file name when creating a new file
- If I create the column names as shown in the video and have the response from MS Forms be added as a row, it gets added in the rows where the column names are
I know this might be a pretty complex scenario, but any advice or help will be very much appreciated!