Power Platform Community Forum Thread Details

hello community,

I have some questions about the Get file (properties only) action in my flow. When I try to apply this action in my flow, no item has found in the site address.

But this action works perfectly fine in my other cloud flows which I don't know the reason why.

I assume that this might cause by the trigger 'when file is created' that I use to trigger the flow that has the problem. But if so, what is the reason that make these 2 triggers can't be in the same flow.

FYI, I want to create cloud flow that receive uploaded excel files from SharePoint => validate them => add to dataverse

In the validation step, I need to check the duplicate data from incoming files with other older files in the same SharePoint folder path.

Here is part of my validation code for the input excel files but I also need to do additional validation on duplicate data with older files within SharePoint.

Categories:

Building flows

Hi @deerzzxdell ,

Please try this method:

1)Click the ellipses (...) for the SharePoint step

Either

2)Click +Add new connection, add a new User (must be different from the one having this issue), and then select that user; or

3)Choose a different user from the list, if one is available

4)Add your Custom SharePoint URL (click into the List Name field after to ensure it parses)

5)Then swap back to the original account.

If the previous method doesn't work, please try this method.

There are multiple reasons for this. Sometimes, your SharePoint connection in the flow not refreshed.

If you think you have access, you can click on "Enter custom value" option and enter your site URL. It will take it. The connection will also refresh sites associated with this connection.

Best Regards,

Sunshine Gu