Forum Discussion
How to populate the TITLE column (via Power Automate?)
Microsoftjensjakobsen1966 So out of curiosity, Do you really need the Title field to be populated? if not, you can try this and see if that fulfills your requirement.
- Go to List Settings -> Columns -> Click on "Title" -> Require that this column contains information -> Choose "No" -> Save
- From the Default view and any other view, de-select Title field
- you're a lifesaver, worked for me. Gonna start doing this when I create lists from now on
- Yes - I need the column TITLE to be populated as I will create a PowerApp on top of it.
- DhirenMehtaMSFT
Ok Thanks for the detail. So you are correct in assumption that you can't set Calculated Value based on another column as Default value. See following forum discussion which explains as to why it's not possible to set it this way.
https://social.technet.microsoft.com/Forums/en-US/9c32f6fe-9391-4e13-b297-1661dd5d7a03/error-message-the-formula-contains-references-to-fields?forum=sharepointgenerallegacySo if you are planning to use PowerApps, Can you actually create an additional column to fill out the value that you are wanting to have in that column and use it for your business logic?
- Second option would be to fire off a Flow (as you have already mentioned) once the item is created and update the Title column to the value you desire.
DhirenMehtaMSFT - thank you.
Can we take it a step further, please?
Some of my users will populate data directly from SharePoint, and others will do so from a PowerApp.
So in my view, I believe I need to make a Power Automate flow.
How would that look like?
I've tried to build one, but I get an error on the GET ITEMS, that fails. I've provided 2 screendumps:
1. The error, and the error description.
2. My attempt at the Power Automate flow
