Take input from Ms Form and check the sharepoint list, trigger the action based on true/false value

(0) Share

Report

Posted on by NavNZ

Hi Gurus,

I am new to Power Automate, I am trying to configure automation .

Scenario is : User submit a MS form with some details which also contain domain name

The automation first check the domain name in Sharepoint list ( the list is populated with domain names in particular column)

If the domain name submitted in MS form is already present , condition is TRUE and the flow trrigger the true action and if the

domain name is not present , the trigger perform the action under the FALSE condtion

I have used "apply to each" and it is triggering action for all False conditions ( numbers of domain not matched)

How can I make sure the action is done once for TURE and once only for FALSE ( though I have got 100 of unmatched entries in sharepoint list column)

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

David_MA 13,429 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
I am not really sure what you are talking about, but there is only one trigger for MS Forms, which is when a form is submitted. Because of this, your workflow will only trigger once each time someone submits the form.

You will follow the trigger condition with the Get response details action, which will return the answers from the submitted form. You can then use the value from the question in your form to use as a query filter in a Get items action for the SharePoint list that contains your domain names. This is how you add a filter query:

You can then use a condition to see if results were returned from the Get items action by using a length expression. If the result is greater than zero, that means the domain exists in the list. If zero is returned, then it is not in the list. This is an example of the length expression for Get items:

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

Your workflow will look something like:

Was this reply helpful? Yes No
NavNZ 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @David_MA , these is more explaination in attached photo

Problem statement: when item is not found in the list (42 out of 43 times in existing list) the NO condition runs the flow 42 times ..

I want to check if condtion is met
( if Yes) :- (item found in sharepoint list .----> run flow one time (under Yes) ---> dont take any action on (If no)
(if No :- ( item not found in sharepoint list ----> run flow one time (under No)--> dont take any action on (If yes)

This is how the flow is configured

Was this reply helpful? Yes No