Adding options to a blank optionset with powerautomate

(0) Share

Report

Posted on by ghost6000

Hey everyone,

I am looking for a way to add options to a blank optionset within powerautomate.

My goal is to be able to work with these added values in powerapps.

I am getting the data from a http request out of Business Central.

Flow updates perfectly all wanted fields in my entity except I dont know how to add an option from the http output to a optionset.

Thank you very much upfront for your help! 🙂

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ghost6000,
By "adding an option", do you mean a new item in your optionset available values (metadata) or updating an entity field of datatype optionset? If updating an entity, Power Automate using the CDS Web API for its transactions, and so you need to assign the int value of the optionset item to update or set null to associate a blank value.
Hope this helps

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @ghost6000 ,

Could you please share a bit more about your scenario?

Do you want to add a option from a HTTP Response to the Option Set Type of your CDS Entity?

Actually, the Option Set type field is essentially a Object type in CDS Entity, it contains Label and Value attribute. The Label attribute is used to store the Text value, e.g. "Pending". The Value attribute is used to store the Integer value, e.g.

886370001. The screenshot as below:

Actually, when you selected an option (Label value) for the Option Set field within your Power Automate flow, it uses the Integer value to store the Option Set field:

So if you want to type a custom value within the Option Set field of the "Create a new record" action, you should type integer value (e.g. 886370001) rather than Label value.
In addition, the option you want to set to the Option Set field must be existed as available options of this Option Set field already, you could not assign a custom option to this option set field.

Actually, when you create new Option Set in your CDS Entity, you could custom Integer value for each option as below:

After that, you could assign different integer value to this Option Set field based on the retrieved option from your HTTP Output.

Within the Option Set field, type the following sample formula:

if( equals(body('HTTP')?['option'], 'Option1'), 1, if( equals(body('HTTP')?['option'], 'Option2'), 2, 3 )

Best regards,

Was this reply helpful? Yes No
ghost6000 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your help so far guys! I will specify a Little more what I am trying to do and will come back to this Post later.

Was this reply helpful? Yes No