I have a SharePoint Subsite SS.1 which inherits a Lookup Site Column "Col1" from its parent site S.0.
I have a Power automate flow on a list List1 in the subsite.
If I make Col1 a mandatory field in List1, I am seeing an error in the workflow, "The required field "Col1" data type is not supported clientRequestId: <CRI> serviceRequestId: <SRI>"
It does not give the error if Col1 is made optional, or if Col1 is redefined as a Local site column in SS.1.
So I have a workaround (I made Col1 Optional in List1 temporarily), but this does not serve the Business purpose: I need Col1 to be mandatory
ADDITIONALLY, The Column Col1 is not appearing as a dynamic variable in the flow, irrespective of whether it is optional or Mandatory
I suspect with an inherited lookup column, there is probably some metadata complexity that isn't handled by the connector which explains this issue, and the additional issue you see with Col1 not appearing as a dynamic variable in the flow.
I see you've reported this as a bug in the ideas forum. If nothing happens, you might also consider raising this directly as a support issue with Microsoft to see what they say about this.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
31
Share
Report
All responses (
Answers (
