Answered

Trigger a flow based on a number being entered into a text field

(0) Share

Report

Posted on by linky_07

Hi,

I am hoping someone can help, I am trying to trigger a flow off the back of a sharepoint list, the field is a single line of text that contains a message: ''To be completed by ASM (Supply) on creation of G-Type order'' At a certain point in the process this then gets populated with a number 9900000000 (different number each time but always starts 990).

I am trying to set up a flow that states when the field G-Type Order Number begins 990 then update the status on the list and send an email (Or something to that effect), however, everytime I try to do this it doesn't work!!! losing the will to live!!! thanks in advance.......

Categories:

Using connectors

I have the same question (0)

All responses (7)

Answers (1)

v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @linky_07,

Would you please share the details of your flow configuration?

In addition, what the meaning of "At a certain point in the process this then gets populated with a number 9900000000"?

Besides, would it be available to share the scenario the flow working for, which field ( G-Type Order Number, or the single line of text ) as trigger, and which is the result?

I suspect the issue here should be the condition you configured.

Add a condition to a flow

Regards,

Michael

Was this reply helpful? Yes No
linky_07 44 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
linky_07 44 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @linky_07,

Please change the value part of your condition with the following:

'990'

Add single quotes with the 990. This way would make the 990 in string format, and without quotes, it will be detected as number.

let me know if it would work.

Regards

Michael

Was this reply helpful? Yes No
linky_07 44 on at

Like (0)

Report
Copy link

Link copied!

Hi Michael,

I've tried this but still not working, to be fair I've triend almost every combination under the sun!! Just trying something else now and will advise if it works!

Thanks for your help

Becky

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @linky_07,

Becky, is the Status column under your SharePoint list a Choice type? Sorry for missing this part with my previous reply.

If it is, then I am afraid currently it is not available to update its value through Microsoft Flow.

See the thread for reference:

Choice Fields not showing as an option in Flow

Currenlty the Choice field is readonly.

Would it be available to add another text column in SharePoint list, to add notes for the status need to changed?

If only for sending Email Action, it should work.

In addition, no need to add the single quotes with 990 (my bad), your configuration should work.

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

linky_07 44 on at

Like (1)

Report
Copy link

Link copied!

Hi,

No it's not and I've been sucessfully been updating it for other parts of the process...

This however has worked which was to enter a space into the contains condition, as there were spaces in my text and none in the number format, I've got round it like that.....

Was this reply helpful? Yes No