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
Super User II
Super User II

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.

View solution in original post

@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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (31,506)