cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dsimmons
Frequent Visitor

Interpreting a scraped table | Variable translation In/Out of Scripts

 
Ok. Here we are with this one.  I have the entire flow working as it should, all the way until the last part.  Where I take a table scraped off a website, thats imported into a new workbook sheet.  We will call this Sheet WebData.  I have PAD analyze column 3, "Responses" which contains a number.  001, 002, 004, 006, 009, 999.  001 and 002 are "Good", 004 needs to return a value of "LocCoord", 006 as "HiFacility", 009 as "Unkn", and 999 as Late.  There could possible be up to 20 of these per table. 

 

I've tried using If statements, nested IF's, Else-If, Switch functions....not wanting to play ball.  Now I'm coding it out in Java.  Have 2 scripts written that should work, but I cannot get the variables to pass Into or Out of the script.   

 

I currently have the flow set up to both store that column as a list in say %Resp_List%, and as individual variables, say %ExcelData1% thru %ExcelData20%.  

 

Stuck like chuck on this one. And I'm feeling as though it might be a limitation of the Conditionals in PAD even when combined with Logic statements as well.  

 

Any help would be lovely!

 

JS:

" // Read Resp_List from Power Automate input
var Resp_List = %Resp_List%;

// Initialize ListOutput as "Empty" by default
let ListOutput: string = "";
{

// Check if Resp_List contains a 4
if (Resp_List.includes(4)) {
  ListOutput = "LocCoord";
}
// Check if Resp_List contains a 6
else if (Resp_List.includes(6)) {
  ListOutput = "HiFacility";
}
// Check if Resp_List contains 999
else if (Resp_List.includes(999)) {
  ListOutput = "LATE";
}
// Check if all values in Resp_List are either 1 or 2
else if (Resp_List.every(val => val === 1 || val === 2)) {
  ListOutput = "Good";
}

// Output ListOutput as the final result
//ListOutput = %ListOutput%;
var ListOutput = %ListOutput%;
WScript.Echo(ListOutput);
}"

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Dsimmons 

 

I did not get the point behind why you are running the script for this,

 

Are you looking for an effiicient way of checking condition in PAD ?

 

Kindly let me know 

View solution in original post

14 REPLIES 14

Hi @Dsimmons 

 

I did not get the point behind why you are running the script for this,

 

Are you looking for an effiicient way of checking condition in PAD ?

 

Kindly let me know 

Dsimmons
Frequent Visitor

Didn't mean to close this. 

I am unable to get the proper results back into excel based on on the statements there.  If I use conditionals inside of PAD, regardless of iteration, they are not working.  Any ideas?  It doesn't have to be via script, although I will eventually writing it in pure JS. 

So column 3 responses should contain the value like 003 ,004 etc right, would it be possible to share how the value looks like to see format ?

Dsimmons
Frequent Visitor

Absolutely.  I will when I get home, the table is formatted html.  The var for the list I have not forced type on. I currently get no errors on either the PAD flow or the JS. 

Ok @Dsimmons 

 

Once i see the how value format of column3 looks i can suggest a better approach.

 

Current approach would be to use nested if , but if there are more number of validations to perform, then it won't be a good method. 

 

Let me know once you share the format 🙂

If I might be able to reach out to you via a direct message of some sort?  For table data anyway. We can pick the conversation back up here.  The data albeit in the public realm, I'd like to not post publicly if possible.  

Hi @Dsimmons 

 

You can message me privately else, if you can just show how column 3 values looks (using a sample value) that would be also fine 🙂

There just tagged as a cell in an HTML table. <td>001</td>.  It does say earlier on that

<html><head><meta http-equiv="Content-Type" content="text/html;

Ok so the value is directly 001, so why you u try with switch actions then ?

 

Nived_Nambiar_0-1682230948687.png

 

Length of time prior, I never though pf evaluating a list using switch actions.  It would have been a nightmare doing the for upwards of 20 variables in some cases.  Hang tight.  Let me try something. 

Hi @Dsimmons 

 

Also another easy would be trying using custom object creation, for this case, you can create a custom object like below

 

 

{
"001":"Good",
"002":"Good",
"004":"LocCoord",
"006":"HiFacility",
"009":"Unkn",
"999":"Late"
}

 

Now let's say you have stored this custom obj in var1 variable.

now the number 001 is stored in var2 variable

 

Now use var1[var2] to get type 

 

I hope this would be easy to design 🙂

The custom object would be inside the JS correct? Or is there a way to do that inside PAD?  Im attempting to follow, but this is my first go at PAD, let alone coding something to use inside of PAD in JS.  

Hi @Dsimmons 

 

Yes , You can try same in PAD as well like below

 

Nived_Nambiar_0-1682238065916.png

 

the custom object is created like this

Nived_Nambiar_1-1682238097122.png

 

and the value to select is stored in var2 which is 001 in the flow for demo

 

Now in display message we will display the corresponding value of key 001

Nived_Nambiar_2-1682238149964.png

 

 

Hope it helps 

 

It does, very much.  Thank you.

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Summer of Solutions | Week 3 Results | Win free tickets to the Power Platform Conference

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22  

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (4,051)