Power Platform Community Forum Thread Details

Hello all,

I have a relatively simple flow that I can not seem to get to work correctly. I have a SharePoint list that needs to get updated when an email arrives in my inbox with an excel. The SharePoint and Excel have duplicate information but I only need to add the new items in the excel that do not exist in the SharePoint list. I have a custom ID field that I will use to compare and filter. The issue is that the data set is getting large and I want to prefilter using Odata in the 'list rows present in table' to help the flow run better without a large apply to each. The problem is that the dynamic content does not appear after this step to filter array, and also the step fails when I add the filter directly in the query. Is it not possible to filter an excel table that was just created? Or is it possible that it is because I am using dynamic content in the file name? Perhaps I am not going down the right path with this solution. Any help would be great. Thanks in advance!

Categories:

General topics

Whew lol you had me for a second, but then it kinda went left field and I am not sure what is the question or issue fully.

Here is what I will say.

Yes, you can use it after creating it. But as I do not know the error or actual issue, its not possible to tell you anything other than standard stuff

When you create a new file, especially in Excel and then a table etc., you may need to add a Wait action of 3-10 minutes, before you can access it to do what you want. And if you do a Create Table, you might also have to do a wait of a few minutes as well.

This can and is the cause of many issues.

Can you add that and try again. Also can you share exactly what the error is you are getting.

Also, because its Dynamic, there is no way to have it give Dynamic Properties in the Design time, because it has no idea what the Table is going to look like in the file, even though you are like yeah but but but... :-( sorry