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

Inserting Date column for data retrieved from Web UI

Hi Community,

 

I have a new problem for you.

 

I have created a Web UI flow to change data on a webpage and generate table. I wish to input data entries from a Excel table located in local drive. Then copy the data generated on webpage to a new local Excel file. The twist here is that data extracted on webpage does not contain the Date Column and that's very much required. Hence, The output excel table to contain a new date column at left end, which contains date that is same as we used for extracting the data.

 

Here is the website link:

https://reports.dbtfert.nic.in/mfmsReports/GenWsSaleDashboardListing

 

Here is the Table to be used as input data

 

StateDistrictDate FromDate To
PunjabAmritsar01-Jan-1901-Jan-19
PunjabAmritsar01-Jan-1901-Jan-19
PunjabAmritsar02-Jan-1902-Jan-19
PunjabAmritsar03-Jan-1903-Jan-19
PunjabAmritsar04-Jan-1904-Jan-19
PunjabAmritsar05-Jan-1905-Jan-19
PunjabAmritsar06-Jan-1906-Jan-19
PunjabAmritsar07-Jan-1907-Jan-19
PunjabAmritsar08-Jan-1908-Jan-19
PunjabAmritsar09-Jan-1909-Jan-19
PunjabAmritsar10-Jan-1910-Jan-19
PunjabBarnala01-Jan-1901-Jan-19
PunjabBarnala01-Jan-1901-Jan-19
PunjabBarnala02-Jan-1902-Jan-19
PunjabBarnala03-Jan-1903-Jan-19
PunjabBarnala04-Jan-1904-Jan-19
PunjabBarnala05-Jan-1905-Jan-19
PunjabBarnala06-Jan-1906-Jan-19
PunjabBarnala07-Jan-1907-Jan-19
PunjabBarnala08-Jan-1908-Jan-19
PunjabBarnala09-Jan-1909-Jan-19
PunjabBarnala10-Jan-1910-Jan-19
PunjabBathinda01-Jan-1901-Jan-19
PunjabBathinda01-Jan-1901-Jan-19
PunjabBathinda02-Jan-1902-Jan-19
PunjabBathinda03-Jan-1903-Jan-19
PunjabBathinda04-Jan-1904-Jan-19
PunjabBathinda05-Jan-1905-Jan-19
PunjabBathinda06-Jan-1906-Jan-19
PunjabBathinda07-Jan-1907-Jan-19
PunjabBathinda08-Jan-1908-Jan-19
PunjabBathinda09-Jan-1909-Jan-19
PunjabBathinda10-Jan-1910-Jan-19
PunjabS.A.S Nagar01-Jan-1901-Jan-19
PunjabS.A.S Nagar01-Jan-1901-Jan-19
PunjabS.A.S Nagar02-Jan-1902-Jan-19
PunjabS.A.S Nagar03-Jan-1903-Jan-19
PunjabS.A.S Nagar04-Jan-1904-Jan-19
PunjabS.A.S Nagar05-Jan-1905-Jan-19
PunjabS.A.S Nagar06-Jan-1906-Jan-19
PunjabS.A.S Nagar07-Jan-1907-Jan-19
PunjabS.A.S Nagar08-Jan-1908-Jan-19
PunjabS.A.S Nagar09-Jan-1909-Jan-19
PunjabS.A.S Nagar10-Jan-1910-Jan-19
 

It Will be very useful if you can share the whole process in video.

 

Regards

Sagar

 

Calling out @Reza @John  to help out for above.

 

6 REPLIES 6
ChristianAbata
Super User II
Super User II

hi @sagar_kansal if don't care meaby I could sugest you to use this expression to get the currect date

 

formatDateTime(utcNow(),'yyyy-MM-dd')

 

suge.PNG 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi @ChristianAbata,

We need the date from the input excel table, which we use for extracting data from website and further the same date to be put in the left most column as Date column.

We do not want to use today's date in the date column.

Hi @ChristianAbata,

I am pretty new to the automate community. I went through a lot of video tutorials but did not got the solution to my problem.

Pls tell

1. What are the dynamic variable to be used for state, district, from date and to date according to the website in Web ui flow.
2. How to link the excel file on local drive to be used as inputs for the web UI flow.
3. How to create the loop to make the software read each line of excel for inputting data.
4. How to scrap the data from website as the extracted data table can vary depending on the input provided.

If you can show the process after recording Web UI flow as screenshot or screen record, it will be if immense help.

Thanks in advance for support.

Hi @ChristianAbata ,

 

Can you please help on the 4 queries.

 

thanks in advance.

@sagar_kansal  shure I think I could answer you in my video, please go to the last part in the RPA Example

https://www.youtube.com/watch?v=CFhDHdw0stE&t=3608s



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Hi @ChristianAbata ,

 

Thanks for the video link. I tried the way as suggested by you but not able to achieve the desired result.

 

Kindly visit the website link for my problem statement.

 

https://reports.dbtfert.nic.in/mfmsReports/GenWsSaleDashboardListing

 

Choose the following options

 

1. State Name: Punjab

2. District: Amritsar

3. From Date: 1-Jan-2019

4. To Date: 1-Jan-2019

 

Then generate report and further copy the table generated to local excel file and insert date column to left with date being 1-Jan-2019.

 

Then make the automation from the following excel input table present on local drive.

 

StateDistrictDate FromDate To
PunjabAmritsar01-Jan-1901-Jan-19
PunjabAmritsar01-Jan-1901-Jan-19
PunjabAmritsar02-Jan-1902-Jan-19
PunjabAmritsar03-Jan-1903-Jan-19
PunjabAmritsar04-Jan-1904-Jan-19
PunjabAmritsar05-Jan-1905-Jan-19

 

Kindly take a look and share your process to achieve the Automation. Thanks in advance.

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (3,756)