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

Saving data gallery in an excel table

Hi everyone. I have a file with company information and i need display this in a gallery. Then, i need search the company and the selected value to be saved in another excel worksheets table, in a specific column. i attach file.

 

Example:

 

1) File (Empresas) - column "Empresa".

2) Gallery - Empresa, Rut, Region.

3) OnSelect - Empresa -> save selected data gallery value in another table of another worksheets.

 

CGamboa6_0-1638308410944.png

i want to search a specific compañy, select it and press a button and save this value in another diferent table.

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @CGamboa6,

Could you please tell me more about your need?

Do you want to save the gallery selected value to another excel table?

 

To sum up:

1). you have a gallery populated with a file including company information. 

2). you want to search the gallery based on a specific company using the search box.

3). select the specific company in the gallery and save it to another excel table.

 

If the above I understood is correct, you could try as below.

Set the Items property of the Gallery as below:

Filter(TableName, Searchbox1.Text in Empresa)// Empresa represents the company

Set the OnSelect property of the save button as below:

Patch(NewTable,Defaults(NewTable),{ColumnInNewTable:Gallery1.Selected.Empresa})
Best Regards,
Qi

View solution in original post

1 REPLY 1
v-qiaqi-msft
Community Support
Community Support

Hi @CGamboa6,

Could you please tell me more about your need?

Do you want to save the gallery selected value to another excel table?

 

To sum up:

1). you have a gallery populated with a file including company information. 

2). you want to search the gallery based on a specific company using the search box.

3). select the specific company in the gallery and save it to another excel table.

 

If the above I understood is correct, you could try as below.

Set the Items property of the Gallery as below:

Filter(TableName, Searchbox1.Text in Empresa)// Empresa represents the company

Set the OnSelect property of the save button as below:

Patch(NewTable,Defaults(NewTable),{ColumnInNewTable:Gallery1.Selected.Empresa})
Best Regards,
Qi

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,275)