Answered

Update Specific field in a SP list

(0) Share

Report

Posted on by joeuser1

Hello! I am going a bit nuts trying to figure this out...

What I'm trying to do... When a new response is submitted from a webform where clearance name in the webform is equal to title in the SharePoint list, update the SharePoint row that has the same clearance/title and update the fields Curricula/training (text field), primary owner (person field), alternate owner (person field, could be null, or could have more than one) last modified by person field, and last modified date. On success send an email to the Primary and alternate people

The outcome I'm getting, is it will update all of the list to those values entered from the webform. If there is no alternat, or more than one is entered.... it just fails.

One problem I have is the ID... not sure the best way around this...

Flow.png

logic.png

I have the same question (0)

All responses (10)

Answers (1)

v-jefferni on at

Like (0)

Report

Re: Update Specific field in a SP list

Hi @joeuser1 ,

I don't think the false branch is needed. In get items action, use the filter query to get items that title is equal to clearance name. Then condition control is not needed as well. Just apply to each and update item.

For the alternate owner column, you will need to generate an array variable to include all claims. Since I'm not aware how would users enter alternate owners in the form, I'm not able provide a detailed solution for you. You can refer to below blog to know how to generate the array:

Power Automate: Populate SPO User Claims (multiple claims) | console.log('Charles'); (charleslakes.com)

To use the array for the alternate owner column of Update item action, you will also need an expression, checking if the array is empty otherwise the flow will fail due to empty input error:

switch to input array first.

use if function.

Best regards,

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report

Re: Update Specific field in a SP list

Thanks for the response.
In the form for the alternate, they would be filling out a webform with the email of the person separated by a ;
I think I'm getting closer, but now I need to figure out how more than one email can be added to the person field, or a null.

I'm able to split my select, but not sure how hot to get it to enter on the SP list.
My split: split(outputs('Compose_2'),';')
My If: if(equals(item()?['Compose_2'], ''),null, item()?['Output'])

Thanks again.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Re: Update Specific field in a SP list

Hi @joeuser1 ,

OK, so all the alternate owner emails would be in one answer. Then please move your Compose2 and Select above the Apply to each control, the variable is not needed anymore, drag Update item into Apply to each control. if expression:

if(empty(body('Select')), null, body('Select'))

Best regards,

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report
Re: Update Specific field in a SP list

Looks like I'm doing something wrong..
I've tried a few variations of the of the split in the select statement, but still not getting it..

split(outputs('Compose_2')?['Alternate Owner(s) Email?'], ';')
InvalidTemplate. Unable to process template language expressions in action 'Select' inputs at line '0' and column '0': 'The template language expression 'split(outputs('Compose_2')?['Alternate Owner(s) Email?'], ';')' cannot be evaluated because property 'Alternate Owner(s) Email?' cannot be selected. Property selection is not supported on values of type 'String'. Please see https://aka.ms/logicexpressions for usage details.'

I placed this:
if(empty(body('Select')), null, body('Select'))
in the Alternate owner field in the Update Item

Or the one in the screen capture

________________________________________________________________
Thanks for your help on this!!! I really appreciate it.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Re: Update Specific field in a SP list

Hi @joeuser1 ,

Just no need to use Compose, use the answer from Get response details in split function directly and set the expression in Select action.

split(outputs('Get_response_details')?['body/question'],';')

Or if you really need the Compose to check some result in run history:

split:

split(outputs('Compose_2'),';')

If:

if(empty(body('Select')), null, body('Select'))

Best regards,

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report

Re: Update Specific field in a SP list

Still having issues...
I changed the split in "select" to split(outputs('Get_response_details')?['body/question'],';')
but I get the error
Unable to process template language expressions in action 'Select' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#split for usage details.'.

So far no matter what I try it stops at the Select.
Any ideas what I could be doing wrong?
Thank you for taking time to help me!

I think part of my problem might be because I'm trying to update an item vs create an item. The problem with update an item, it wants an ID, so the select cannot find the id in the update item..?

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report

Re: Update Specific field in a SP list

Okay, I think I'm very close! I can add a single, or multiple to the Alternate field, but if its null it fails.
Here is what I have.
Split in the Apply to each 2: split(outputs('Compose'),';')

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Re: Update Specific field in a SP list

Hi @joeuser1 ,

split in "select": split(outputs('Get_response_details')?['body/question'],';')

The bold part is actually what you have put in Compose, I don't know what's the question so I typed common syntax.

What you have done is correct as well. Have you tested your flow? Will it work?

Best regards,

Was this reply helpful? Yes No
joeuser1 60 on at

Like (0)

Report

Re: Update Specific field in a SP list

No it fails. I did come up with something that works but fails on nulls.
This is the process I used to get it to work for the most part:
Solved: Re: Updating SharePoint-Field (Type Person or Grou... - Power Platform Community (microsoft.com)

I also tried a condition, but no matter what I enter for data in the webform (one alternat, 2, null) it always thinks the condition is "If no". So long story short, if the submitted webform has a value in alternat it works. If there is no value it fails. whether or not there is data in the webform submission in the alternate field, power automate always goes to the "If No" side of the condition.
I have tried multiple variations on the condition. One variation will always provide "If Yes" and another variation will always fall on "if no"
I'm so close....
Any other ideas?

Was this reply helpful? Yes No
Verified answer

joeuser1 60 on at

Like (1)

Report

Re: Update Specific field in a SP list

@v-jefferni I figured it out!
Split in apply to each 2:
split(outputs('Compose'),';')

Was this reply helpful? Yes No