Add attachment into sharepoint list using power automate

(0) Share

Report

Posted on by Sebey

127

I have two SharePoint list.

parent SharePoint list:Company with columns ID, email, location and other columns.

ID	email	Location	Address
101	sebey@tigray.com	Tigray	Mekelle
102	info@website.com	Axum	Maichew

child SharePoint: AssetvoucherUsers: ID, requestvid,vouchertype .. and other columns.

requestvid is a lookup column refer to Company list

ID	requestvid	vouchertype	Amount	Attachmentfile
99	101	Issue	2000
100	102	Voucher	3000
101	103	Issue	4000

I have generated PDF file using both SharePoint lists successfully.

now I want to to insert the pdf file automatically to the attachement of sharepoint list"AssetVoucherUsers"

for example: When i generate a pdf file using the ID of 101 in Company list, I want to insert that pdf file into "AssetVoucherUsers" attachemnt the ID Requestvid with value101.

but my current problem is it inserts into the ID =101 of AssetVoucherUsers

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Sebey ,

since the related items don't have the same ID, you'll have to do a lookup using the 'Get items' action to the AssetvoucherUsers lists where you search for the item whose requestvid is equal to the ID of the item in the Company list. The 'Get items' will return the corresponding item and you can use its ID to add the attachment.

Was this reply helpful? Yes No
Sebey 127 on at

Like (0)

Report

I add this above the above images,
but i am stuck what do next. help me please

Was this reply helpful? Yes No
tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report

Hello @Sebey ,

now you have to check whether the item exists and if it does use the ID output to update it as explained here.

Also, to make the Filter Query work you must add single quotes around the ID dynamic content.

Was this reply helpful? Yes No