Hi!
I am new to Flow but are exited for the possibilityโs. My first use is to log my workhours from the flow app by buttons into excel. I have 2 buttons that work, "log timestamp" and "log absence".
But I would like to add two more who I canโt get to work.
The first is to display my current overtime which it calculated in Excel, Flow complains that the cell contains a formula and not a value. Tried to get around it but no success.
The second is to remove the latest entered row. If I maybe logged a timestamp but work some extra hours and want to redo the timestamp. I have a formula in the excel sheet which contains the correct PowerID but same problem as before. The cell contains a formula and not a value.
Can anyone think of workarounds for this?
Many thanks!!
Timestamp table___
Date Timestamp PowerAppsId
2018-05-15 2018-05-15T05:54:56.7826697Z Ut9EQWWBDns
2018-05-15 2018-05-15T15:57:56.7826697Z GOzGYQRNevs
2018-05-16 2018-05-16T05:09:51.4758652Z SdFC9io2VLM
Hi @ Sabel,
Could you please share a screenshot of the configuration of your flow?
Could you please explain more details about your requirement?
Please share more details so we could provide a proper workaround for you.
Regards,
Alice Zhang
So the Flow "Infoga rad" insert row works fine. It inserts todays date and a timestamp. Then the excel workbook, se dropbox link, calculates my current overtime when I check out for the day.
But if I want to see the current overtime I must open the workbook. Not a big task but it would be nice to ha a Flowbutton for it. Press it and get a notifikation, something like โCurrent overtime 05:32โ. And the time it would get from a specific cell in the excel workbook.
The next problem.
If I do a wrong timestamp, maybe use the wrong Flowbutton, I would like to be able to delete the latest row with the touch of a Flowbutton. I have a cell in the workbook with the PowerappID for the latest row. So something like, โdelete the row with the PowerappID you find hereโ
https://www.dropbox.com/s/yfj4aisjzbfcpru/tidrapport%20-%20kopia.xlsx?dl=0
Get Row
Delete row
Insert row
Did you solve the overtime notification issue?
(Jag vill gรถra samma sak!)
No, Flow still wont "read" a forumula in excell. ๐
(Jag anvรคnder Office 360 excel app ist fรถr att lรคsa det direkt i filen)
Power Automate User Groups are coming! Make sure youโre among the first to know when user groups go live for public preview.
User | Count |
---|---|
58 | |
47 | |
45 | |
36 | |
34 |
User | Count |
---|---|
75 | |
69 | |
59 | |
58 | |
52 |