Answered

Query related to DataTable

(0) Share

Report

Posted on by Anonymous88

Hi,

In our use case scenario we have multiple drop-down selections(coming in from SQL server) and based on these selections there is a dynamically changing DataTable of records(also fetched from SQL). My query is, can we save these records from DataTable to a CDS entity or SQL server in any way. Is DataTable data read only still? If there is any alternative of saving the records from DataTable, please let me know. Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

I suggest you replace the Datatable with a Gallery. Then use ForAll function to send the data.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
DevendraSingh 144 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
You can use the Patch function within a ForAll to update the data table records. Following are the steps,
Step1: Create a collection and populate with the data from SQL server or CDS, i.e. ClearCollect(colItems, GenericList)
Step2: Assign the collection to data table Items property
Step3: On the drop-down OnSelect property filter the collection, i.e. ClearCollect(colItems, Filter(GenericList, Title=ComboBox2.Selected.Value))
Step4: On button submit write the formula, i.e. ForAll(colItems,Patch(GenericList,LookUp(GenericList, ID = colItems[@ID]),{Title:"your value"})); Refresh(GenericList);
Please click Accept as Solution, if this solution solved your issue. If this post was useful, please consider giving it Thumbs Up.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous88 ,

Do you want to save the records in your Data Table back to your SQL Server or CDS Entity?

Based on the needs that you mentioned, I afraid that the Data Table could not achieve your needs. Currently, within canvas app, you could not select multiple records from Data Table once time, you could only select single one record once time.

If you want to save your Data Table records back to your SQL Server Table or CDS Entity once time, I think there is no way to achieve your needs in PowerApps currently.

As an alternative solution, I think the Gallery could achieve your needs. You could consider add a Gallery in your app, set the Items property to following:

Filter( '[dbo].[SQLTable]', Column1 = Dropdown1.Selected.Value, Column2 = Dropdown2.Selected.Value, ... )

Note: Apply same Filter formula within the Items property of Gallery as that in your Data Table.

Then within this Gallery, you could add several Text Input controls to display the column value from your SQL Table. Set the Default property of the Text Input to following:

ThisItem.Column1
ThisItem.Column2

....

You could also made some changes to the corresponding column through the Text Input Box directly. Outside, the Gallery, add a "Save" button, set the OnSelect property to following:

ForAll( Gallery1.AllItems, Patch( 'CDS Entity', Defaults('CDS Entity'), { Column1_Entity: TextInput1.Text, Column2_Entity: TextInput2.Text, Column3_Entity: TextInput3.Text, ... } ) )

Note: The TextInput1, TextInput2, TextInput3, ... represents the Text Input boxes in above Gallery to display column values from your SQL Table.

ForAll function, Patch function

More details about configuring a Gallery as a Editable GRID, please check the following video resource:

https://www.youtube.com/watch?v=41Mpgn7svLs&t=1s

https://www.youtube.com/watch?v=Y5G5p84mD84&t=321s

Best regards,

Was this reply helpful? Yes No