cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
linky_07
Helper I
Helper I

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

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.......

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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.....Flow.jpg

View solution in original post

7 REPLIES 7
v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

List  .jpg

Update.jpgStatus Update.jpg

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

 

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.....Flow.jpg

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,477)