Pull in All OptionSet Values for comparison

[Reigningfear]

Hello,

I have been searching far and wide for a solution but have come up empty handed. I have a flow which copies data from a SharePoint List to a CDS Entity. One of the fields that will be updated in CDS is an option set. Within flow however, I am working with the SharePoint Text field, which is the equivalent to the option set label. I am familiar with how to obtain labels if CDS were my data source but that doesn't work for me here.

I was hoping to find an option where I essentially look up the OptionSet Record in the OptionSet Entity and then find the corresponding Value to use in updating the CDS record. Is this possible? Or is it possible to update an option set field with a label instead of the numeric value?

Thank you for your time.

[v-alzhan-msft]

Hi @Reigningfear ,

We could only update the OptionSet column by choose from the drop down list of the column.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Reigningfear]

Thank you for your reply. I have been able to pass the numeric value (6000001 for example) to an Option Set column through the 'Update a Record' action. My trouble is, I am working with labels only since it is coming from SharePoint. I have 30+ options that could be selected and they may change as well which will make for a really tedious if expression.

Is there any way to pull in entire option sets into flow or update a record only using the label? 

[v-alzhan-msft · Accepted solution]

Hi @Reigningfear ,

I'm afraid that no any supported function could do that.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Reigningfear]

Hello,

For anyone who may run into this, I used a simple workaround using Excel. I created an excel file source stored in SP with the option set value and label. I then added an excel online connector and basically did a lookup to find the proper value to update the CDS record. It's not elegant but it works. I hope there is a way to query option sets in the future. 

[sastrakhan]

There is a way!  In your Flow you can call the String Maps table to get the option set values like in this video:
https://youtu.be/oL_4I30alEo