Hi all,
I've run into a problem with lookup fields in CDS and Flow. I'm trying to create a Flow which pseudo clones an existing case when they trigger a button on the form. It will then take a few fields on the existing case and create a whole new case and then roll up the existing case to the new case via the out of the box Parent Case field.
The problem I'm having is that I have a custom lookup field on case called "Account" which looks up the account entity. I've then used the Common Data Service (current environment) create record step to create a duplicate of the case.
Now with the current environment steps. To set a lookup field for account as an example I have to set it like so:
/accounts(<account id>). This works fine but the account field is not mandatory and hence can be blank but I have to set the field value in case it has value. The problem is that if I trigger the Flow without a value in the account field. The Flow will attempt to clone the existing case and pass a blank lookup value to the field:
/accounts()
Is there a way to still have a dynamic value set for the account lookup field but if the existing case does not have a value for it, then to just set the field to null instead of failing the entire flow?
Hey @Mick282
One way I see of doing this is using the coalesce function so you can do something like this:
Add a compose action and save the accound field over there (i am assuming this would be a guid) and now in the action (the screenshot that you have shared), remove everything from that area and then use the expression
You can use the CDS "Unrelate Record" action as a workaround while MS fix the possibility to set a null value.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
29 | |
27 | |
23 | |
17 | |
10 |
User | Count |
---|---|
65 | |
56 | |
29 | |
27 | |
25 |