cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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

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 🙂 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Frequent Visitor

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.

Community Support
Community Support

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

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

 

Thanks

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (3,325)