You’re offline. This is a read only version of the page.
Hello everyone,
Im trying to add and remove a person base on the values of the Multiple line of text type column "Projects".
This is the values of my Projects column
ang this is the code im currently using
Share
Report UpdateIf(Container1, Projects="mkDad",
{Members:
Ungroup(
Table(
{Item:
Table(
{
'@odata.type': "#Microsoft​.Azure.Connectors.SharePoint.SPListExpandedUser",
Department: "",
Claims: Dropdown6.SelectedText.Value,
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
}
)
},
{Item: Members}
),
"Item"
)
}
)
);the problem is the update only works on the first value of the Projects column which is "BbSsE"
Any help would be much appreciated. Thank you
Hi @Anonymous ,
Could you please share more details about your scenario? The criteria within the UpdateIf function only represents when project is equal to mkDad. But as you mentioned that project is a multiple lines of text column, if you would like to update items that project column include "mkDad", please try below formula:
All responses (
Answers (
UpdateIf(Container1, "mkDad" in Split(
PlainText(Substitute(Substitute(Projects,"<p>","<br>"),"</p>","")),
Char(13)
),
{Members:
Ungroup(
Table(
{Item:
Table(
{
'@odata.type': "#Microsoft​.Azure.Connectors.SharePoint.SPListExpandedUser",
Department: "",
Claims: Dropdown6.SelectedText.Value,
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
}
)
},
{Item: Members}
),
"Item"
)
}
)
);
Best regards,
387
