Answered

SharePoint Option Set Item to CDS Option Set Field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am trying to build a Flow taking a SharePoint item that has an Option set in it to and duplicating it in CDS/Dynamics 365.

In SharePoint I have an Item with a list of Locations where multiple locations can be chosen. The SharePoint site is going to be used for our internal employees to be able to look at and make changes to the event/item in SharePoint, then it gets updated in CDS.

I need it in CDS because we are building a PowerApp and using CDS as the data source because there will be items related to the event in SharePoint that not everyone needs to see.

I have the CDS field setup exactly the same as the one is SharePoint.

Any help would be great.

Thanks

Aaron

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to set up a Power Automate flow to achieve your needs?

Do you want to update the corresponding CDS Entity record based on the change of List Item in SP List?

Based on the scenario that you mentioned, I assume that there is no a Choice type column in your SP List, and there is a Option Set type column in your CDS Entity. The Choice type column and the Option Set type column have same available options, right?

If the Option Set column in your CDS Entity is a "Multi Select Option Set" type column, I afraid that Power Automate flow could not achieve your needs. Currently, within Power Automate flow, we could not update a "Multi Select Option Set" type field within "Update a record" action of CDS connector.

If the Choice type in your SP List is a Multiple Selections Choice column, and you want to save these selected options back to the Option Set type column in your CDS Entity, I afraid that Power Automate flow could also not achieve your needs. In addition, when providing a value for Option Set field in "Update a record" action, you need to provide a integer value rather than a Text value:

According to your scenario, I think Power Automate flow could not achieve your needs.

Best regards,
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Thanks

Yes I am trying to take from SP to CDS via PowerAutomate. I have a multi option in both locations. So in SP there are Locations 1 thru 20 and the same in CDS.

Could I take the list from SP and convert it to straight text? So if I select Location 1, Location 3, and Location 6 in SP it shows up as text in CDS?

Thanks

Aaron
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Do you want to convert the selected options into single one text string from your SP List, and then save it back to your CDS Entity Text type column?

If you want to convert the selected options into single one text string from your SP List, and then save it back to your CDS Entity Text type column, I think Power Automate flow could achieve your needs.

Firstly, you need to add a Text type column in your CDS Entity to store the multiple options concatenated string value. Then you could configure your flow as below:

Please take a try with above solution, check if the issue is solved.

Best regards,