cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gkg99
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
v-xida-msft
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
Atsushi_Ishida
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.

v-xida-msft
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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,309)