Want to send teams private message to users with dynamic data from my report server.

[Zubayer]

I have created a flow with "list rows present in a table" with a fixed format of excel file in table format.

Post message in a flow bot to user I selected from previous step "email address" from that excel and "Value" in message with the dynamic data which will extract from my serve. 

but when I am extracting data from my server and replacing the excel file. my flow is not working its sending only old data. 

[abm]

Whats your trigger here? Sounds like it a cache issue?

[Zubayer]

Thanks for your reply.

Here is the trigger

I used  when File is created or modified.


Problem is when I am replacing my source excel file its getting the new value that I have added in that excel.

and in the flow its showing error 

No table was found with the name '{3B9356CE-0B12-4215-97A1-6775778A92C4}'.
clientRequestId: 6548bda5-39ce-40b3-b7ae-f26806d249f8
serviceRequestId: d66d9858-8e46-436e-9640-701b753db6ad

[abm]

Hi @Zubayer 

Are you using same excel sheet template when you copy over or entirely a new one with same table name?

Thanks

[Zubayer]

No unfortunately when I extract the excel file from the server it doesn't extract as a table format. and If I do the format that excels as table and put it as the same name but that didn't work also as if replace that file with a new file with the same table name which I am using "test" it always looking for the previous table.

I checked in the peak on the code section and found every time I create a table its creates a new unique ID for that excel table.

so is it possible to get the new data that is extracting from the server to the formated excel table which is linked with this flow. 
or is there another way to replace that file.

[abm]

Hi @Zubayer 

Please have a look at this article and this may help.

Power Automate – Excel Dynamic Filename – Flow Alt Delete – Josh Cook [Microsoft MVP]

[Zubayer]

@abm Thanks for sharing the link. I hope this solves my issue. I will try and let you know the outcome. Thanks a lot. 

[Zubayer · Accepted solution]

@abm thanks for your help.

I found a solution for this. let me share what I did.