My Requirement is - To create a flow which will send email with Excel file as attachment to someone, once a order is created in power apps UI. That attachment XLSX file should have a table and its data.
Two ways I am following to make this -
1] Kept a Excel file with a empty table in OneDrive and and from the power apps, saving the data to that table and then calling a flow , which will pick that file and send an email with attachments of that file.
2] Created a flow (which accepts order data as input from power apps ) which will make Excel file on fly> then creating table dynamically > adding the data to that table > and sending email that file as attachments to destination
In both case above, getting the expected output but only in my login as I am flow owner. And for other user login both kind of flow are giving the error. "resource not found/item not found"
For 1# case-I am getting the flow error while I try to get the file content. Although the Excel file already is kept in the OneDrive.
And this error does not happen for myself as I am flow owner but for other user it happens.
For#2, Getting the below error here I am making the Excel file on a fly to login user's OneDrive.
I was trying in both ways, as it is an urgent requirement. So when the #1 did not help me I went for #2.
But none of my above ways is working. It works only for my login as I am flow owner.
Could somebody help me here, to fix this issue.
So that in other's login, no error should come.
