Share
ReportHello 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've tried creating a flow based on this video: https://www.youtube.com/watch?v=gr62sT2Ywd8 and it has the general structure of what I'm looking for, but my issues are as follows:
- 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!
Categories:
All responses (
Answers (
9,770
