Power Platform Community Forum Thread Details

I have a Share point list which has columns like Name, Email Id, Age, Certificate, Attachment. So, when an item is added into the list using Power Apps all the field is filled except "Certificate". Certificate file is uploaded in the "Attachment" column. I want to obtain that link and add to the Certificate column. I am aware that the link cannot be added during Form submission. So, after the form is submitted and the item is added, I want this to take place automatically.

I am not sure if I could use power automate to automatically obtain the link and fill in the Certificate column.

Any ideas? Thanks in Advance.

Categories:

General topics

@killerBee15 Can you provide more clarity on your flow logic? You've indicated that the file is added to the Attachment column. What's the reason for needing the link to display in the Certificate column? It seems a bit redundant.

In the meantime, you might be interested in this YT Tutorial:

How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

Building a Power Automate flow that will send an email with multiple SharePoint items can be a bit complex. In this video tutorial I’ll cover how to build a flow that will send a single email to each user with tasks that have been assigned to them. The logic in this flow can be applied to many different scenarios.

First, I’ll show you how to use a Filter Query to return items from your SharePoint list that meet your criteria. Then I’ll show you how to return a list of unique email addresses so that each user receives a single email. Lastly I’ll show you how to compose an email that will contain an HTML table with a list of tasks for each user.

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram