Unanswered

Repeat Dropdown on Gallery not working with Dataverse

(0) Share

Report

Posted on by protonme

Hi All,
I am working on a simple app to collect contact information, app is working fine with SP connection but does not work with Dataverse.

1) With Sharepoint it is as follows:

- Button 'On Select' :

ClearColelct(updates, 
{Name: Blank(), 
TypeContact: Blank(),
ID:1 });
Set(varContacts, "add")

Gallery Items:
If (varContacts = "add", updates, Filter('Contact Users', TypeContact = "Contact"))

Dropdown on the gallery:

Items:DropdownSample

On Change:
If(varContatcs="Add", 
With ({wLastID: Last(Updates).ID},
If (varContacts="Add" And ThisItem.ID = wLastID, 
Collect(updates, {ID: wLastID+1}
)))

Works like a charm, everytime I change dropdown, galerry repeats with new line, but when I switch to dataverse it does not work, I cannot refer to ThisItem.ID I only get "IsSelected" as an option.

I do not understand the issue, is it a DV thing that it cannot show empty rows? Or am I missing something?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

cha_cha 4,932 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @protonme ,

In SharePoint, it's possible to refer to an item's ID directly as it's a standard field for all lists. However, in Dataverse, the unique identifier for a record is typically referred to as the primary key and it's not necessarily named "ID". The primary key field could have a different name depending on the table in Dataverse.

If you want to continue using a similar way as SharePoint, add an Autonumber type column named ID in your dataverse.

Was this reply helpful? Yes No
protonme 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @cha_cha ,

Thanks for the reply. I added the column but still do not get "ID" as a suggestion for ThisItems ;/ Any idea what step I may be missing?

Was this reply helpful? Yes No