cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Zubayer
Frequent Visitor

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

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

Zubayer_0-1625404316662.png

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. 

Zubayer_1-1625404330293.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Zubayer
Frequent Visitor

@abm thanks for your help.

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

 

Zubayer_0-1627821659388.png

 

 

Zubayer_1-1627821697781.png

 

 

Zubayer_2-1627821734333.png

 

Zubayer_3-1627821768032.png

 

View solution in original post

7 REPLIES 7
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Zubayer
Frequent Visitor

Thanks for your reply.

 

Here is the trigger

Zubayer_0-1625407198948.png

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

 

 

Hi @Zubayer 

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Zubayer
Frequent Visitor

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.

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]

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
Zubayer
Frequent Visitor

@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
Frequent Visitor

@abm thanks for your help.

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

 

Zubayer_0-1627821659388.png

 

 

Zubayer_1-1627821697781.png

 

 

Zubayer_2-1627821734333.png

 

Zubayer_3-1627821768032.png

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,691)