Some column names only different by letter case - how to resolve that in Power Query Map Tables?

[Syndicate_Admin]

Context:

https://make.powerapps.com/environments/x/dataintegration/list/y/edit?df_enableTridentStyle=0&pqo_en...

Recently I created a new Power App Data Flow with SharePoint Online List as source.

Then, obtaining the error message:

Some column names only different by letter case. Please update the column names to be unique case-insensitive names.

The look and feel in the web browser - Power Query - Get Data - Map Tables - Column Mapping indicates that I cannot customize the mapping between Source column and Destination column!

The share point list (source) includes two fields: id and ID.

The fields id and ID seem to be default in SharePoint.

How do I update the mapping if the "mapping editor" is read only?

At the sharepoint site I am the list owner - but don't have permission to delete fields id or ID.

See attachment for illustration.

[v-jingzhan-msft]

Hello Mamiju

From the description you've provided, it appears that the issue arises because Power Apps Data Flow doesn't support case-sensitive column names. This is leading to a conflict due to the presence of both 'id' and 'ID' fields in your SharePoint list. Since the Power Query interface in the Data Flow doesn't allow you to customize the mapping in a read-only state, we'll need to approach this issue by ensuring that the column names in your SharePoint list are unique and case-insensitive.

Here's what you can do to resolve the issue:

1. Rename Conflicting Fields in SharePoint:

   • If possible, rename one of the conflicting columns in your SharePoint list to have a distinct, case-insensitive name. Make sure that each column has a unique name.
   • To rename a column in SharePoint, navigate to the list settings, click on the column you wish to rename, and then change the column name.

2. Check Permissions:

   • Ensure you have the necessary permissions to make changes to the SharePoint list structure. As a list owner, you should have this capability, but if not, you may need to contact your SharePoint administrator.

3. Create a New Column:

   • If you cannot rename or delete the existing columns, consider adding a new column with a distinct name and then populating it with the data from one of the existing 'id' or 'ID' columns.
   • After creating the new column and copying the data over, you can hide the original column that's causing the conflict so that it's not used in the Data Flow.

4. Refresh the Data Flow:

   • After making changes to the SharePoint list, go back to your Power App Data Flow and refresh the data source. Check to see if the issue with column name case sensitivity is resolved.

If you continue to face issues and cannot alter the SharePoint list due to restrictions or permissions, you may seek help at SharePoint group (microsoft.com). 

Please keep in mind that any changes to the SharePoint list structure should be done carefully to avoid impacting other areas where the list may be in use.

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!