Creating a row from a row in a separate entity with lookup fields and option sets (Power Apps Flow and CDS)

[PAB1]

Hi 

I am trying to write a Flow that will create a series of child records from a template entity when the parent record has been created. My Flow is a standard pattern:

• When a record is created..
• Get a record (get the record created above – not sure if this is needed – but this was shown in the many posts I have looked at)
• List Records (these are the template records) 
• Apply to Each
• Create a new record

The issue I have are:

1. The template record includes a field with an Option Set - which is replicated on the target table - the Create record provides the associated drop down list to select the required option - but I want to drive the value from the template record (in the list) and not hard code it in the “Create Record” applet 
2. The created record needs to be linked to the parent record using the key from the header record (which triggered the flow) – while I can see the “guid” (I also performed an export to excel from Dynamics to verify I had the correct one)  for this record I constantly get -  “Resource not found for the segment” – I have reviewed various posts on the net and none of these seem to work. i.e. TableName(Key Value), /TableName(Key Value)

My entity name is

I have tried

• 
• I have also tried the above without the “/”
• I have also tried the above in the singular with and without the “/”
• and for completeness I have tried pab_assessmentheader 

Each time I get (or similar)

{

  "error": {

    "code": "0x0",

    "message": "Resource not found for the segment 'Assessment Headers'."

  }

}

Without the Entity name ( i.e. the Assessment Number) I get

{

  "error": {

    "code": "0x0",

    "message": "Resource not found for the segment '0dd15e08-6117-eb11-a813-000d3ad7eea3'." - Which is the correct GUID for the item

  }

}

Either what I am trying to do - can't be done (which I hope isn't the case) or I have missed something that is glaringly obvious.

Many thanks

Tony

[summitb]

Have you tried /Prefix_SchemaName/{Guid}

[HSheild · Accepted solution]

Hi @PAB1 

1. You are able to set an Option Set value to a dynamic value.  So just populate this with the value from template entity

2. For the lookup you need to use pab_assessmentheaders(GUID).

[PAB1]

I have tried this and it works without the leading "/" - I thought I had previously tried this option .

Thank you for the advice

[PAB1]

I am still struggling with the "Option Set" issue - I have tried using the value this does not seem to be carried forward into the  - but I will continue to look at it

Thank you for the advice

[PAB1]

Oops! It would helped if I had checked the contents of the template entity - all issues now resolved

Thanks for the help

Tony

[summitb]

You can put custom values in optionset fields like 10000, 10001 etc.