Flow for .pdf and create a SharePoint List

(0) Share

Report

Posted on by akbarmahfuzalam

709

Hello Team,

Hope someone here can help me with Flow.

Need to create a Sharepoint List with the below header.

Hope Someone can guide me on how to build this flow.

Categories:

Using flows

I have the same question (0)

All responses (19)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @akbarmahfuzalam

Are you trying to write these details in a SharePoint List? Can't see that in your diagram you provided?

Thanks

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@abm ,

As of now forgot about the Sharepoint list.
Can we achieve as per the Diagram wherein I can get all the information in Excel with the header as mention above with the help of Flow?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @akbarmahfuzalam

You could try the following:

1. Create an Excel sheet with relevant columns and a table.

2. Save the excel sheet in OneDrive or SharePoint.

3. Create a Power Automate using trigger 'when a new email arrives'.

4. Next use Excel Add a row into a table action step for inserting the values.

5. Finally map the email values to excel

Thanks

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (1)

Report

@abm ,

Thanks for the steps.

I want only the attachment which in .pdf format that detail should be saved.

What shall I used in the blank fields

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @akbarmahfuzalam

For the month column you could use the expression DateTime. Have a look at this blog

https://www.o365dude.com/2017/05/01/working-with-dates-times-in-microsoft-flow/

formatDateTime('createddatetime', 'mmmm')

Regarding the other values you need to determine and hardcode it because they are not available as dynamic properties from outlook connector.

Thanks

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@abm

Any idea or suggest any blog where I can visit and see how do I get those hardcoded expressions as in formula.

Mailbox
Folder
Subfolder
Email Type ( External/Internal)

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @akbarmahfuzalam

What I meant by hardcoded means you need to type that value directly under the action step relevant column as plain text.

Thanks

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@abm

How about the current date and time as per my local zone.

It's not giving me the current date and time as per my local zone.

Any additional setting does I need to do. because I am sending the data to SP List.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @akbarmahfuzalam

You should be able to directly map using the expression utcNow() without using the conversion.

Thanks

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@abm

Thanks for the input it really helps me a lot.

Just a couple of things left out and then my Flow will be ready for use.

MailBox ( Like whose mail the mail has entered. Suppose the sender has sent to me then It should reflect as akbar@abd.com.)
Email type (Like Internal or it is External )
And is there any way I can get the Invoice no. Possibly get into the .pdf file search for invoice no and get it pasted in the invoice column. Just a wild guess.

Was this reply helpful? Yes No