web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : +OhOglnHKkojtpE6zLdR3a
Power Automate - Building Flows
Answered

strange issue with substring function - need help please

Like (0) ShareShare
ReportReport
Posted on 4 Apr 2023 14:30:33 by 14

Hi there

 

I encounter a strange issue with my cloud workflow. Basically it does the following:

 

- extract information from a PDF with AI-builder (in this case an amount in EUR) e.g 132.78 EUR

- find the text position EUR

- use substring function with starting index 0 to return only the numeric value e.g 132.78

- write the value e.g 132.78 into an excel-file

4.png

the flow worked fine for a couple of weeks and suddenly I get the following error:
1.png

2.png

3.png

 

I dont understand where the issue is coming from, the starting position is 0 AND despite of the error, the value is still being written into my Excel-file which shows that it still works somehow.

5.png

 

how could I fix the issue? is there another way to extract just the numeric value without the subsequent characters, e.g EUR ?

 

all the best

 

Andrew

 

 

 

all the best

 

Andrew

I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,029 Super User 2025 Season 2 on 04 Apr 2023 at 14:42:20
    Re: strange issue with substring function - need help please

    Hi @andreasgraf 

     

    I could see the error part is having text value as empty while finding text position

     

    Nived_Nambiar_0-1680619304457.png

     

     

    May be the value entered in excel would be the next iteration ?

     

    could you check the loop iterations?

     

    To resolve this error, may be you can use the condition after find text position with condition as text position output is not equals -1

     

  • andreasgraf Profile Picture
    14 on 12 Apr 2023 at 09:49:18
    Re: strange issue with substring function - need help please

    many thanks! that did the trick, you made my day 😉

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 666 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 382 Moderator

#3
developerAJ Profile Picture

developerAJ 254

Last 30 days Overall leaderboard