Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

(0) Share

Report

Posted on by nleuck_101

421

Hello All,

I have a flow that creates an Excel table.

The name in the output of the Excel table will change every time the flow is ran. The Excel file lives on Sharepoint where a coworker is try to use PowerApps to connect to the table. He can't connect to the table because in Power Automate the name is always changing.
Screenshot 2023-02-16 091121.png

Do I need to change something in my flow or I should be doing something differently so the name isn't always changing?

Any help would be greatly appreciated!
Thanks,

Categories:

Process Advisor

I have the same question (0)

All responses (7)

Answers (0)

nleuck_101 421 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

Does anyone have any ideas? I would greatly appreciate any help.

Was this reply helpful? Yes No
Chriddle 8,341 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

Hard to say unless you show how you create this table.
I assume your table name is invalid (a space?).
Rename an Excel table

Was this reply helpful? Yes No
nleuck_101 421 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

@Chriddle
It's not changing the name of the table in the worksheet. It's the "name" in the "body" of the code that keeps changing. It's an alpha/numeric name that is created in the code.

Was this reply helpful? Yes No
Chriddle 8,341 Super User 2025 Season 2 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

I hope I got it now 😉
You create a new file with each flow run, therefore the file identifier changes and your coworker has to get the new identifier.

Was this reply helpful? Yes No
nleuck_101 421 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

@Chriddle

Yes, that's our dilemma.

Was this reply helpful? Yes No
nleuck_101 421 on at

Like (0)

Report

Re: Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

Does anyone know of any possible workarounds or solutions?

Thanks!

Was this reply helpful? Yes No
Chriddle 8,341 Super User 2025 Season 2 on at

Like (0)

Report

Create Excel table in Power Automate changes the name in the body so Power Apps won't find table

Your colleague needs to get the new file identifier with the Sharepoint Get files action and use its Identifier property.

Was this reply helpful? Yes No