rename file with excel data :D

[elena123]

Hello everyone, 

I am still kind of new to Power Automate and excited to learn more and develop my skills! I hope you'll be able to help me fix my current problem 🙂 

I want to rename a long list of PDF documents. These PDF documents all have an individual number written on the same position inside of the document. I also have an excel list that consists of these individual numbers and a further specification (short sentence). 

My goal is to rename the pdf in the format "individual number"_"further specification". To include the individual number in the name of the pdf I have built a KI model and used the rename-function in power automate which is working very well.

However, I cannot find out how to extract the "further specification" associated with the individual number from the Excel sheet and add it to renaming the PDF. 

I hope someone can help 

Best regards, 

Elena

[Nived_Nambiar]

Hi @elena123 

to get the further specification from excel table , you can use list rows present in table action.

Assume this is the excel file where detailsare mapped

(i have used underscores in between spaces as filter operations is not supported on excel columns with spaces)

Now use list rows in table like below

See the highlighted odata filter query

indiviual_number eq 1

This will help to filter the rows based on value of indiviual_number, The output from the list rows present in table will contain only rows which have indiviual_number equal to 1, so using that you can get the further_specification data.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[elena123]

Hello Nived, 

thank you very much for your explanations. This has already helped a lot.
Could you also explain to me how I can then include the further specification into the name of the file?

Best regards and thanks a lot, 

Elena 

[Nived_Nambiar]

Hi @elena123 

I will explain how you get the file name for renamed file.

based on flow designed above , list rows action.

now we will be using compose action where we get the file name of renamed file like below

Expression used- 

concat('indiviual_number',first(outputs('List_rows_present_in_a_table')?['body/value'])?['further_specifications'],'.xlsx')

Let's take each components of it.

1. concat('indiviual_number',first(outputs('List_rows_present_in_a_table')?['body/value'])?['further_specifications'],'.xlsx')

indiviual_number represent the indiviual number value which you may get as output of some other actions and you have to insert that value here 

2. concat('indiviual_number',first(outputs('List_rows_present_in_a_table')?['body/value'])?['further_specifications'],'.xlsx')

The highlighted one will be taking output of List rows present in table action based on filter query we have applied (see the above answer). Now as i told earlier, output of list rows in table contains rows whose indiviual number is equal to 1, then we will using first function to get first row out of list rows present in table and from that we will extract further_specification value by using key further_specifications as used in above expression

3. 

concat('indiviual_number',first(outputs('List_rows_present_in_a_table')?['body/value'])?['further_specifications'],'.xlsx')

I am assuming the file to be renamed is of excel file, so have used .xlsx extension, you can use any other extension depending upon your requirement.

Now using compose action, you will get name of file to which it should be named.

Hope this helps !

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[AlexEncodian]

@elena123 

If you need a solution to extract the individual number from the PDF before doing the rest of the process, Encodian's Extract Text from Regions action might help.