cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidMLCarr
New Member

Cannot "Get items from an entity" because instanceId blank

I an creating a new flow and in step 1 I am using the "When a record is created" action.  I am connected to the CDS, and it correctly gives me a choice of the three organizations I can access, and I can enter an entity name.

 

In step 2, if I use the "Get items from entity (preview)" action, it shows a form requiring instanceId.  That field does not return my three instances.  If I click on the "identifier of an interface" so-called help text, the optionset shows "Loading" for a second and then "No items", and on the next line "Enter custom value".

 

So, if you have been able to "Get items from an entity", please reply.  Otherwise, I'll assume its an early preview bug and move on.  (The use case is trying to sum up values over all records in an entity).

Thanks,

Dave

1 ACCEPTED SOLUTION

Accepted Solutions
JatinSanghvi
Power Automate
Power Automate

@DavidMLCarr, the only action with name 'Get items from an entity' belongs to a different connector: Dynamics 365 Customer Insights. I do not think that will help with the task you have. If you only want to iterate through list of all records of given entity type, you need to select 'List records' action from Dynamics 365 or Common Data Services connector. Please feel free to post here if you have any questions.

View solution in original post

4 REPLIES 4
manuelstgomes
Community Champion
Community Champion

Hey @DavidMLCarr 

 

Can you please explain what you're trying to achieve?

 

In step 1, you have all the fields that you need for that record. You don't need to fetch the items again and can use their values right after.

 

Sorry if I'm missing something, but please let me know, and I'll try to help you.

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Thanks for replying @manuelstgomes 

I'm trying to get "Get Items from an entity (preview)" to work.

My goal is to loop through all records in one entity in the CDS and sum up a (series of) field values, and then write a "summary record" back into the CDS...

Thanks,

Dave

JatinSanghvi
Power Automate
Power Automate

@DavidMLCarr, the only action with name 'Get items from an entity' belongs to a different connector: Dynamics 365 Customer Insights. I do not think that will help with the task you have. If you only want to iterate through list of all records of given entity type, you need to select 'List records' action from Dynamics 365 or Common Data Services connector. Please feel free to post here if you have any questions.

@JatinSanghvi Many thanks, the "List records" action did the trick.

I now have a flow that has the following steps:

- Initialize Variables (counter and sum field)

- List Records (to return rows from Entity A)

- Apply to each, within which I use

      Increment Variable (to sum field across Entity A)

- Create a new record (in Entity B consisting of the sum of the field value across all Entity A records.)

 

Just what I wanted!   

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,805)