Issue in adding fields from sharepoint and Microsoft forms

(0) Share

Report

Posted on by Rai Onkar

Hello there,

I am trying to create a flow where after approvals I need to update an item in a sharepoint list.

In that update, I have to update a coloumn which requires me to add a existing coloumn entry and another response from microsoft forms.

I can see the field untill I use expression and formula to add.

Here are the snapshots.

Snip 1.JPG

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-xida-msft on at

Like (0)

Report
Re: Issue in adding fields from sharepoint and Microsoft forms

Hi @raionkar,

Could you please share a full screenshot of your flow's configuration?

Do you want to reference the Dynamic contents of the "Get items" action within the expression formula?

I have made a test on my side and please take a try with the following workaround:

Within Description field of the "Update item" action, type the following formula:

concat(item()?['Executor'],' Submitted ',body('Get_response_details')?['r88c746804d434ddd8e4420f6d92ef5d5'])

Note: Use the item()?['ColumnNameOfSharePointList'] expression to reference the Dynamic contents within your "Get items" action. The Executor within my above formula is a column in my SharePoint list. The body('Get_response_details')?['r88c746804d434ddd8e4420f6d92ef5d5'] expression represents the Answer Dynamic content of the "Get response details" action, in order to include dynamic content from the "Get response details" action within your expression formula, you could select the Dynamic content tab and simply click the field you want to use.

On your side, please consider take a try to use the following formula to reference the Dynamic contents of the "Get items" action:

item()?['ColumnNameOfYourSharePointList']

Or

items('Apply_to_each_2')?['ColumnNameOfYourSharePointList']

Note: The "Apply_to_each_2" represents the name of the "Apply to each" action which includes the "Update item" action within my flow.

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

More details about the item() expression in Microsoft Flow, please check the following article:

item() function

Best regards,

Kris

Was this reply helpful? Yes No
Rai Onkar 10 on at

Like (0)

Report

Re: Issue in adding fields from sharepoint and Microsoft forms

Hi @v-xida-msft,
I did try items() on my first attempt but was not successfull.
I tried item() as suggested by you. I got the following error:
Here are the snapshots of my flow:

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Re: Issue in adding fields from sharepoint and Microsoft forms

Hi @raionkar,

Do you want to concatenate the Dynamic content from the "Get items" action and the response from the "Get response details" action using expression within your flow?

The error message told that there is something wrong with the Parameters that you provided within the and() function. The parameters of the and function are required to fill a Boolean value, but you provided a String value.

If you want to concatenate the Dynamic content from the "Get items" action and the response from the "Get response details" action, please consider take a try to change the and() function into the concat() function that I provided above. I have made a test on my side and please take a try with the following workaround:

concat(item()?['Executor'],' Submitted ',body('Get_response_details')?['r88c746804d434ddd8e4420f6d92ef5d5'])

More details about the and() function, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language#logical-functions

Best regards,

Kris

Was this reply helpful? Yes No
Rai Onkar 10 on at

Like (0)

Report

Re: Issue in adding fields from sharepoint and Microsoft forms

Hello Kris,
Thanks for your response. My bad, I wrote down and instead of add.
Actually , I want to add the two numbers.One is from get items and other is from get response details.
So, the formula is add(item()?[sharepoint_column],body('Get_response_details')?['r......']).
It some how doesnt recognise it and considers it as a null value.

Thanks.

Was this reply helpful? Yes No
Rai Onkar 10 on at

Like (0)

Report

Re: Issue in adding fields from sharepoint and Microsoft forms

Hi @v-xida-msft,
I was using a wrong coloumn name.
It solved the issue.
Thanks for all your help.

Was this reply helpful? Yes No