Power Apps

Power Apps Dataflow

(0) Share

Report

Posted on by Thansson

522

I'am trying to create a new dataflow.

When i come to create new table, i get the failure:

There is no column of type text, so no column can be selected as the primary name column.

I have created a unik column, formatted as text and set as key, but i get this failure no matter what I try?

Regards

Tony

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Suggested answer

stampcoin 5,171 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Thansson Hi,

The unique identifier field only accepts a string containing GUID values, any other data type or value causes record creation to fail.

Please check this link.

Setting a table’s Unique ID column and using it as a key field for upserting records into existing Dataverse tables

Enjoy Power Platform and have a great day 🚀 | My LinkedIn

If the answer helps, please consider 👍, Thanks.

Was this reply helpful? Yes No
Thansson 522 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @stampcoin

I can see that all my powerapps dataflow have the the same issue, if I open an old dataflow (Still running), and try to add a new

table, same failure, even its is already working.

The failure can not be the unique identifier ?

Best

Tony

Was this reply helpful? Yes No
stampcoin 5,171 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Thansson Hi,

Could you please provide more details ? with be helpful if you can share some screen shot.

what do you mean by 'create new table ' ?

Was this reply helpful? Yes No
Thansson 522 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @stampcoin

I have created a new Dataflow, with a Unigue text Name ID

When I try to create new table in Dataverse:

It is on Danish, but the failure is: No column with texttypes, so no column can be used as primary Name column.

Best

Tony

Was this reply helpful? Yes No
stampcoin 5,171 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Thansson Hi,

I see, you might have something wrong when mapping the columns.

try to explicitly specify the primary column:

see my example:

Was this reply helpful? Yes No
Thansson 522 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @stampcoin

Thank you for your suggestion, bit I have already done this.

I have tried to let dataflow decide the key and also force the key to the unique text field

Can it be local settings og security ?

Best

Tony

Was this reply helpful? Yes No
stampcoin 5,171 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Thansson,

I don't think any local setting will affect that.

Something wrong within your data ( table), can you confirm that your data (with the key column) in the table is unique ( no duplication)?

Was this reply helpful? Yes No
Thansson 522 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @stampcoin

Yes i have made an indeks column, and merged it with a material number, and I have

also tried other solutions

Best

Tony

Was this reply helpful? Yes No