Power Platform Community Forum Thread Details

Hi guys,

I have a Forms that is active and is going to receive multiple responses everyday. When I download the responses by clicking "Open in Excel" this file is already formatted as a table.

Then I processed the data from Forms in columns AH, AI, AJ, AK, AL. The other columns are the same and will receive other responses. Column B --> AH and AI / Column C --> AJ and AK / G --> L (Columns B, C and D will be kept)

➡️➡️➡️

I saved this file directly in OneDrive for Business so it's in the cloud.

I would like to link the responses from Forms to this file in OneDrive or Sharepoint using Power Automate so it would be updated automatically (adding a new row to this dataset) without the need for my computer to be turned on or connected to the internet.

Would this be possible to be done? If not like that, how?

I appreciate any help here.

Categories:

Using flows