cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gaëlle
Level 8

Updating a SP2013 On-Premise Choice Column

Hello fellow Flow builders and users !

 

I have quite a big issue with my Flow.

Here is how I built it :

When a Case is create or modified in SharePoint (I insist, it is a Sharepoint 2013 OnPremise, maybe that IS the root of my problem),

I fetch the related Solutions, by filtering on the CaseNumber.

If all the Solutions are closed, then I update the Case'status to "Closed".

The Case_Status is a SharePoint column with "Closed" and "Open" as choices.

 

Here is what I tried :

 

  1. On the Update an Item panel,

    I have set Case_Status to simple "Closed". => When tested, my output is "Closed". But after a check on my SP2013 On-Prem, the Case's status is still "Open".

  2. I tried the following (after checking what sort of datas was going out of FLow):
    {
      "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      "Id": 0,
      "Value": "Clos"
    }
    But the Flow Checker gave me an error:
    The template validation failed: 'The template action 'Update_item' at line '1' and column '3111' is not valid: "Unable to parse template language expression 'odata.type': expected token 'LeftParenthesis' and actual 'Dot'.".'.
  3. I tried to just put "Case_Status Value" from the dynamic content panel, but of course it gave me the "Open" one.

I don't know what to do to make it accept my update.

Could someone explain where i did something wrong please? Is it because of SP2013 ?

 

Thank you and have a nice day.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
DanShun
Level: Powered On

Re: Updating a SP2013 On-Premise Choice Column

For anyone else trying to figure this out, you just need to have the "@" sign escaped, which is just "@@", so it should look something like:

{
  "@@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
  "Id": 0,
  "Value": "Closed"
}

 

That was able to update it. I haven't checked if you need both the ID and Value, but I'm assuming you do.

 

For the fields I'll be updating a lot, instead of creating separate variables for all, I just used "Parse JSON". It's nicer since you just need the one activity and you can still reference the individual values:

@{body('FormStatus')?['LegalReview']}

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Updating a SP2013 On-Premise Choice Column

Hi @Gaëlle,

 

Soory for I don't have an On-Premise sharepoint so I couldn't make a test on it on my side.

Have you make a test on it on sharepoint online, does it works on sharepoint online?

 

Best regards,

Alice

Highlighted
DanShun
Level: Powered On

Re: Updating a SP2013 On-Premise Choice Column

For anyone else trying to figure this out, you just need to have the "@" sign escaped, which is just "@@", so it should look something like:

{
  "@@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
  "Id": 0,
  "Value": "Closed"
}

 

That was able to update it. I haven't checked if you need both the ID and Value, but I'm assuming you do.

 

For the fields I'll be updating a lot, instead of creating separate variables for all, I just used "Parse JSON". It's nicer since you just need the one activity and you can still reference the individual values:

@{body('FormStatus')?['LegalReview']}

View solution in original post

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,638)