Create a survey from one data source and export data to a new excel sheet

[gkg99]

I have made an app using an excel sheet as my data surce, which essentially works as a survey (with drop down options from the excel sheet).

This app is to then be used by others in my organisation to fill out their daily tasks.

How would I get the data entered to export to a different excel sheet to the one I started with? Is this even possible?

Thanks 🙂 

[Atsushi_Ishida]

Are Excel sheets in the cloud like one drive?

If so, you can define another table on the file and write the data using the collect function.

If files is in local, you will need to use an on-premises data gateway, which can be complicated.

[v-xida-msft · Accepted solution]

Hi @gkg99 ,

Could you please share a bit more about your scenario?

Do you want to store the data entered within your Survey form into another different Excel sheet?

Based on the needs that you mentioned, I think PowerApps could achieve your needs. Firstly, you could consider add another sheet within same Excel file which contains your above Excel table data source, then format the new Excel sheet as Table format.

After that, you could re-creating a new connection to your Excel file from your app, then choose the new formatted Table as a data source within your app.

If you want to patch/save the data entered within your Survey form, I think the Patch function could achieve your needs. Please consider take a try with the following Patch formula to save your data:

Patch(
          'YourNewTable',
           Defaults('YourNewTable'),
          {
             Column1: Dropdown1.Selected.Value
             Column2: Dropdown2.Selected.Value,
             Column3: Dropdown3.Selected.Value,
             ...
          }
)

More details about the Patch function, please check the following article:

Patch function

Best regards,

[gkg99]

@v-xida-msft thank you this is exactly what I wanted!

Would it be possible to do this with a time picker?

Thanks