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

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (23,048)