microsoft / coe-starter-kit

Other
742 stars 219 forks source link

[CoE Starter Kit - BUG] HELPER - Get Connections to Clean #8133

Closed PPCan closed 4 months ago

PPCan commented 5 months ago

Does this bug already exist in our backlog?

Describe the issue

HELPER - Get Connections to Clean inventory flow fails with the below. Note 3 times this flow failed on the same inventory run.

image

Expected Behavior

No response

What solution are you experiencing the issue with?

Core

What solution version are you using?

4.29

What app or flow are you having the issue with?

HELPER - Get Connections to Clean

What method are you using to get inventory and telemetry?

Cloud flows

Steps To Reproduce

No response

Anything else?

No response

AB#2973

Jenefer-Monroe commented 5 months ago

Please go to the step above and get the output of this action image

Does it return records? Its saying that that properties > apiId is null which does not seem possible. Do you see any that are malformed there? image

PPCan commented 5 months ago

Yes there are records in the output. image

Jenefer-Monroe commented 5 months ago

I believe the error in that select statement is saying that there are rows in there without the highlighted field (properties / apiId) Can you please look through and see if you find cases like that?

PPCan commented 4 months ago

Well, there are 118889 lines of code in the output. Do you have a suggestion on how to do that in a practical way?

Do you have an email address I can send the file too?

Jenefer-Monroe commented 4 months ago

Not being with you, I think the only way I know to help is to have you step out and make a new flow to investigate

Note the envt name in this call for the envt that is failing for you image

  1. Create a new flow.

  2. First action: Power Apps for Admins connector > Get Connections as Admin action.

  3. Enter your envt name image

  4. Set pagination on this action to 100000 image image

  5. Add a select statement From: value from the above Map: as shown the_ID : @coalesce(item()?['properties/apiId'], 'noID') image

  6. Save and run

  7. Look for the string noID in the output of the select

Jenefer-Monroe commented 4 months ago

closing out as no further action for starter kit team