I have a CDS Entity with a DataFlow setup to get data from Excel every 2 minutes. The excel table is 8 columns and 1300 rows.
I have a PowerApp with a ComboBox that displays the 'Customer Name' field from CDS using:
Distinct(BackendDatabases.'Customer Name', 'Customer Name')
90% of the time this works and I can see all the customer names, however periodically I can only see a few out of the 50ish customer names. I have tried adding a button to refresh the source using:
This was unsuccessful.
Has anyone experienced anything similar? Its as if they are in CDS but there's an issue between CDS and PA communications.
Thanks in advance!
Thanks for your reply!
I can confirm all records are in CDS correctly and I can find them.
This appears to be an issue with using the entity as an Item within PowerApps. It works most of the time, just quite intermittent.