Answered

SharePoint list submission notification flow - cant add fields with multiple values

(0) Share

Report

Posted on by Roberts2727

193

Previously when creating a notification workflow for a list I have in SharePoint I could add fields with multiple values with no issues.

I was trying to edit the flow today and now every time I add a field with multiple values it throws the flow off, inserting a for each loop that should not be there.

Please let me know what you need from me to help resolve the issue.

Categories:

General topics

I have the same question (0)

All responses (22)

Answers (1)

Sort by

Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

@ManasMSFT

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Roberts2727,

Do you want to add multiple values into a field of SharePoint list with Microsoft Flow?

Adding multiple values is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please vote the following idea:

https://powerusers.microsoft.com/t5/Flow-Ideas/Person-or-Group-field-in-item-should-support-multiple-values/idi-p/23778

Best regards,

Kris

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

No, Sorry I guess I was not clear enough that is not the issue at all.

I am using a notification flow, send an email when a new item is added to a sharepoint list.

I cannot insert dynamic content which contains values into the notfication flow. Every time I try to it creates a for each loop. This was working previosly.
Before:

After:

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Looks like the flow started failing also on the 28th with the following error.

Unable to process template language expressions in action 'Send_an_email_from_a_shared_mailbox' inputs at line '1' and column '2163': 'The template language expression 'triggerBody()?['Format']?['Value']' cannot be evaluated because property 'Value' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

It worked for months before with items with values.

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Any Ideas @v-xida-msft?

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Roberts2727,

Which data type is the Format column of your SharePoint list?

Could you please expand "When an item is created" trigger and Share more details about result that the trigger returned (especially the result that Format column returned)?

The error message told that the property 'Value' cannot be selected within Format column.

Please check if the result that Format column returned within the results "When an item is created" trigger returned contains property 'Value'.

Best regards,

Kris

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Are you available to help with this now? The issue still is not resolved. I do not need help on the failed flow. I need help building the flow to email the value. I can share my screen with you for support and show you the exact issue. If I should file a ticket wtih office 365 please let me know that.

Data type of choice is the value being returned

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Roberts2727,

Please check if you have enabled Format column which is a Choice type allow multiple selections in your SharePoint list:

Multiple values of Choice type column are not supported in Microsoft Flow currently, please change Checkboxes (allow multiple selections) into Drop-Down Menu or Radio Buttons and check if the issue is solved.

I have made a test on my side and the flow works well. My flow's configuration as below:

The flow works successfully as below:

Best regards,

Kris

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, my choice type does allow multiple values. Screenshot below. I can not change it to radio/dropdown. It is mandatory for this list to allow multiple values. I guess I will just have to go back to using SharePoint Designer workflow. 😞

Bad thing is the flow was working successfully with multiple choice values before.

Was this reply helpful? Yes No
Roberts2727 193 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft
Just want you to know I have an open ticket with Flow Support and they agree this functionality should not have been removed.

Was this reply helpful? Yes No