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

[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.

[StalinPonnusamy]

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

[dawnryan]

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.

[StalinPonnusamy]

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

[dawnryan]

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.

[StalinPonnusamy]

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

Thanks,
Stalin - Learn To Illuminate

[dawnryan]

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

[StalinPonnusamy]

• 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?

[dawnryan]

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

[dawnryan]

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.