Answered

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

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Zubayer 74 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Zubayer

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

Thanks

Was this reply helpful? Yes No
Zubayer 74 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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]

Was this reply helpful? Yes No
Zubayer 74 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Zubayer 74 on at

Like (1)

Report
Copy link

Link copied!

@abm thanks for your help.
I found a solution for this. let me share what I did.

Was this reply helpful? Yes No