web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Updating Item in Share...

Power Automate

Unanswered

Updating Item in SharePoint when Data in Column from List A match Column from List B

(0) Share

Report

Report

Posted on by SebS

4,582 Moderator

Hello,

I have two Lists A and B

List A have a column WorkingHours what Concatenate StartTime and FinishTime columns in format 10:00-18:00

I have also List B, that one have column ShiftName and it's list of different Start Times ShiftName is in same format as WorkingHours.

List B have additional Columns like D,B,N and Hours in each depend on Time person working that Columns are also present in List A

Now I want to Update List A columns D,B,N when WorkingHours or StartTime&"-"&FinishTime are equal ShiftName

Can I ask for Help with showing me how the condition and Update item should Look to achieve this Please.

Regards

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

SebS 4,582 Moderator on at

Like (0)

Report

Is there a way in expression to concatenate two Time Value to format 10:00-18:00 ?
I'm assuming if I just concat(StartTime,"-",FinishTime) I will get String like 0.22222-0751 is there a way to format StartTime same as in excel or power apps Text(StartTime,"hh:mm")& "-" &Text(FinishTime,"hh:mm") ?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @SebS,

Do you want to concatenate two time value into string?

If so, I think you could directly use the concat() expression to achieve your need. Note that you should firstly format the date time into string using the formatedatetime().

Here is a simple demo, please check as below:

formatDateTime(utcNow(),'hh:mm')

concat(outputs('Compose'),'-',outputs('Compose_2'))

Was this reply helpful? Yes No

Join the conversation