How to get the image files in a SharePoint folder according to their IDs?

[LanceP]

This is my current flow:

I am creating a flow to send SMS to multiple different recipients and I want to attach a picture with each of the SMS. The pictures are located in another folder in the same SharePoint site, but I am not sure how to do this based on their IDs. Can anyone provide some help with this problem?

[VijayTailor]

Hi @LanceP ,

Just Add New Column into Document Folder and Map the UserID with Spefic Image.

and Filter the Image with ID Columns.

Another way is to Make the ImageName same as the User ID.
and Filter the Image based on UserID. like FileName contains UserID.

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[VijayTailor]

@LanceP 
Above Post reference - Image

Thanks,

[LanceP]

How would I attach the image to the media url though after this step?

[VijayTailor]

Hi @LanceP ,

For this requirment , you can use the Yellow highlighted Action in Flow. 

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[LanceP]

Sorry, I don't quite get it, is this how it's suppose to go?

Now I renamed my images based on the IDs in my SP list.

And this is how my flow looks now:

And after I started the test run, this is the error I get:

[VijayTailor]

Hi @LanceP ,

Basically contains function not working/Supported  in Flow.

Better you get all the results and after that use the Condition like below.

Hope this solution helps you to resolve your issue.
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[LanceP]

After adding ' ' for the dynamic content Attendee ID, the query worked.

This is my current flow:

Below are the results after the flow ran:

But both these functions are empty:

Can't seem to get this to work even though the filtering query worked but the output is empty?

[v-bofeng-msft]

Hi @LanceP :

Do you want to get pictures in the SP library by their ID?

If so,only need to add two actions.(Get file properties/Get file content using path)

I'v made a test for your reference:

Best Regards,

Bof

[LanceP]

Hi @v-bofeng-msft ,

This is the error I get when I try this method: