Creating Null values in a SharePoint list from A MS Forms submission

(0) Share

Report

Posted on by Chris1968

1,122

Hi,

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

if(empty(outputs('Get_user_profile_(V2)')?['body/displayName']),null, outputs('Get_user_profile_(V2)')?['body/displayName'])

This is my Flow

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

Regards

Chris

Categories:

Business Process Flows

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

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.

Solved: Set SharePoint Person Field to Null in Power Automate

----------------------------------------------------------------------------------
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? Yes No