Windows 10: Transfer one table column data into another table column in power apps

The question is :1. Table 1 contain column with name country, this column contains data2. Table 2 also contains column with name country but this column is emptynow i have to reflect 1st table country column data to 2nd table country column

:)

 

BUG? : Excel forgets the Data Types of Table Columns in Data Model

Microsoft Office 365, Version 1809 (Build 10827.20181 Click-to-Run)

on Windows 10 Pro, 64-bit, Version 1803, OS Build 17134.345

I have a workbook with three tables in the Data Model, drawn from three tables on separate sheets in the workbook.

Whenever I close and re-open the workbook, the Data Type of every column in the Data Model in reset to "Text".

This creates several flow-on bugs:

- The column "Format" setting becomes confused for columns that were, for example, formatted as dates or times.

- More importantly, some calculated values are deleted from my Pivot Tables as the calculation (a "Max" in this case) is no longer compatible with the reset data type of "Text" - the column had been set to data type "whole number".

- As a result of the "Max" calculation being deleted, output Pivot Charts flowing from that Pivot Table end up blank.

I have tried multiple times to reset the data types of the columns, and save the changes. It always works fine once I have reset the data types, but once I close Excel and re-open the Workbook, the data types have again reverted to "Text".

I'll keep looking for workarounds, but this has shaken my confidence in relying on Data Models and Pivot Tables in Excel!

 

autofit text in table

What exactly is not working for you? Looking at he links bro67 provided, one of the 3 suggested solutions should resolve your problem.

 

[Narrator] Focus move out of table when selecting column header to sort it

Hi,

I'm looking at https://datatables.net/examples/basic. I've also a table in an internal Microsoft webpage which I cannot link here. This table uses almost the same structure as the one linked.

To reproduce: Turn on narrator and navigate to the "Name" column header using the tab button. Then press Enter to sort the column. Notice that the Narrator focus moves to another element, in this case, the 'Search' edit field in the top of the page.

The expected behavior is to keep the focus on the selected column (as happens when reproducing the above steps with Narrator turned off).

My internal also shows that Narrator does not forward any keypress event to the webpage (thus the impossibility of any hack around this issue).

Also questioned the "DataTable" devs about this issue here: Sorting table with narrator on switches focus to "Search:" edit field.