Announcements
9
I want to use the Power Automate feature to bring in a free text of our customer code into the Excel SharePoint file to allow importing into another system. This free text does not live in the MS Forms. I was looking more for a formula option or a creative way to solve this. Thanks for any suggestions.
Dear Sarah,
It still seems rather unclear where you will get the customer details ... you do not seem to mention any source or something. Without it, it is a guessing game on how to formulate the expression.
Or maybe I am just overthinking this and you do not want to get customer data somewhere, you just want to create some data from an expression or something (instead of pulling it from a source like the other fields). In that case, use the expression formula or just type in text, either one will work.
For example, if you just type 'CustomerName' in the field CUS_CODE, it will always input 'CustomerName' there.
Alternatively, you can include a formula (view screenshot), for example 'guid()' will create a random number and if you use for example concat(), you can combine different data elements (including fields from your MS FORM).
Play around with it.
Happy flowing,
Koen
To clarify, I would be using Power Automate to add a row of data to a SharePoint Excel file every time the MS Form is completed. When that row of data is added, I want to also include a value free text in its owns column that lists the text of "CUSTOMER" so I can import the template. The value of "CUSTOMER" would not be on the the form. I was thinking it would be more of a formula rule. Every time a row is added to the SharePoint Excel file, also enter the free text of "CUSTOMER" into column A, per row imported.
Dear Sarah,
Without any information on the input (format, example, location, etc) I do not think it is possible for anyone to help you along. Suggest you provide this.
Happy flowing,
Koen
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
