Consolidate - Column Consult on email

Like (0) Share

Report

Posted on 24 Mar 2020 18:11:05 by gha085

Hello everyone.

I have an issue that I'm not able to solve.

I have two lists: one form to be filled by the creator and other one with a list of departments (not to be edited).

The form to be filled consumes information from the other list, Departments, where I can select one or many.

I'm starting an approval on SharePoint and in the e-mail received for approve the solicitation, the field Department (consult) doesn't return it consolidate. I tried to string it, but it delivers the information like this:

[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"102 - Advocacy"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"104 - Comunicação"},{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"130 - Comunicação ADM"}]

Could you please help me? How can it be shown the consolidated information?

Thanks,

Will

All responses (4)

Answers (1)

Verified answer

v-bacao-msft on 25 Mar 2020 at 06:36:40

Like (0)

Report
Re: Consolidate - Column Consult on email

Hi @gha085 ,

Please try to refer to the following method to get the lookup column value.

Initialize a string variable to store the value of the lookup column.

Append the Department value to string variable and end with a ";".

Hope this helps.

Best Regards,
gha085 4 on 24 Mar 2020 at 18:41:40

Like (0)

Report

Re: Consolidate - Column Consult on email

The language is portuguese.

Column consult - form filled by solicitantdesign overviewdesign -email
efialttes 14,756 on 24 Mar 2020 at 18:28:53

Like (0)

Report

Re: Consolidate - Column Consult on email

Hi!

Can you share a screenshot from your flow design, and also from your Sharepoint list column definition?

Thanx!
gha085 4 on 24 Mar 2020 at 18:15:12

Like (0)

Report

Re: Consolidate - Column Consult on email

Forgot to mention that if I select on the dynamic content the field Department, it automatically creates the box: Apply to each, sending the approver one e-mail per department. This is not ok, because these information should be only in one e-mail, not many.