Unanswered

Adding row to excel table, OneDrive file not showing up.

(0) Share

Report

Posted on by dawnryan

This is a group account; it worked fine when tested from my personal account. I've asked IT for troubleshooting, no luck. We tried pulling in the file straight from OneDrive and it wasn't recognized that way, so IT made a folder (test1, which you see below) and it doesn't work that way either. But it does find the folder.

Update to clarify: There is a table, and i have tried to add the table name, since the field has turned red. However it won't pull the table in because there's no filename, and the table name is deleted in the process of trying.

As mentioned, I have already done the process successfully from my personal account, so i'm familiar with the steps.

I think it's got to be some sort of sharing or access issue but can't find anything that makes sense.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @dawnryan

We need to convert the excel file to a table to be used in Power Automate to PowerApps. To convert the excel to Table
Open the Excel file in OneDrive
Select the Columns and Click "Format As Table"

Select the Style
Make sure to Check "My Table has headers"
You should see a new tab called "Table Design"

Give a name
Close the file
Refresh or reopen Power Automate
Now the file should show with the table name

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
dawnryan 28 on at

Like (0)

Report

OK yep, i didn't think to mention that but yes, it is a table. As mentioned at beginning of post, I have done the process successfully from my personal account. I just couldn't show the name in my screenshot: I keep adding it because of the red box, but it doesn't work because there's no filename, and in that process the table name is deleted. Filename has to come first.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @dawnryan

I see. You mentioned the account you are trying is a group account. Does the group account has a license and Access to Sharepoint?

Ideally, the excel document is stored in SharePoint, So that account should have access to Sharepoint.

Can you confirm the permission for this account?

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
dawnryan 28 on at

Like (0)

Report

Yes, the group account has license and permissions, as I’m able to see, open, and manipulate the file from the group account. The file is saved in our group OneDrive, and I can see it from within Sharepoint.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Can you make sure it uses the right account in Power Automate since sometimes it may use another account?

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No
dawnryan 28 on at

Like (0)

Report

That was a good thought! It's the right one, though.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Finally, the thought is to remove the connector altogether (Environment) and re-adding it
Create New Power Automate and try
Just curious, Can you able to access from PowerApps?

Was this reply helpful? Yes No
dawnryan 28 on at

Like (0)

Report

Hello, apologies i was out for a long weekend. Today, I have tried removing the connector and re-added; i have also started with a new Power Automate. Neither of these give different results.

In Power Apps, it's way worse LOL: Each time i get to the step where i want to get the form details, and i create that step, and i go to the next -- it changes the part about getting the details to control: apply to each

Was this reply helpful? Yes No
dawnryan 28 on at

Like (0)

Report

Need to move forward with this project, so i guess i'm going to set it up from my personal account and leave instructions for any successor to do the same.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Hi @dawnryan

Create a separate account in AD and use that account to connect the applications instead of your account. To change the account,
Go to https://make.powerapps.com/
Select the environment
Expand Dataverse on the left navigation
Click Connections
Select the connection (One drive)
Click (...) three dots and click Switch account
In this case, even an employee leaves the organization, the application still will work otherwise it will break.

Thanks,
Stalin - Learn To Illuminate

Was this reply helpful? Yes No