cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LanceP
Helper I
Helper I

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

This is my current flow:

LanceP_0-1601631223568.png

LanceP_1-1601631239793.png

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?

LanceP_2-1601631357912.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @LanceP :

I tried many methods. So far, although flow can run normally, Twilio does not seem to support ‘Full Path’ and ‘Share Link’.

At present, I have not found a good way to support your needs. If you want, you can use email instead of SMS.

Best Regards,

Bof

View solution in original post

18 REPLIES 18
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @LanceP ,

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

and Filter the Image with ID Columns.

VijayTailor_0-1601633137013.png


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."

 

 

@LanceP 
Above Post reference - Image

VijayTailor_0-1601634218594.png

Thanks,

LanceP_0-1601638611595.png

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

 

Hi @LanceP ,

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

VijayTailor_0-1601639395137.png

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."

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.

LanceP_0-1601704189862.png

And this is how my flow looks now:

LanceP_2-1602224911258.png

LanceP_1-1602224865747.png

LanceP_3-1601704331323.png

 

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

LanceP_0-1601704488020.png

 

 

Hi @LanceP ,

Basically contains function not working/Supported  in Flow.

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

VijayTailor_0-1601832038287.png

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."




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

This is my current flow:

LanceP_0-1602225013063.pngLanceP_1-1602225037745.png

 

LanceP_4-1601867405154.png

Below are the results after the flow ran:

LanceP_2-1602225075487.png

 

But both these functions are empty:

LanceP_5-1601867536770.png

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

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:

1.JPG

2.JPG

Best Regards,

Bof

Hi @v-bofeng-msft ,

 

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

LanceP_1-1601970498476.png

 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (74,443)