You’re offline. This is a read only version of the page.
4
I have created a flow that ingests a form submission, writes the submission values to an Excel sheet, executes some formulas on the values in Excel, then retrieves the new values and sends them through in an email.
I'm able to pull the text fields into the email, but when I attempt to pull in the fields that have formulas associated to them, the values come through blank. There is no error on the flow, and the value populates without issue in Excel. However, the value does not come through on the email. I am particularly interested in ensuring that the Activity Name and Activity ID values populate.
Please see attached screenshots.
Can someone please help me resolve this issue?
Yes that is enough.
I would suggest give a try for this
After delay, use office script to refresh excel file before reading the excel data
https://powerusers.microsoft.com/t5/General-Power-Automate/refresh-excel-every-morning/td-p/1272791
Refer the link above for that
Also One more thing, if you can give a try after the above method, to validate things, check whether the excel values are retrived using list rows action in another flow
Hi @Nived_Nambiar,
Do the screenshots I sent help or would you like to see anything else in the configuration?
Thank you!
Hi @Nived_Nambiar,
Please see below flow. I just tested it with the lag and it did not resolve the issue. Please see additional screenshots. The two fields I need to populate are ActivityID and Activity Name.
Can i get the screenshot of the flow ?
I think once adding row details to excel from forms, you need to put some delay to capture row details so that formula data get updated in excel while retriving 🙂
#1
WarrenBelz
146,594
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
Share
Report
All responses (
Answers (
