Hi there!
I am having some issues when connecting a powerapps to an excel workbook.
Here's the problem:
In my excel I have 2 sheets, the first sheet is called parameters and the second, values. In the first sheet I have some parameters which affect directly to my values in the second sheet, like these: value1 = parameter1 * 0.05
Then, I upload these parameters into a powerapps so I can change the parameters values directly into the PowerApps. After that, I want to plot the values in a Power Bi graph.
The problem starts here: Despite in the workbook the parameter is changed, the values in the second sheet are not unless I open the Excel workbook, so I cannot visualize the values in Power Bi directly without saving manually the Excel Workbook.
I understand that the calculations are done once I have opened the Excel, however I need them to be automatically updated, so I can visualize them in Power Bi without needing to open the Excel.
Hi @jha95
I'm working in local. The Excel file has these two Sheets and the idea is: modify with PowerApps the column value of the parameters and then show the results in Power BI.
Parameters
Calculated columns (divide by 2 and multiply by 2)
Visualization in PowerBI
Changing value
Error in calculated columns
Hi @jha95
I also tried to work with the file hosted in OneDrive but it doesn't work...
Hi @jha95 ,
Are the columns in table2 all calculated columns?
If so, I'm afraid it's not supported to display calculated columns of Excel in PowerApps.
I suggest you perform calculations inside PowerApps, not inside Excel.
Here's a similar issue for your reference:
Best regards,
Hey,
Yes, this is not supported in PowerApps, but as a workaround you could use Flow to retrieve / update the calculated cells. Flow does get these calculated cells as far as they are properly formatted as a Table.
Build a Flow that gets the data and returns it to PowerApps and then do the same for updates.
Hope it helps
User | Count |
---|---|
251 | |
102 | |
94 | |
48 | |
37 |