Hello!
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:
Refresh(BackendDatabases);
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!
Andy
Hi @AndyH_JSY,
Did you check that the records do existing in CDS to eliminate the Dataflow as the issue if delete rows option is enabled? Can you check that the records exists with "Advanced Find" in your CDS environment.
Cheers
Hi @EricRegnier,
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.
Cheers
I still seem to be getting intermittent issues with loading data in PowerApps.
Any suggestions are welcomed!