Hi Deepak, I love your videos. Can you tell me if it is possible to do something similar with a Sharepoint Document Library? I have a library where files are uploaded and the Authoriser name is assigned in a person column. Sometimes a file uploads and defaults the authoriser name immediately, which I don't understand but I thought if I could empty it immediately it wouldn't matter. Thanks. (Alternatively if you have any idea why a file brings its own field entry with it that would be just as helpful)
@shaiksamad1562
3 жыл бұрын
Deepak. These are the common requirements which we used to get and you have solved it by this video.. Thank for the great work
@DeepakShrivastava
3 жыл бұрын
It's my pleasure, Thanks for watching.
@cmacdhon
2 жыл бұрын
Hello Deepak. You video was enormous help. Thank you so much!
@DeepakShrivastava
2 жыл бұрын
Most welcome!
@sureshgupta2465
3 жыл бұрын
Hi Deepak, In this video you have show how to update empty value to a lookup column, can you tell me how to update a lookup column with an sharepoint value, i am getting as int error.
@DeepakShrivastava
3 жыл бұрын
Hui Suresh, To update the Lookup filed you should pass the ID of the item instead text value from your lookup list.
@RoadTripswithJesse
2 жыл бұрын
@@DeepakShrivastava can you explain? When you Update Item, the ID is from the Get Items ID, and then there is no ID to pull in. Seems like that is the question you get a lot of times
@virginiekauffman6325
2 жыл бұрын
Hi Deepak, Thanks a lot, very useful tips. I am trying to empty a user column on a library and it does not work. Does it change anything in the Body ? should I use SP.Data.LibrarynameListItem ? or is it different for a library ? here is the error I get :A type named 'SP.Data.mylibrarynameListItem' could not be resolved by the model. thank you for your help. best regards
@DeepakShrivastava
2 жыл бұрын
You should use SP.Data.Item for an example for Shared Document librray - SP.Data.Shared_x0020_DocumentsItem
@shathike4079
Жыл бұрын
Hi Deepak, this is good informative, kindly let me know, lookup field not working for date format its visible number format (i.e. 44,745) please guide me how to change as date format. Thanks
@prabhatawasthi505
3 жыл бұрын
Hi Deepak, Thanks for great work. i have a query, how to update dynamic choice field from one list to another list. please share link or tutorial if you have.
@DeepakShrivastava
2 жыл бұрын
Thank You for watching. I will add this topic to my future tutorial list.
@tdegler
2 жыл бұрын
Great video! Thank you! I am struggling to clear 2 float columns by condition. Sending null works, but sending null variable - does not work (sets column to 0). When I put "if(..., null, value)" into update, then null results also in 0. Maybe you know how to solve that...
@DeepakShrivastava
2 жыл бұрын
Thank You for watching. It should work based on what I am reading here -If(equals(items('Apply_to_each')?['floatNumber'],123),null,345.98) an example expression.
@dmp569
4 ай бұрын
Hi Deepak, thanks for the video! I was having issues getting date values in my list to be set to null and I was trying to do what you suggested. Turns out that it only works with the old flow designer, not the new one. Even with the expression I was using written the same way, if I wrote the expression in the new designer it would fail saying the input for the expression needed to be a string/date value and wouldn't accept a null. The solution for me was to write the input for the parameter in the old designer (turn off the new one) and then it worked as expected. The help from Co-pilot suggested putting a placeholder date value in (1900-01-01) but that's a hack I wasn't going to fall back on. Appreciate your help!
@gamingescape5824
3 жыл бұрын
Hi , Can you help me with one thing? I am making a list where I have different status such as not started , need more information choices in the column and a second list where status have been given technical name like for not started status it will be technical and need more information will be functional and now I want that whenever status is not started it should be assigned to technical person in the column of people picker and name of that technical person should be displayed in column as per the status selected. Can you let me know how to do that in sharepoint?
@DeepakShrivastava
3 жыл бұрын
Thank you for watching!! Your question will require some more details. I would suggest asking this on the Power Automated community forum, and maybe someone has already done this before. powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
@amrithashetty9489
2 жыл бұрын
Hi Deepak , I have created a flow for copying the list item from one column to other column is same sharepoint list , it works but when i add next new item previous copied item disappears ..please help on this
@arslanseitaly8364
2 жыл бұрын
Hi Deepak, You saved my day! Thank you man!
@DeepakShrivastava
2 жыл бұрын
You are most welcome
2 жыл бұрын
Great information Deepak. Thanks for sharing.
@DeepakShrivastava
2 жыл бұрын
Thank You for watching.
@rosariofalero9858
2 жыл бұрын
Hi Deepak, thank you so much for your video! Would you know why I am getting the following error when trying to update a user column as you described: An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.
@DeepakShrivastava
2 жыл бұрын
I need to get more details , but generally this error comes when either we have null or column does not exist
@Itsprincessa01
3 жыл бұрын
is it possible to update a lookup column with the value from a single text column?
@DeepakShrivastava
3 жыл бұрын
Look up column required ID so you have pass the ID not text value.
@ResponsibleXI
3 жыл бұрын
Doesn't null mean empty string? Whats the difference between both?
@DeepakShrivastava
3 жыл бұрын
Good question, empty string means string with 0 length but null means no value. It sounds tricky but programming see these two differently 😀😱
@debashishpanda225
2 жыл бұрын
Sir can you help me out. i am asked to get all the sites created in my SharePoint admin center to a new team site list. Means need all the data of dummy created sites into a new teamsite list using power automate. I dont know what to do. I created a new list in the team site using power automate and now i need to insert those dummy sites data using power automate. Can you help me out
@DeepakShrivastava
2 жыл бұрын
I will add this topic as a future video topic. Stay tuned.
@wasif2454
2 жыл бұрын
instead of clearing the lookup column, I wanted to update it with some value e.g; with value inside the Title column
@DeepakShrivastava
2 жыл бұрын
To update a LookUp column, you need to get the Id of the value you want to add and pass it to the lookupcolumn from Power Automate.
@cptcavernicola
3 жыл бұрын
Thank you, Deepak ..
@DeepakShrivastava
3 жыл бұрын
Thank you for watching.
@raslaankhan5146
Жыл бұрын
For me Lookupcolumn ID is not coming?
@sundrapillay6668
3 жыл бұрын
Thanks Deepak
@DeepakShrivastava
3 жыл бұрын
Welcome
@richardjames9918
2 жыл бұрын
This was terrible, the resolution is so bad that I can't see what you are typing.
Пікірлер: 40