Power Automate for MS Forms to SharePoint List

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I am using a Microsoft Form, for getting feedback from multiple stakeholders.

I used Power Automate to save the Form details to the SharePoint list.

The issue is, if the current user keeps the value blank for a particular field and submit the form, on SharePoint list it becomes blank, however I want the value submitted by the previous user saved on the SharePoint list intact.

And if the current user modifies the current value, it should get updated on the SharePoint list.

How should I build a power automate flow for this scenario?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

hthpowerapper 364 Super User 2024 Season 1 on at

Like (0)

Report
I believe this can be achieved by checking the input and then using a condition to update the value or not.. Something Like..

Trigger:

Trigger: "When a new response is submitted" (Microsoft Forms).

Actions:

"Get response details" (Microsoft Forms) – to get the details of the submitted form.

"Get item" (SharePoint) – to retrieve the existing SharePoint list item.

Condition:

Add a condition to check if the field in the form response is blank. For example, use an expression like empty(triggerOutputs()?['Your Value']) to check if a field is empty.

Yes branch (if the field is blank):

Do nothing (keep the existing SharePoint list item values).

No branch (if the field has a value):

"Update item" (SharePoint) – to update the SharePoint list item with the new values from the form response.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks for the suggestion.
I have used the empty expression as per your suggestion.
Still not able to retain the previous value using Update item.

Thanks
Varsha

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

As per your suggestion I have made changes to my flow.
Now the issue is,
For the first time when I submit both the value for PM Name and PM email, it comes properly, however if 2nd time for the same Customer name if I change the PM name and keep the PM email blank, after the flow run, the PM name remains same (not getting updated) and the PM email field shows the Customer name.

Get Items:

length(outputs('Get_items')?['body/value'])

PM Name: Internal PM name is ‘field_6’
if(empty(outputs('Get_response_details')?['body/r8a05669fe13a4fc4a3f3f7cc3b69b9a5']),item()?['field_6'],outputs('Get_response_details')?['body/r8a05669fe13a4fc4a3f3f7cc3b69b9a5'])
PM email: Internal PM email is ‘field_8’
if(empty(outputs('Get_response_details')?['body/r50d6f4b60c104d3eb22ad3ce84afb33c']),item()?['field_8'],outputs('Get_response_details')?['body/r50d6f4b60c104d3eb22ad3ce84afb33c'])
For the first time when I submit both the value for PM Name and PM email, it comes properly, however if 2nd time for the same Customer name if I change the PM name and keep the PM email blank, after the flow run, the PM name remains same (not getting updated) and the PM email field shows the Customer name.

After flow run, the email field updated as Customer Name (Title)

Thanks
Varsha

Was this reply helpful? Yes No