Share via

Power Automate for Desktop - Two Position Variables to subtract from multiple values

Anonymous
2024-06-30T15:11:19+00:00

I am extracting data from a PDF. I have two variables. One gives me the position of all the occurrences of the string "Business Purpose," and another gives me the position of all occurrences of "Description." I would like to have the first value in the Business Purpose" variable be subtracted from the first value in the "Description" variable. This is relatively easy in the cloud version, but I'm having difficulty determining which value in the variable to use in the Desktop version. I would also like to use a variable to determine that value. For example:

Count all values in the variable "Business Description". This would be the starting "counter." Then, each time it is read, the counter goes down until it is below 0.

Sample

BusinessPurpose[0]

BusinessPurpose[1]

etc.

In layman's terms, here is what I'm trying to do:

For each value in "Business Position"

Increase variable Counter by 1

End

For each Counter

Business Purpose[Counter]-Description[Counter]

(the rest of the process would go here, but I only need to know the syntax for the variable with the counter.

End

I've attached an image of the arrays I have set up.

Microsoft 365 and Office | Microsoft Forms | For business

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-01T02:07:53+00:00

    Dear and respected,

    Good morning!!

    Based on the description, we understand that you're building a Power Automate flow.

    While we want to support more on the flow building to resolve your concern but since it's related to the Power Automate flow and the community moderators here focus on out-of-the-box features in Office apps and SharePoint, so we have limited support experience customizing the Power Automatic flow, I suggest you post your concern in the related Microsoft Power Automate Community - Power Platform Community to get the dedicated and professional support from flow experts and engineers there.

    Apologies for redirecting you to a different community as category members have limited knowledge about flow building, to get the best and fastest assistance, we redirect you the right way.

    Meanwhile, we will keep your thread open and welcome other community members or MVPs who have suggestions about the flow you are trying to build and share their ideas.

    I appreciate your time and effort on checking these above and thank you for your time and cooperation. I hope that you are keeping safe and well!    Sincerely,Mia | Microsoft Community Moderator

    Was this answer helpful?

    0 comments