Data from dataverse is incomplete

(0) Share

Report

Posted on by RyanVH

145

Hi everyone,

I have a table with a many to many relationship. It has 2 custom columns a date column and hours column.

Whenever i try to fetch the data it only gives me the amount of hours. The date is always empty.

What is the best way to get all data from a lookup field?

Kind regards

Categories:

Microsoft Dataverse with Power Apps

All responses (5)

Answers (0)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@RyanVH

Have you tried using the Lookup function?
RyanVH 145 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mira_Ghaly

Yes I've tried the LookUp function aswell but it gives me the same result.

Thanks for the comment though 🙂
the365bit 136 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you give us more details such as how are you trying to access the data from a canvas app? And maybe a screenshot to help us to understand the context?
EricRegnier 8,720 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RyanVH, are you using a model-driven app or canvas app? Have you tried to look the source data in make.powerapps.com -->Data --> Table --> select table --> Data tab. A screenshot would be great as well. Cheers
RyanVH 145 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @the365bit and @EricRegnier

So to give a little bit more context
I'm using a canvas app to get data from dataverse.

I have two table with a relationship.
Training Table
Duration Table
1 Training can have multiple durations spread over different days.

When I select a training and try to put it's durations in a collection by doing this
ClearCollect(colTrainingDurations, varSelectedTraining.Durations);
I get a list of Id's in de colTrainingDurations.

After that I've tried many ways(filter, lookup,..) to get the durations with all properties but I only get the "Id" & "Hours". The date property remains empty.

In the screenshot below you can see a duration from dataverse

Kind regards
Ryan