[CoE Starter Kit - BUG] CoE Admin Command Center - CoE Dataflows names

[Titoleto]

Does this bug already exist in our backlog?

• I have checked and confirm this is a new bug.

Describe the issue

I have noticed that there are repeated names in the CoE Admin Command Center app, in the CoE Dataflows

Expected Behavior

No response

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.11

What app or flow are you having the issue with?

CoE Admin Command Center

What method are you using to get inventory and telemetry?

None

Steps To Reproduce

No response

Anything else?

No response

[Jenefer-Monroe]

I just looked through the app and I dont know how this could happen. Can you please check for an unmanaged layer on the page?

[Titoleto]

I just looked through the app and I dont know how this could happen. Can you please check for an unmanaged layer on the page?

It's very curious, because today I get the names repeated in other Dataflows.

Here is a screenshot of what you asked for

[Titoleto]

I just saw the problem when editing the page and the problem is in the collection "col_coeDataflows", (this I leave, the same would happen with "CoE BYODL Flows and CoE BYODL Flows Connection or with CoE BYODL Apps Last Launched Date or with CoE BYODL Flows Last Run Date"), this is so because these flows start with the same thing

If there are rows in the table "msdyn_dataflowrefreshhistory" in which the field "msdyn_dataflowname" can have both the value CoE BYODL Apps and the value CoE BYODL Apps Connection, if we filter using the IN clause, then it is normal that when we are reading the value CoE BYODL Apps, even if we sort downwards, it could take a value from the row CoE BYODL Apps Connection.

Collect(
col_coeDataflows,
First(
Sort(
Filter(
DataflowRefreshHistories,
"CoE BYODL Apps" in DataflowName
),
EndTime,
SortOrder.Descending
)
)
);

Collect(
col_coeDataflows,
First(
Sort(
Filter(
DataflowRefreshHistories,
"CoE BYODL Apps Connection" in DataflowName
),
EndTime,
SortOrder.Descending
)
)
);

This is the solution:

Collect(
col_coeDataflows,
First(
Sort(
Filter(
DataflowRefreshHistories,
"CoE BYODL Apps" in DataflowName,
Not("CoE BYODL Apps Last Launched Date" in DataflowName),
Not("CoE BYODL Apps Connection" in DataflowName)
),
EndTime,
SortOrder.Descending
)
)
);
Collect(
col_coeDataflows,
First(
Sort(
Filter(
DataflowRefreshHistories,
"CoE BYODL Flows" in DataflowName,
Not("CoE BYODL Flows Connection" in DataflowName),
Not("CoE BYODL Flows Last Run Date" in DataflowName)
),
EndTime,
SortOrder.Descending
)
)
);

I just looked through the app and I dont know how this could happen. Can you please check for an unmanaged layer on the page?

[Jenefer-Monroe]

Thank you for pressing and investigating. Odd that I don't repro and your thoughts seem correct.
Can you see if this fixes it at well? Basically just change everything to = instead of in

[Titoleto]

Yes, much better as you have indicated

It works properly

Thank you for pressing and investigating. Odd that I don't repro and your thoughts seem correct. Can you see if this fixes it at well? Basically just change everything to = instead of in

[CoEStarterKitBot]

@Titoleto This has been fixed in the latest release. Please install the latest version of the toolkit following the instructions for installing updates. Note that if you do not remove the unmanaged layers as described there you will not receive updates from us.