Is it possible to search by guid?

(0) Share

Report

Posted on by Tango

1,164

Hi,

I have a Canvas app with a Dataverse backend.

i have created a Search function to a modern table but it won’t let me select the Unique Identifier as one of the columns to search. All others work fine, intelligence won’t allow Unique identifier column.

Thanks in advance for any assistance

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Shashank Bhide 942 Moderator on at

Like (0)

Report

there's no "unique identifier" datatype in Dataverse, every table's primary key column is a GUID column, or you've lookup columns which refer to the GUID in another table. you can refer to the below video on how to search various types of columns.

https://www.youtube.com/watch?v=2XUKvXNfsIc

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@Tango - you can certainly Filter your table on the GUID using e.g.:

Delegable:

Filter( 'Your Data', Len(TextInput1.Text) = 0 || 'Your Guid Name' = GUID(TextInput1.Text) )

Non-delegable:

Filter( 'Your Data', Len(TextInput1.Text) = 0 || StartsWith( Text('Your Guid Name'), TextInput1.Text ) )

Non-delegable:

Search( AddColumns( 'Your Data', TextGUID, Text('Your GUID Name') ), TextInput1.Text, TextGUID )

Notes:

The above will also apply on a Modern Table Control.

Are you certain you cannot locate your Unique Identifier Column? The name of the field typically shares same name as your Dataverse Table.

Was this reply helpful? Yes No