I'm looking at creating a 'null' / empty value in a SharePoint list if a question in an MS Form is either Blank or the name entered does not match a name in our company
I have this as the function I have in Create Item - Results
The issue is when I test it and add a name that I know it not in the company it adds my name to the column in the SharePoint list, which is a Person or Group I am the one creating the Form so I assume it's picking my details up from Get_User_Profile.
I'm unable to change the column type as records have been created, successfully and are being used in the business...
Can anyone provide a solution as at the moment, if a wrong name is entered the Flow fails
Creating Null values in a SharePoint list from A MS Forms submission
To set a Person or Group field to null requires the use of an HTTP rest call. It can't be done with a Create Item action. Here's a walkthorugh that shows the code required.
----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!
Paul Papanek Stork, MVP Blog: https://www.dontpapanic.com/blog
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.
1,144
Share
Report
All responses (
Answers (
